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

Better Together: Reduced Run Time and I/O

The run-time metric gets all the love, and for good reason.  It’s easily witnessed by end users and the one...

DataZen Dashboards Update

I’ve spend a good three days on and off working with the new “Microsoft” DataZen dashboard tool and I think...