The DBA Who Came In From The Cold

Using volumes in SQL Server 2019 non-root containers

• by Andrew Pruski

• The DBA Who Came In From The Cold

I’ve seen a few people online asking how to use docker named volumes with the new SQL Server 2019 RTM images. Microsoft changed the way SQL runs within a...

2019-11-25 (first published: 2019-11-18)

339 reads

Using the GitHub Package Registry to store container images

• by Andrew Pruski

• The DBA Who Came In From The Cold

The GitHub Package Registry is available for beta testing and allows us to store container images in it, basically giving us the same functionality as the Docker Hub. However...

2019-10-23

29 reads

Running SQL Server containers as non-root

• by Andrew Pruski

• The DBA Who Came In From The Cold

Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...

2019-09-25 (first published: 2019-09-18)

288 reads

Use port forwarding to access SQL Server running in Kubernetes

• by Andrew Pruski

• The DBA Who Came In From The Cold

A really handy feature in Kubernetes is port forwarding. This can be used to narrow down an issue when connections are failing to SQL Server running in a cluster....

2019-09-17 (first published: 2019-09-04)

319 reads

Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event

• by Andrew Pruski

• The DBA Who Came In From The Cold

Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data Platform event. (It’s pronounced kay-lee btw ?? ) Brought to you by the team behind...

2019-08-23

7 reads

Chaos engineering for SQL Server running on AKS using KubeInvaders

• by Andrew Pruski

• The DBA Who Came In From The Cold

A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...

2019-07-26 (first published: 2019-07-03)

351 reads

Default resource limits for Windows vs Linux containers in Docker Desktop

• by Andrew Pruski

• The DBA Who Came In From The Cold

Docker Desktop is a great product imho. The ability to run Windows and Linux containers locally is great for development and has allowed me to really dig into SQL...

2019-07-03 (first published: 2019-06-19)

536 reads

Deploying SQL Server to an Azure Container Instance using Terraform – Part Two

• by Andrew Pruski

• The DBA Who Came In From The Cold

In a previous post I went through how to deploy SQL Server running in an Azure Container Instance using Terraform. In that post, I used hardcoded variables in the...

2019-05-28 (first published: 2019-05-15)

257 reads

Deploying SQL Server to an Azure Container Instance using Terraform – Part One

• by Andrew Pruski

• The DBA Who Came In From The Cold

A couple of weeks ago I attended John Martin’s (t) Terraform pre-con at Data in Devon. I’ve been hearing about Terraform recently so was excited to check it out....

2019-05-08

36 reads

Using docker named volumes to persist databases in SQL Server

• by Andrew Pruski

• The DBA Who Came In From The Cold

I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...

2019-03-21

384 reads