Error 9642 in the ERRORLOG: an error occurred in a Service Broker/Database Mirroring transport connection endpoint. Here is what caused it for my client.
Listing Databases Below the Server’s Native Compatibility Level
Find databases below the native compatibility level, generate reviewable ALTER statements, and prepare Query Store checks safely.
Binary Collations: Byte-Order Sorting and Exact String Matches
Learn how a binary collation changes SQL Server sorting, exact string comparisons, index access, and column metadata checks.
Capturing Actual Execution Plans From a Script With SET STATISTICS XML
Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.
Ten SSMS Settings Worth Changing on Day One
Review ten SSMS settings for safer connections, clearer results, useful plans, and recoverable query text before starting your everyday work.
How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222
How do I know if I am DBOWNER or not in SQL Server? A DBA worried about permissions before my changes, so we ran this simple script to check db_owner membership.
Period-to-Date Totals: Today, Week, Month and Year in One Scan
Calculate period-to-date totals with shared scan boundaries, Monday-based weeks, and older date arithmetic for SQL Server reports.