SQL Server Dynamic Pivot

Often when trying to pivot data you wont know what the possible values that you need to pivot on, in...

SQL Azure Databases - Active Secondary - How to configure? - Part 1

Dear all,

I have taken the azure dive at last 🙂
In case if you are new to azure, azure is the Microsoft...

Removing an App Service Plan in Azure

In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...

Configure Distribution Database

In this blog, we are going to learn about the Distribution database, how to configure the Distribution database, and how...

Using JSON In SQL Server 2016

The new JSON bits in SQL Server 2016 give you the ability to pull stuff out of JSON and to...

GroupBy conference recording of Introducing the SQL Server 2016 Query Store available now!

Good news!

The recording of my session “Introducing the SQL Server 2016 Query Store” at the GroupBy conference 2 weeks ago...

SQL Nexus Wrap Up

This past week, I presented a preconference session and regular session at this year’s SQL Nexus conference in Copenhagen, Denmark. I...

Redgate Alexa Contest Winners!

A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...

Trace Flag 1117 Growth and Contention

In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth...

Trace Flag 1117 Growth and Contention

In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth...