SQL Server Radio

Show 4 – Push or Pull?


Listen Later

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)
...more
View all episodesView all episodes
Download on the App Store

SQL Server RadioBy Guy Glantser, Eitan Blumin

  • 4.6
  • 4.6
  • 4.6
  • 4.6
  • 4.6

4.6

20 ratings


More shows like SQL Server Radio

View all
TED Talks Daily by TED

TED Talks Daily

11,037 Listeners

Travel with Rick Steves by Rick Steves

Travel with Rick Steves

156 Listeners

This Week in Tech (Audio) by TWiT

This Week in Tech (Audio)

3,060 Listeners

Intelligent Machines (Audio) by TWiT

Intelligent Machines (Audio)

780 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

625 Listeners

The Indicator from Planet Money by NPR

The Indicator from Planet Money

9,530 Listeners

Cybersecurity Today by Jim Love

Cybersecurity Today

181 Listeners

The Best One Yet by Nick & Jack Studios

The Best One Yet

9,627 Listeners

.NET Rocks! by Carl Franklin and Richard Campbell

.NET Rocks!

244 Listeners

Against the Rules: The Big Short Companion by Pushkin Industries

Against the Rules: The Big Short Companion

9,738 Listeners

Cyber Security Headlines by CISO Series

Cyber Security Headlines

138 Listeners

Huberman Lab by Scicomm Media

Huberman Lab

29,249 Listeners

Reuters World News by Reuters

Reuters World News

277 Listeners

Prof G Markets by Vox Media Podcast Network

Prof G Markets

1,427 Listeners

Reuters Econ World by Reuters

Reuters Econ World

28 Listeners