SQL Saturday 392 – Atlanta, GA

Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May...

Elite VMware SQL Server Workshop Wrapup

This past week I had the pleasure of being part of the second SQL Server virtualization workshop held by VMware....

Utilizing the power of table parameters to reduce IO, improve performance, decrease pollution, and achieve world peace…

I was dealing with a challenging dynamic sql procedure that allowed a .NET app to pass in a list of...

Spinach and Database Development- SQLSatExeter Keynote

Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we...

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database
MAY 1, 2015

In my last post, I discussed some of the concepts around Sharding and how we...

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager Database

Azure SQL Database Elastic Scale Part 2 - The Shard Map Manager DatabaseMAY 1, 2015

In my last post, I discussed some...

Finding Locks on Tables

Recently I needed to find a stored procedure that was creating a lock on a table and updating the table regularly. So my starting point was the table name,...

Altering a column to add NOT NULL

I had to do this recently and needed to look up the syntax as I couldn’t remember it. I don’t...

They Can Do What? – SHUTDOWN - WaterOx Consulting

Reading Time: 1 minutesMany times the DBA is faced with the dilemma of granting excessive...
The post They Can Do What?...

Running Powershell scripts remotely.

I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of...