Download Episode (Mp3) Replicating Tables in Azure SQL Datawarehouse Persisting Statistics Sampling Rate, and Other Statistics Issues Adding Tables with Default Values Online The Microsoft Data Science Program Followup on a Previous Item Global Temp Tables in Azure SQL Database Loading a Trillion Rows into SQL Server
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 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
Download Episode (mp3) In this show, we talk about things we’ve been doing forever but might not need to do them anymore. Is parameter sniffing good or bad? Should you rebuild indexes? And what about update statistics?
Download Episode (mp3) In this show, we talk about: The GroupBy Conference Hacking Dangers in Today’s World DR in the Cloud Configuration Options you have to Change The Biggest Problem with Partitioning and How to Solve it