Sep 10, 2014
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)