I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
2026-06-02 (first published: 2024-09-06)
7,334 reads
This short article explains how to quickly run SQL Server in a Docker container, for both Windows and Linux.
2021-08-13 (first published: 2021-08-11)
40,576 reads
In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.
2021-04-01
Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting or running a virtual machine. In this article of the series, Carlos Robles demonstrates how to connect to the SQL Server once it’s running.
2020-07-13
Carlos Robles explains how to use Azure Data Studio Notebooks to create SQL containers with Python.
2020-03-24
2,938 reads
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
2020-01-30
11,089 reads
As more shops begin automating build and deployment pipelines, it’s critical to learn about containerization. In this article, Mircea Oprea walks you through deploying an ASP.NET Core API in a Docker container.
2019-11-12
There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.
2019-09-16 (first published: 2019-09-10)
1,975 reads
The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL Server, however, has been difficult. That changed when Microsoft made SQL Server images on Docker available. In this article, Carlos Robles explains how to get started with Docker when running macOS.
2019-06-20
There are multiple ways to interact with the Docke...
2019-06-13
4,490 reads
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers
