-->
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.

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, 115 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, 115 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, 97 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, 129 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, 757 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, 122 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, 246 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

0 comments, 137 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, 107 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, 259 reads

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

Parsing Docker Commands

Bit of a powershell themed post this week as I haven’t had that much time to research so this one falls firmly into the “what I’ve been doing this week” category.

My company moved to using containers a while ago now, it’s been really fun setting up and I’ve written… Read more

0 comments, 620 reads

Posted in The DBA Who Came In From The Cold on 31 May 2017

Monday Coffee 2017-05-29

I’ve always said that this blog is my way of giving back to the SQL Server community but there is also another reason I write, to learn.

I was chatting with a friend the other day who was thinking about start to write a blog and he was asking me… Read more

0 comments, 120 reads

Posted in The DBA Who Came In From The Cold on 29 May 2017

Friday Reading 2017-05-26

The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this weekend! Hope the weather is the same wherever you are, here’s some reading (to be done outside )…

Experienced DBA: Rookie Mistake
John Morehouse tells us about a mistake he… Read more

0 comments, 232 reads

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

Disabling the identity cache in SQL Server 2017

One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable the cache that SQL keeps on identity values by using the ALTER DATABASE SCOPED CONFIGURATION command.

What disabling the cache will do is prevent any gaps in the IDs happening… Read more

2 comments, 1,377 reads

Posted in The DBA Who Came In From The Cold on 24 May 2017

Monday Coffee 2017-05-22

I hope everyone had a good weekend. I spent mine watching probably the most dismal performance of rugby I’ve seen for a long time but there’s still a bunch of matches on before the end of the season so fingers crossed for the next one (not to mention the Lions… Read more

0 comments, 200 reads

Posted in The DBA Who Came In From The Cold on 22 May 2017

Friday Reading 2017-05-19

Everyone finished patching all their servers? In-between patching this week I’ve been reading…

Why VS Code Increases my Productivity
Rob talks about how using Visual Studio Code as his primary IDE increases his output

The Setup
Jessie Frazelle talks about her hardware, OS and software configs.

Try new SQL Server… Read more

0 comments, 186 reads

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

Update to DBCC LOGINFO in SQL Server 2017

One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called sys.dm_db_log_info

This new DMF is intended to replace the (not so) undocumented DBCC LOGINFO command. I say undocumented as I’ve seen tonnes of blog posts about it but never an… Read more

0 comments, 273 reads

Posted in The DBA Who Came In From The Cold on 17 May 2017

Monday Coffee 2017-05-15

After the latest cyber attack I’ve had a fun weekend making sure all my devices are fully up-to-date with the latest patches. If you’re unaware of what’s been happening, you can read about it here.

I took this as an opportunity to go over all my backups as well.… Read more

0 comments, 195 reads

Posted in The DBA Who Came In From The Cold on 15 May 2017

Friday Reading 2017-05-12

The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been stuck inside this week I’ve been reading…

Why PowerShell?
Why indeed? Anthony Nocentino talks about why he got into powershell

Thoughts on public speaking / presenting / teaching
Erin Stellato… Read more

0 comments, 161 reads

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

Copying files from/to a container

Last week I was having an issue with a SQL install within a container and to fix I needed to copy the setup log files out of the container onto the host so that I could review.

But how do you copy files out of a container?

Well, thankfully there’s… Read more

1 comments, 215 reads

Posted in The DBA Who Came In From The Cold on 10 May 2017

Older posts