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)