DROP USER fails when the user still owns a schema, a role or a table. Here is how to find those owners and hand them over safely.
Finding Deprecated Features Before They Bite
Find deprecated features with SQL Server counters, event metadata, and code searches, then separate future risk from features already removed.
SQL Server – Learning SQL Server Performance: Indexing Basics – Video
Indexes are the first step in any performance tuning exercise. Our new video course on indexing basics covers creating, analyzing and maintaining indexes.
SQL SERVER – T-SQL Errors and Reactions – Demo – SQL in Sixty Seconds #005 – Video
Many asked for a demo after our video on errors and reactions. In SQL in Sixty Seconds #005, Rick Morelan shows how SQL Server reacts to a T-SQL error.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.
Why Staging Tables Earn Their Keep
Use staging tables to preserve raw input, validate changes, separate extraction from publication, and make failed loads easier to diagnose and replay.
SQL SERVER – Technical Reference Guides for Designing Mission-Critical Solutions
While helping a friend, I found the Technical Reference Guides for Designing Mission-Critical Solutions, an interactive map of architecture guidance.