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

Parsing HTML in SQL Server

Watch this week's video on YouTube
Recently I was asked how to parse text out of an HTML fragment stored in SQL Server.
Over the next few seconds my brain processed...