A discussion of some useful metrics and why they are valuable. One I only realized the utility of recently and wanted to share.

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieve…

Every Scooby-Doo adventure has its running gags. Shaggy and Scooby bolt from every ghost in sight, Velma’s always losing her glasses, and Scrappy jumps in yelling, “Let me at ‘em!” But in this episode, Scrappy’s favorite joke is about a villain he calls Jason. Of course, Jason isn’t really a monster at all—it’s JSON, the data type we’ve been wrangling inside SQL Server and pretty much everywhere else across our technology stacks.

Page latch waits have two main causes. One is largely resolved in Microsoft SQL Server 2022, and here are some options for the other.

Ah! Hash tables! Ever since I saw a presentation by Anthony Howell ( Blog ), aka PoshWolf, about them, read the blog post by Kevin Marquette ( Blog ) about them, and was enlightened by multiple Pow…

One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved a mystery alone. Scooby and Shaggy could sniff out a clue between snacks, but it always took the rest of the Mystery Inc. gang to crack the mystery. Velma helped with her smarts, Fred with the traps, and Daphne with spotting the overlooked details—all of them used their skills to actually catch the villain.

I want to test some methods for eliminating page latch waits. Let's set up a test environment with a few tables and make sure we get the waits we expect.

Words: 593 Time to read: ~3 minutes PowerShell Scripts for Checking SQL Server Login SIDs Welcome back to T-SQL Tuesday, the monthly blogging party where we are given a topic and asked to write a b…

Postgres Blogs We’re getting more and more Postgres instances at work. To get up to speed on Postgres, I’ve started to expand my RSS feed to include Postgres blogs. It was one of those …

Words: 1100Time to read: ~ 6 minutes Nothing Welcome to T-SQL Tuesday, the monthly blog party started by Adam Machanic and maintained by Steve Jones. Each month, a different host chooses a topic fo…

Kendra Little writes and draws comics about SQL Server, D...

以诚为本赢在信誉9001cc💎稳定,快速,安全💎亚洲顶级娱乐平台,澳门财团重金打造,二十四小时客服在线,非凡体验诚...

Time to read: ~ 4 minutes Words: 730 The Initial IssueChecking under the function’s hoodUsing a dictionary insteadShift left?Using dbatoolsConnect-DbaInstanceGet-DbaDatabaseEnd I will discuss…