Changing the location of docker named volumes

A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...

Shiny Tech Syndrome

This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...

T-SQL Tuesday #101: My Essential SQL Server Tools

This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.
I’ve...

Friday Reading 2018-04-06

Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...

Changing the port for SQL Server in Azure Container Services

I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...

Imposter syndrome

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

I’ve called it a “joke” but I wasn’t really joking. This...

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

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

Indexing and Partitioning

Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of...

Summary of my Partitioning Series

Partitioning Basics – Part 1 – Creating Partitions
Partitioning Basics – Part 2 – Splitting/Merging Partitions
Partitioning Basics – Part 3 – Switching Data
Partitioning and filegroup restores
Update to...