Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show004.mp3" target="_blank">Download Episode (mp3)</a> 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: * <a href="http://www.madeirasql.com/tag/parameterization-series/" target="_blank">Guy Glantser - Parameterization Series</a> * <a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/12/01/linked-server-and-performance-impact-direction-matters.aspx" target="_blank">Linchi Shea - Linked servers and performance impact: Direction matters!</a> * <a href="http://sqlblog.com/blogs/maria_zakourdaev/archive/2014/09/02/choosing-sequence-instead-of-identity-watch-your-step.aspx" target="_blank">Maria Zakourdaev - Choosing SEQUENCE instead of IDENTITY? Watch your step</a> * <a href="http://sqlbits.com/information/event12/Agenda.aspx?20140718" target="_blank">SQLBits Session Recordings</a> * <a href="http://sqlbits.com/Sessions/Event12/Latches_Spinlocks_and_Lock_Free_Data_Structures1" target="_blank">Klaus Aschenbrenner - Latches, Spinlocks, and Lock Free Data Structures</a> * <a href="http://www.sqlpass.org/24hours/2014/summitpreview/Schedule.aspx" target="_blank">24 Hours of Pass</a> * <a href="http://itknowledgeexchange.techtarget.com/sql-server/sql-pass-2014-speaker-idol-competition/" target="_blank">Denny Cherry - PASS Summit 2014 Speaker Idol Competition</a> * <a href="http://www.sqlserverdays.be/" target="_blank">SQL Server Days</a> * <a href="http://www.zdnet.com/microsoft-nosql-database-and-full-text-search-service-previews-available-on-azure-7000032836/" target="_blank">Microsoft NoSQL database and full-text search service previews available on Azure</a> * <a href="http://www.sqlskills.com/blogs/bobb/new-azure-services-evolution-servicesql-server-relationship/" target="_blank">Bob Beauchemin - New Azure services and evolution of the Service/SQL Server relationship</a> * <a href="http://dataarch.sqlpass.org/LinkClick.aspx?fileticket=9v0DNgASFmY%3d&tabid=2433" target="_blank">Stuart Ainsworth - From DBA to Data Architect: Changing Your Game (zip file for download)</a>
