Download Episode (Mp3) What do you do when you lost the admin password of Azure SQL DB? Tough SQL Server Interview Questions Should You Learn Data Science? Links mentioned in the show: OpenQueryStore Thomas LaRock – Why I’m Learning Data Science
Download Episode (mp3) A scenario where the same sessions deadlocks itself Other ways to think about parallelism Database Scoped temporary tables in Azure SQL Database Many productivity tips
Download Episode (mp3) In this show, we talk about: Why there are more and more security and encryption projects, and how wrestling is related More issues and things to take into account with the new cardinality estimator The Baader-Meinhof Phenomenon Truncating a single partition in SQL Server 2016
Download Episode (mp3) T-SQL Tuesday is the monthly blogging party of the SQL Server community. In this show, we tell stories based on the latest T-SQL Tuesday topics.
Download Episode (mp3) In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs.Simple Parameterization Some challenges when working with MySQL
Download Episode (mp3) In this show: The challenges of consolidation projects What is the Remote Query Harden error with Availability Groups PASS Summit precons Describe your profession in one sentence What if Clippy found his way to to SSMS? The right ways to manage open transactions
Download Episode (mp3) In this show of SQL Server Radio: Different types of recompile On what subject does Guy not agree with Paul White? Why the buffer cache hit ratio counter is misleading When should you stop worrying regarding the page life expectancy counter