Of clustered indexes and ordering

There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...

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

A Week Before Networking at the PASS Summit

It’s a week before the Networking Dinner at the PASS Summit. Andy Warren and I are hosting the event next...

A Week Before Networking at the PASS Summit

It’s a week before the Networking Dinner at the PASS Summit. Andy Warren and I are hosting the event next...

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

Matching Events into Pairs

In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...

Matching Events into Pairs

In the last article I showed how to discover all of the settings that are available to a particular Target....

Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting

[2015-Oct-20]  A sourcing system failed to return correct results (returned value was a very high figure with double digit number...

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

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