Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths

Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...

Azure SQL Database and Transaction Log

Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...

Careful with Session_Context()–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full

Shrink log file for log_reuse_wait_desc =...

[[ This is a content summary only. Visit my website for full links, other content, and more!...

Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full

Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

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

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