Serverless Azure SQL DB can show incorrect data space usage in the Portal

A quick PSA on the behaviour of Serverless Azure SQL DB space reporting in the Azure Portal. I recently had to shrink a large Azure SQL DB for cost...

SQL Agent Jobs – When Success is Failure

Have you ever run across an issue that made you take a step back and scratch your head? Recently, I had this exact situation hit my Inbox. One of...

Zeroing out a transaction log file does not use zeroes

I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not...

Daily Coping 30 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Filtering SQL Compare to a Schema

One of the things that numerous clients have some to Redgate about is allowing a team of developers to work on a single shared database without creating conflicts. While...

Moving Into Consulting 101

Introduction to this blog series

After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...

WordPress.com Design Update for a More Intuitive Experience

As technology products grow, it’s important to evolve. We’ve updated WordPress.com’s interface to make it more coherent and logical, allowing everyone to use it more intuitively.

Basic Fetch and Offset Experiments–#SQLNewBlogger

I’ve never used the FETCH or OFFSET commands for pagination, but I have heard of them. I ran across them recently and decided to experiment a bit. One note:...

Daily Coping 29 Mar 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Query Store as an Upgrade Tool

There are a lot of uses for Query Store, but one of the most interesting is as an upgrade tool. We all know that upgrades in SQL Server can...