Show 2 – Death to UDFs
On our 2nd show, we start by talking about our trips. Matan shares about how great SQLBits was (including the custome party), and Guy talks about WPC (Microsoft Worldwide Partner Conference). He explains what WPC is, about the Microsoft vision and its effects on the DBA’s work. We then talk about interesting blog posts, forum discussions, news and incidant we encountered in the last month: The less known but deadly drawback of User Defined Functions The real meaning of Blocking Iterators The real meaning of PAGEIOLATCH waits Perofrmance monitoring and baselines Automatic code And more.. Items mentioned in the show: Adam Machanic – Query Tuning Mastery: The Art and Science of Manhandling Paralellism Paul Randal – Knee-Jerk Wait Statistics : PAGEIOLATCH_SH Eitan Blumin – Let SQL Server Write Code for You Avi Niv – Generating Email Reports using XML Kendal Van Dyke – Troubleshooting Transactional Replication Microsoft’s unified technology event for enterprises Adam Machanic – PASS Summit 2014 and the Contradiction of Long Running Things