SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The DBA Who Came In From The Cold

I’m Andrew Pruski and I am a SQL Server DBA with 5 years experience in database development and administration.

The online SQL Server community has helped me out immensely throughout my career, whether from providing reference material in blog posts, or answering my (sometimes obscure) questions on forums. So, to try and say thank you, I would like to contribute my own experiences in the hope that they could benefit someone out there.

So here’s my general ramblings and thoughts about working as a SQL Server DBA.

You can find me on twitter @DBAFromTheCold

If you have any feedback on my blog please send me an email to dbafromthecold@gmail.com.

Archives: May 2018

Deploying Azure Container Instances

In a previous post I went through how to Push an image to the Azure Container Registry

Now let’s look at using that image to create an Azure Container Image instance.

Azure Container Instances (ACI) are Microsoft’s serverless container technology. They allow us to spin up a container without having… Read more

0 comments, 1,987 reads

Posted in The DBA Who Came In From The Cold on 23 May 2018

Pushing SQL Server images to the Azure Container Registry

The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub).

What’s cool about this is that we can store our images in the same data centre as our deployments, so spinning up containers from the images should be pretty quick. Let’s run through setting… Read more

2 comments, 1,404 reads

Posted in The DBA Who Came In From The Cold on 9 May 2018

Loopback available for Windows Containers

The April 2018 update for Windows brought a few cool things but the best one (imho) is that now we can now connect to Windows containers locally using ‘localhost’ and the port specified upon container runtime.

Let’s have a look at how this works.

First, spin up a container:-


Read more

0 comments, 1,681 reads

Posted in The DBA Who Came In From The Cold on 7 May 2018

Friday Reading 2018-05-04

Phew, busy week. In the middle of updating presentations and making sure demos work!

Here’s a few of the articles that I’ve managed to read this week…

Containers: The Future of Database Infrastructure?
Joey D’Antoni (b|t) takes a look at containers

Open-sourcing gVisor, a sandboxed container… Read more

0 comments, 324 reads

Posted in The DBA Who Came In From The Cold on 4 May 2018

Changing the location of docker named volumes

A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know the answer to.

The question was, “can you change the location of named volumes in docker?”

This is one of the things that I love about presenting, being asked questions… Read more

0 comments, 1,680 reads

Posted in The DBA Who Came In From The Cold on 2 May 2018