Show 17 – It’s Scientific

Download Episode (mp3)
On show 17, we start the show with a small small-talk about a few cool researches.
We then dive in to SQL Server and talk about:

Backup and DR to Azure
Weird lock behavior
Isolation Levels Visualization
The risk of SQL Server ownership chaining
Parallelism, Max Degree of Parallelism and Cost Threshold for Parallelism
Azure row level security
And more..

Items mentioned in the show:

Tony Hawk Rides the Hover Board
Michael J Swart - Visualizing Transaction Isolation Levels for SQL Server
Eyal Golombek - The Risk of Ownership Chaining