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

Imposter syndrome

Last week I posted the following “joke” on twitter: –

I’ve called it a “joke” but I wasn’t really joking. This is a subject that I’ve wanted to talk about for a while but have really stalled on it because I don’t think that I can tackle it sufficiently, but… Read more

3 comments, 197 reads

Posted in The DBA Who Came In From The Cold on 2 April 2018

How I became a Data Platform MVP

As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how I became an MVP.

It’s not atypical but I want to share how I went from really not having any direction in my career to becoming a DBA; starting to… Read more

0 comments, 334 reads

Posted in The DBA Who Came In From The Cold on 14 March 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

1 comments, 1,777 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, 2,388 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, 322 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, 306 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, 797 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, 263 reads

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

Friday Reading 2018-01-26

It’s moving weekend! Hopefully two hard days and then I’ll be all settled in my new place. Cannot wait.

Inbetween packing all my belongings into cardboard boxes, I’ve been reading…

Linux Containers on Windows (LCOW)
Stefan Scherer (b|t) shows us how to run Linux containers side-by-side… Read more

2 comments, 198 reads

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

Configuring Persistent Storage for SQL Server in Azure Container Services

I’ve been playing around with SQL Server running in Kubernetes in Azure Container Services (AKS) for a while now and I think that the technology is really cool.

You can get a highly available instance of SQL Server up and running with a few lines of code! Ok, there’s a… Read more

1 comments, 1,176 reads

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

Perfecting my presentations

After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well, I decided to start submitting sessions to events and see what happened.

I’d presented a few lightening talks at SQL Saturdays and my local user group so I wanted to… Read more

0 comments, 200 reads

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

Friday Reading 2018-01-19

It’s been absolutely freezing here in Dublin this week. Been spending pretty much all time wrapped up indoors reading…

Discussing PASS Linux Content with OVA Winner Tracy Boggiano
Tracy Boggiano (b|t) talks to PASS about Linux content in the PASS Virtual Groups

Best newish SSMS feature Read more

0 comments, 254 reads

Posted in The DBA Who Came In From The Cold on 19 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, 276 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, 215 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, 249 reads

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

Comparing two SQL instances

Last week I was working on a couple of SQL instances that contained databases which were part of an Always On availability group, with one server being the primary and the other the secondary.

I needed to make sure that the secondary had all the databases that were on the… Read more

0 comments, 330 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, 301 reads

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

Checking SQL Configuration with Pester & Dbatools

I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing around with Pester recently and it’s pretty cool!

The script I’ve written here will use Pester & Dbatools to check all settings in sys.configurations against values stored in a .csv… Read more

0 comments, 1,513 reads

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

Friday Reading 2017-11-17

Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…

Write your first Pester test today
Rob (t) takes us through the steps to write a Pester test (something I’ve been meaning to do for ages)

How To Enlarge Your… Read more

0 comments, 249 reads

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

Newer posts

Older posts