SQL Server Support end dates belong in upgrade planning before the deadline. My original post followed the July 2019 support transition.
SCHEMA_ONLY vs SCHEMA_AND_DATA for Memory-Optimized Tables
Compare SCHEMA_ONLY and SCHEMA_AND_DATA memory-optimized tables, inspect logging and recovery, and test an isolated offline-online cycle.
SQL SERVER – What is Wait Type Parallel Backup Queue?
Only official documentation which I could find was about wait statistics related to Parallel Backup Queue is very little available online.
Sessionizing Events: Grouping Activity Into Sessions by Idle Gap
Your events have a user and a time but no visit ID. Here is how to infer sessions from an idle gap with LAG and a running sum.
Logical Name Mismatch: master_files vs database_files
A logical name mismatch means sys.master_files and sys.database_files disagree about a file name. A tested demo shows both views on one server, and a script checks every database. The post explains the secondary replica case and its fix.
sysxmitqueue in msdb: Why It Grows and How to Clear It
Sysxmitqueue in msdb fills up when Service Broker messages cannot leave the server. A tested demo in its own database shows the pile, the reason, a one conversation cleanup and the NEW_BROKER reset. The msdb steps follow the same order.
DBCC CLONEDATABASE Error Msg 2601: Cannot Insert Duplicate Key Row in sys.sysowners
A DBCC CLONEDATABASE error that names sys.sysowners points at a database user name, not at the database owner. The queries here find the conflicting user in model and in the source database, and I tested them on SQL Server 2025 along with a clean clone.