SSMS 2016 – Compare Execution Plans

Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a...

Statistics for the New Data Pro

Next week at the PASS Summit I’ll be presenting a session called Statistics for the New Data Pro.
You can read...

Using Extended Events to Detect Connection Pooling

What is connection pooling? Lets start with a definition from MSDN. Connecting to a data source can be time consuming....

Data Warehouse Design Challenge: Relating a Temporal Fact Table to a Date Dimension

This past week I ran into an interesting challenge with a client. The data warehouse is capturing testing data for...

Kicking the Tires on SSIS 2016

Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...

Know Before You GO – Target Settings

The last few articles have covered various topics for the event_file and ring_buffer target. The topics range from basic queries in...

Know Before You GO – Target Settings

When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...

PASS Summit 2015

Yes, it is that time of the year again. You know, when all the nut case and normal SQL Server...

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour