Guy Ya'akobovitch

We Don’t Have a Name for This Show

Published on 14 September 2017 by Guy Ya'akobovitch

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

Tough SQL Server Questions

Published on 31 August 2017 by Guy Ya'akobovitch

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

Deadlocks, Parallelism and Productivity

Published on 17 August 2017 by Guy Ya'akobovitch

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

It’s 2017! Stop Doing That! – Part 2

Published on 8 June 2017 by Guy Ya'akobovitch

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

It’s 2017! Stop Doing That! – Part 1

Published on 27 April 2017 by Guy Ya'akobovitch

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?

Robin Sparkles

Published on 13 April 2017 by Guy Ya'akobovitch

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

Author: Guy Ya'akobovitch