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

Friday Reading 2017-06-30

Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up early to watch it tomorrow, the team selection is here.

But anyway, this week I’ve been reading…

Using SQL Server Diagnostics
Arun Sirpal goes through how to use… Read more

0 comments, 127 reads

Posted in The DBA Who Came In From The Cold on 30 June 2017

Persisting data in docker containers – Part Two

Last week in Part One I went through how to mount directories from the host server into a docker container in order to persist data.

However, you don’t have to do this in order to share volumes between containers. Another method is to create named volumes within the docker ecosystem… Read more

1 comments, 1,021 reads

Posted in The DBA Who Came In From The Cold on 28 June 2017

Monday Coffee: Attending Conferences

Last week I asked the following question on Twitter: –

I was interested to see the responses as I wanted to know how more experienced presenters get the time off to speak at so many events. Up until now I’ve been using annual leave and this was a way of… Read more

4 comments, 149 reads

Posted in The DBA Who Came In From The Cold on 26 June 2017

Friday Reading 2017-06-23

The weather has been absolutely boiling here in Dublin all week, I’m dying for a cold beer! Anyway, whilst drinking beer I’ll be reading…

Docker Basics Webinar Q&A: Understanding Union Filesystems, Storage & Volumes
Webinar (with transcript) going into the storage concepts behind docker containers

Continuous Delivery to Microsoft Azure… Read more

0 comments, 188 reads

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

Persisting data in docker containers – Part One

Normally when I work with SQL instances within containers I treat them as throw-away objects. Any modifications that I make to the databases within will be lost when I drop the container.

However, what if I want to persist the data that I have in my containers? Well, there are… Read more

0 comments, 1,081 reads

Posted in The DBA Who Came In From The Cold on 21 June 2017

Monday Coffee: SQL Saturday Dublin

Last weekend was SQL Saturday Dublin, and it was a good one.

My session on An introduction to SQL Server & Containers was the first one of the day, scheduled for 8am; now for me that’s great as I tend to get a bit nervous beforehand so having the… Read more

0 comments, 136 reads

Posted in The DBA Who Came In From The Cold on 19 June 2017

Friday Reading 2017-06-16

Been looking forward to this weekend for a while now as it’s SQLSaturday Dublin tomorrow. I did a lightening talk at SQLSat Dublin 2016 and am really chuffed to have a full session this year. There’s a whole bunch of great sessions, Bob and the team always put on a… Read more

0 comments, 168 reads

Posted in The DBA Who Came In From The Cold on 16 June 2017

Changing default location for docker containers

A question that regularly comes up when I talk about containers is, “can you specify where the containers/images live on the host?”

This is a good question as the install for docker is great because it’s so simple but bad because well, you don’t get many options to configure.

It… Read more

1 comments, 896 reads

Posted in The DBA Who Came In From The Cold on 14 June 2017

GroupBy Conference – SQL Server & Containers

Morning all, busy week last week as I was lucky enough to have my session on SQL Server & Containers in the top ten voted for sessions in GroupBy’s June conference.

This was my first webinar and even though it was nerve wracking, I’m really glad I did it. An… Read more

0 comments, 153 reads

Posted in The DBA Who Came In From The Cold on 12 June 2017

Friday Reading 2017-06-09

Exciting day today as I’m presenting my first webinar on SQL Server & Containers in the GroupBy June conference! There’s a whole bunch of other great sessions going on there today, I highly recommend that you check them out.

Been a busy week but when I’ve had some time I’ve… Read more

0 comments, 311 reads

Posted in The DBA Who Came In From The Cold on 9 June 2017

Identifying failed queries with extended events

Back to some core SQL this week and one of my favourite features, extended events.

Introduced in SQL Server 2008 they are a big improvement on SQL profiler, in the amount of information that can be tracked (more) and the impact that they have on the system (less).

If you… Read more

1 comments, 172 reads

Posted in The DBA Who Came In From The Cold on 7 June 2017

Monday Coffee – Lab Environments

Having a lab environment is an absolute must for any IT professional. You need somewhere that you can test out code and new functionalities with zero risk. But where’s the best place to host?

My lab is in Azure, it’s convenient and (relatively) cheap but there is one problem with… Read more

0 comments, 138 reads

Posted in The DBA Who Came In From The Cold on 5 June 2017

Friday Reading 2017-06-02

The weather in Dublin has reverted to type (aka rain) but hopefully we’ll get some sun this weekend! This week I’ve been doing a lot of work with powershell so what I’ve been reading kinda focuses on that…

GitHub – PowerShell Module for Docker
A powershell module for docker!

Parsing… Read more

0 comments, 295 reads

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