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: October 2017

Friday Reading 2017-10-27

Morning all! PASS Summit is coming next week but unfortunately I can’t make it this year. I hope everyone who is going has a blast, learns some cool stuff, and meets great people.

Instead I’ll be presenting at the Southampton SQL User Group next Wednesday. Looking forward to this as… Read more

0 comments, 361 reads

Posted in The DBA Who Came In From The Cold on 27 October 2017

Enabling the SQL Server Agent in Linux Containers

At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t been able to get the SQL Agent working.

Now, one of the benefits of attending SQL Saturdays is that you get to pick the brains of a lot of very… Read more

3 comments, 1,674 reads

Posted in The DBA Who Came In From The Cold on 25 October 2017

Event Organisers

Over the last few weeks I’ve spoken at a few conferences, the last of those being SQL Relay.

For those of you who aren’t familiar with SQL Relay, it’s unique in that it’s not one event. SQL Relay is five events starting on Monday in one location and then a… Read more

0 comments, 265 reads

Posted in The DBA Who Came In From The Cold on 23 October 2017

Limiting resources available to containers

One question that I get asked regularly is, “can you limit the host resources to individual containers?”

This is a great question as you don’t want one container consuming all the resources on your host, starving all the other containers.

It’s actually really simple to limit the resources available to… Read more

0 comments, 414 reads

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

Monday Coffee: Long hours worked

Last week I asked the following question on twitter: –

I had a load of responses from a lot of DBAs out there who have worked some crazy shifts, you can see all the responses here

My personal record is due to a data centre migration. We moved all our… Read more

0 comments, 260 reads

Posted in The DBA Who Came In From The Cold on 2 October 2017