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

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

Excel BI Tip #26: Using a Data Spreadsheet or Tab

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

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

On Software and OS Lifecycle Management

An Important Rule: 
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...

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

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

SQL Server in Microsoft Azure: How to gain performance by flexibility and save costs at the same time

Using the SSIS Object Variable as a Data Flow Source

Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In...

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