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

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

Adding Objects to our SCA Project

In my last post, I started out with a new SCA project, getting a connection to my database up and...

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 Internationally at SQLBits

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

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

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

SQL Server Script To Check Your Backup RPO Status

I recently wanted a script to tell me that for every database on a given server
What levels of backups I...

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