Brent Ozar Unlimited® Weekly Links, October 19th Edition

2025's Optimized Locking

Great overview and technical resource.

Denial of Service Attack

SQL Server 2025 and Azure SQL DB can call external REST APIs, but can run you out of worker threads.

CHECKDB on Managed Instances

Needs enough free disk space to copy the entire database.

Rare Query Store Bug

Queries can have the database_id in it, which can cause problems if you restore to a different database_id.

Blocked Query Reports

How to roll them yourself in AWS with Lambda. Man, this seems kinda ... convoluted ... for something that should really be built into the engine.

The Meaning of Database

DuckDB users think about a database as being the place where data lives, but not necessarily the place where the queries happen.

Things to Know

If you get cancer. Sobering. Hug your loved ones today.

Dog Camera Takes Pictures

Whenever the dog's heart rate spikes. Because I couldn't leave you on a downer of a link.