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 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)