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

A gotcha when switching partitions

When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of data from one table to another as a META DATA ONLY operation is absolutely fantastic.

What’s also cool is that we can switch data into a non-partitioned table. Makes life… Read more

0 comments, 1,182 reads

Posted in The DBA Who Came In From The Cold on 28 February 2018

Indexing and Partitioning

Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of data in and out of a table quickly is incredibly helpful.

However, partitioning comes with a whole bunch of caveats and we need to be aware of what’s going on.… Read more

0 comments, 1,313 reads

Posted in The DBA Who Came In From The Cold on 21 February 2018

Dealing with stress

Anyone who knows me will know that I’m something of a stress head. I tend to worry about things and have, in the past, let it get the better of me.

But I feel that over the last few years I’ve managed to get a handle of dealing with stress.… Read more

0 comments, 287 reads

Posted in The DBA Who Came In From The Cold on 19 February 2018

Friday Reading – Speaking Mentors

A new project underway is Speaking Mentors. I think this is an amazing idea and the response that it’s had already seems to have proved me right

There’s so many talented people involved I thought I’d put together a quick list of those who have written about the project… Read more

0 comments, 264 reads

Posted in The DBA Who Came In From The Cold on 9 February 2018

SQL Server in Kubernetes on Docker for Windows

Last week Docker announced a feature that I’ve been looking forward to for a while: –

And sure enough, when I opened Docker for Windows, there was the update: –

Let’s run through the steps to get this setup. First of all, enable the feature in settings: –

Once installed,… Read more

0 comments, 381 reads

Posted in The DBA Who Came In From The Cold on 7 February 2018

Giving back – Speaking Mentors

I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who are all experts in their respective fields.

They have (almost literally) dragged me into at first blogging, and then eventually speaking. I could not have done any of it without… Read more

0 comments, 218 reads

Posted in The DBA Who Came In From The Cold on 5 February 2018