Show 4 – Push or Pull?

Two weeks have passed, and it’s time for our 4th show. As always, we have a mix of interesting stuff covering performance, data architecture, new services, tips, tricks, and much more. Among other topics, we talk about: Why pulling from a Linked Server is A LOT faster than pushing The effect of new hardware on Writelog waits Ways to improve the throughput of your data loading processes The architecture of Transaction Replication A weird bug with sequence DocumentDB, Microsoft’s new NoSQL database service String search solutions in SQL Server Why you should wear the Database Architect hat from time to time How Paul Simon is related to SQL Server Items mentioned in the show: Guy Glantser – Parameterization Series Linchi Shea – Linked servers and performance impact: Direction matters! Maria Zakourdaev – Choosing SEQUENCE instead of IDENTITY? Watch your step SQLBits Session Recordings Klaus Aschenbrenner – Latches, Spinlocks, and Lock Free Data Structures 24 Hours of Pass Denny Cherry – PASS Summit 2014 Speaker Idol Competition SQL Server Days Microsoft NoSQL database and full-text search service previews available on Azure Bob Beauchemin – New Azure services and evolution of the Service/SQL Server relationship Stuart Ainsworth – From DBA to Data Architect: Changing Your Game (zip file for download)