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

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, 162 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, 110 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, 130 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, 106 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, 151 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

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 build is that we can hook it into GitHub so when we… Read more

0 comments, 1,273 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

3 comments, 198 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, 173 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, 136 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, 142 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, 182 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,723 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,299 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,561 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, 222 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,504 reads

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

Shiny Tech Syndrome

This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing since sliced bread and consequently wants to shoehorn it in to everything.

(think that person who just started learning NoSql)

I’m not singling anyone out here as we are all… Read more

1 comments, 185 reads

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

T-SQL Tuesday #101: My Essential SQL Server Tools


This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.

I’ve previously written about my Tools of the Trade but that was waaaay back in April 2016 and just after I published that blog, the tool… Read more

0 comments, 201 reads

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

Friday Reading 2018-04-06

Feels like an age since I posted some links. So busy these days!

I’m really excited today as tomorrow I head to North Carolina for two weeks. My company’s HQ is out there and I’m also presenting at SQL Saturday Raleigh next weekend. My first American SQL Sat!

Recently, when… Read more

0 comments, 206 reads

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

Changing the port for SQL Server in Azure Container Services

I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure Container Services (AKS) does mean exposing a port to the internet to allow connections.

So leaving SQL Server listening on the default port can be risky.

Now I know there’s… Read more

0 comments, 1,414 reads

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

Older posts