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:

 

 

Leave a Reply