Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.
SQL SERVER – Detecting Database Isolation Level MEMORY_OPTIMIZED_ ELEVATE_TO_SNAPSHOT
Customer reached out me with a very simple but very interesting question related to Detecting Database Isolation Level MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT.
SQL SERVER – How Do We Find Deadlocks? – Notes from the Field #086
Notes from the Field #086: John Sterrett shows how to find deadlocks in SQL Server, so you can see the root cause and finally fix them.
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.