Free SQL tuning tool: How’s My Database?

It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...

Partitioning 2: Getting and measuring partition elimination

In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.

Adding the partitioning...

Proposed SQL Server defaults: cost threshold for parallelism

A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...

Speaking at SQL Saturday Victoria

I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...

Speaking at SQL Saturday Victoria

I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...

Speaking Internationally at SQLBits

I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...

SQL Server 2017 Reporting Services: The Basics Part 1

I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time I...

SQLSaturday Krakow #824

Demo time – last preps!
SQL Saturday started on Friday with three preconfs. Kevin Boles, Tomasz Cieplak, Tomasz Libera & Grzegorz Stolecki did...

Where have I been?

Before you read too far, this is going to be a deeply personal post.Where do I begin? As many of...

Friend of Redgate 2019

The crew at Redgate has deemed me worthy enough to be in their Friend of Redgate program for another year....