Speaking at SQL Saturday Chicago

I am so excited and honored to announce that I have been selected to speak at SQL Saturday Chicago on...

Cool Stuff in Snowflake – Part 6: Query History

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....

Information Measurement with SQL Server, Part 5.1: A Digression on the Unsuitability of Fisher Information for SQL Use Cases

By Steve Bolton
…………One of the major thrusts of my various mistutorial series has been to drive home the point that...

It’s always parameter sniffing (Part 2): SET options

This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...

Learn about the State of Database DevOps Next Week

It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...

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