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: January 2018

Using Windows stored credentials to connect to SQL in containers

I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears is that SQL Server in containers does not support Windows authentication (unless you’re using Windocks).

So when I’m working I find it quite annoying to have to specify a… Read more

2 comments, 114 reads

Posted in The DBA Who Came In From The Cold on 17 January 2018

Time to find a new place to live

Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the current flat that I’m in has run out.

There’s a bit of a housing problem in Dublin at the moment so it really hasn’t been easy but I’ve managed to… Read more

2 comments, 112 reads

Posted in The DBA Who Came In From The Cold on 15 January 2018

Friday Reading 2018-01-11

Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have hopefully found a place, let the paperwork begin!

In between running around like a madman, I’ve been reading…

Free SQL Server Quizzes
Kendra Little (t) has written a… Read more

0 comments, 145 reads

Posted in The DBA Who Came In From The Cold on 12 January 2018

Comparing two SQL instances

There’s many a time in a DBA’s life where they’ll need to compare various aspects of two SQL instances against each other.

For instance, last week I was working with two instances that contained databases part of an Always On availability group and needed to ensure that all databases on… Read more

0 comments, 147 reads

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

Roll on 2018!

Hey everyone, hope you all had a great Christmas and New Year!

I took December off from blogging as had started a new job and wanted to focus on getting to grips with my new role. But back now and have a load of ideas for new blogs!

Going to… Read more

0 comments, 161 reads

Posted in The DBA Who Came In From The Cold on 8 January 2018