-->
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: July 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, 238 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, 270 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,455 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, 262 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, 289 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, 294 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, 199 reads

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