A very robust query

Some times I’m blown away by how the database will try very hard to save you from yourself :-). Consider the following example: I’ve got a table called T....

T-SQL Tuesday #198–Change Detection

This month we have a new host, Meagan Longoria, who graciously agreed to help me this month. I’ve known Meagan for a number of years and she’s been a...

Designing a Storage Load Test for SQL Server

I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...

Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database

Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding which queries consume the most DTU (Database Transaction Unit) helps prioritize tuning efforts and improve...

Redgate and Rome

I’m at the UK Redgate office today, meeting with senior leaders in all areas of the business. I was honored to be awarded a spot in our President’s Club....

Upgrading SQL Server Containers on the Laptop

I don’t have SQL Server installed on my laptop. In an effort to keep things clean and smooth in case I need to rebuild things, I’ve gone with containers....

A New Word: the Kinder Surprise

the kinder surprise – . the point in your early adolescence when you realize that your parents are muddling through their lives the same as you; that many respectable...

Get a Range of Sequence Values: #SQLNewBlogger

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks at how the proc works. Another post for me that is simple and hopefully serves...

Overcoming Imposter Syndrome: A Plan

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework (DTEF) foundation exam. I’m blogging about it because I know a lot of people struggle...

PlanTrace Now Supports PostgreSQL

PlanTrace Now Supports PostgreSQL

The same plan analysis you know from Redshift, now for PostgreSQL — including EXPLAIN ANALYZE, buffer stats, and JSON format.

When...