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: December 2016

Saturday Reading 2016-12-17

It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-

The Most Important Role of a SQL Server DBA
Back to basics, Angela Tidwell talks about what the most important task of a DBA is (can you guess?)

Don’t blink you might READPAST… Read more

0 comments, 325 reads

Posted in The DBA Who Came In From The Cold on 17 December 2016

Presenting with SQL Server Management Studio

Short one this week as it’s the usual madness on the lead up to Xmas!

One of the cool things that was mentioned in the AMA that the SQL Server Team did back in November was a quick and easy way to setup SSMS for presenting.

N.B. – This only… Read more

4 comments, 655 reads

Posted in The DBA Who Came In From The Cold on 14 December 2016

Monday Coffee 2016-12-12

Speaking and presenting

One of my biggest fears is public speaking and judging by this article, I’m not alone.

However it’s something that I’ve always wanted to do and as such this year I’ve done a few lightening talk sessions at various events. For those that don’t know, a… Read more

0 comments, 272 reads

Posted in The DBA Who Came In From The Cold on 12 December 2016

Friday Reading 2016-12-09

One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to get my family, I’ll be reading…

Mr Robot killed the Hollywood hacker
Article on MIT Tech Review about how hacking is depicted in Mr Robot.

Understanding Scan Count 0, Logical… Read more

0 comments, 347 reads

Posted in The DBA Who Came In From The Cold on 9 December 2016

SQL Server & Containers – Part Four

In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of SQL Server in containers.

This post follows on from Part Three in which we uploaded a custom image to the docker repository.

The three previous posts have all been… Read more

4 comments, 2,018 reads

Posted in The DBA Who Came In From The Cold on 7 December 2016

Monday Coffee 2016-12-05

You are the DBA your company makes you. Aren’t you?

SQL Server has such a wide range of features that no DBA role will implement all of them. So, you use a certain subset in each role that you occupy throughout your career. What those features are depends on the… Read more

0 comments, 292 reads

Posted in The DBA Who Came In From The Cold on 5 December 2016

Friday Reading 2016-12-02

Another week almost over so here’s a random selection of articles that I’ve been reading…

Changing the SQL Server port on Linux
Denis Gobo goes through the process of changing the port that an instance of SQL Server running on Linux is listening on

Reload a table quickly
Kenneth Fisher… Read more

0 comments, 346 reads

Posted in The DBA Who Came In From The Cold on 2 December 2016