Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.
MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT: How to Check It Is On
MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT is a database option, so DBCC USEROPTIONS never shows it. This post reads the option from sys.databases and from DATABASEPROPERTYEX, turns it on in a demo database and finds every database that has it. It also shows a guarded script you can reuse in deployments.
Reverting a Failed Deployment With a Database Snapshot
A snapshot can undo a bad release in minutes. See what comes back, what is lost for good, and why your log backups need a fresh start.
SQL SERVER – How Do We Find Deadlocks? – Notes from the Field #086
To Find Deadlocks, I collect the graph of competing sessions and resources. The cycle distinguishes a deadlock from ordinary blocking.
SQL SERVER – Database Snapshots and Replica Causing Write Delays
Do database snapshots slow down writes? With copy on write, each snapshot adds work to every page change. Here is how they can cause write delays.
SQL SERVER – Recovering from Snapshots – Notes from the Field #078
Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.
Resetting a Test Database With Database Snapshots
Resetting a test database with SQL Server snapshots gives a fast baseline for repeatable tests; create, revert, and manage sparse files safely.