-->
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.

Setting up SQL Server replication in containers

Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a container. Now I know very little about replication, it’s not an area of SQL that I’ve had a lot of exposure to but I’m always up for figuring stuff out… Read more

0 comments, 77 reads

Posted in The DBA Who Came In From The Cold on 13 December 2018

Attaching databases via a dockerfile – UPDATE

This has been bugging me for a while but I just haven’t had a chance to get around to revisiting it…you can read the original post I wrote here

In that post I came up with a way to attach databases to SQL running in a linux container. There’s an… Read more

0 comments, 90 reads

Posted in The DBA Who Came In From The Cold on 11 December 2018

Running a SQL Server Azure Container Instance in a virtual network

Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public IP address that was directly exposed to the internet.

Not really great as exposing SQL Server on port 1433 to the internet is generally a bad idea: –

Now I… Read more

1 comments, 251 reads

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

Running SQL Server 2019 CTP in a Docker container

If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.

I love it when a new version of SQL is released. There’s always a whole new bunch of features (and improvements to existing ones) that I want to check… Read more

8 comments, 3,356 reads

Posted in The DBA Who Came In From The Cold on 25 September 2018

Taking the Linux plunge – Update

It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running Ubuntu 16.04.

And to be honest, so far so good! The machine itself is absolutely fantastic and apart from one issue now resolved, Ubuntu has been great to use. I… Read more

1 comments, 243 reads

Posted in The DBA Who Came In From The Cold on 10 August 2018

SSL Provider error 31 when connecting to SQL in a docker container

I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio (version 0.31.4) to SQL 2017 CU9 running in a docker container. Other people seem to encountering this issue as well so am posting it so that it may be of… Read more

0 comments, 179 reads

Posted in The DBA Who Came In From The Cold on 6 August 2018

Evening or morning poll results!

And the results of the poll are in!

Evening just scraping it! So there’s a pretty even mix out there, interesting. Thanks to all who voted, was good fun reading all the comments on twitter.

A lot of morning voters said that they used to be evening people but have… Read more

0 comments, 176 reads

Posted in The DBA Who Came In From The Cold on 3 August 2018

Are you a morning or evening person?

I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting out of bed, even though I know I should.

I have friends who get up at 05:30 every day and for me, that’s the middle of the night!

It doesn’t… Read more

0 comments, 204 reads

Posted in The DBA Who Came In From The Cold on 30 July 2018

Friday Reading 2018-07-27

Phew, I’m not going to complain about the hot weather…I’ll miss it when it’s gone.

Linux Load Averages: Solving the Mystery
Good post by Brendan Gregg (t) explaining a critical metric

SQL Server on Linux – I/O internal thoughts
David Barbarin (t) on IO internals for… Read more

0 comments, 243 reads

Posted in The DBA Who Came In From The Cold on 27 July 2018

Creating SQL images in Azure with ACR Build – Part Two

EDIT – 2018-10 – ACR Build is now known as ACR Tasks

In Part One I detailed how we can use ACR Build to push SQL Server docker images to the Azure Container Registry.

But that all seems a bit manual, doesn’t it?

One of the cool things about ACR… Read more

0 comments, 1,426 reads

Posted in The DBA Who Came In From The Cold on 25 July 2018

Taking the Linux plunge

I’m a Windows guy.

Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become a bit discontent with Windows. Nothing out of the usual has contributed to this, just things like UAC, updates etc.

Now in the past, I’ve had to suck these… Read more

4 comments, 243 reads

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

Friday Reading 2018-07-20

Haven’t posted one of these for a while! It’s good to have some time back to be able to read/write.

I’ve had a pretty mixed week, but the highlight has definitely been pulling the trigger on buying a Dell XPS 13 running Ubuntu. The Dell is a pretty slick machine,… Read more

0 comments, 272 reads

Posted in The DBA Who Came In From The Cold on 20 July 2018

Creating SQL images in Azure with ACR Build – Part One

Whenever I’ve pushed images up to an Azure Container Registry I’ve been building them locally (using Docker for Windows) and then manually pushing them up. However, I don’t need to do this. What I can do instead is use the Azure Container Registry Build service.

Let’s have a look at… Read more

1 comments, 248 reads

Posted in The DBA Who Came In From The Cold on 18 July 2018

Downtime

I was speaking at a conference recently and when I bumped into a friend, the first thing she said to me was “have you burnt out yet?”

Now this was a joke but it did get me thinking. I’ve been speaking at quite a few events this year and tbh… Read more

0 comments, 185 reads

Posted in The DBA Who Came In From The Cold on 16 July 2018

SQL Saturday Cork 2018

This coming weekend (9th of June) is SQL Saturday Cork!

I’ve been really looking forward to this SQL Sat as there’s only one in Ireland each year. I’m not from Ireland but have been here for over 4 years now and the User Group in Dublin is where I… Read more

0 comments, 235 reads

Posted in The DBA Who Came In From The Cold on 4 June 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,877 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,356 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:-

docker…

Read more

0 comments, 1,637 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, 293 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,602 reads

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

Older posts