Show 17 – It’s Scientific

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