Show 4 – Push or Pull?

Download Episode (mp3)
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 Struc