Download Episode (mp3) Did you know that SQL was initially called “Sequel” (Structured English Query Language)? On this show, we go back to basics and talk about our favorite language – Transact-SQL (T-SQL). We cover a lot of topics in the fields of development, performance and maintenance. Among them: The logical phases of query processing
Download Episode (mp3) On previous shows, we talked about an interesting behavior of the Sort operator and missing nodes in execution plans. On this show, we finally have the explanation for those Phenomenons. In addition, we talk about: What needs does Azure DocumentDB come to address Common mistakes with Parameterization in SQL Server Tracking Page Splits Tracking progress
Download Episode (mp3) PASS Summit 2014 is over, and wh’re here for a recap of what happened, what was announced, what we learned in the sessions we attended, and some thoughts on the direction Microsoft is heading. Among other topics, we talk about: The summit keynote and the Microsoft vision Parallelism The new Query Store
Download Episode (mp3) We’re currently at PASS Summit, and things are pretty busy here, so we didn’t manage to record a new show. Instead, we republish an episode which features interviews with 3 of the top experts in the industry: Brent Ozar, Denny Cherry and Adam Machanic. They were recorded a year ago at SQLRally Amsterdam for
Download Episode (mp3) On this in-depth show, we take a deep dive into the two biggest features of SQL Server 2014: In-Memory OLTP (aka Hektaon) and Clustered Columnstore Indexes. We talk about the data structures of the two features, how they differ from the traditional data structures, and why they allow such staggering performance boosts.
Download Episode (mp3) It’s the monthly all-over-the-place version of the show, and this time we have a mix of various topics like the cloud, T-SQL development, performance, SQL Server 2014, events and presentation skills. We also have some more mystery around the Non-Blocking Sort issue from earlier shows. More specifically, we talk about: Is the cloud
Download Episode (mp3) On show 5, we have our first guest – Kevin Kline! We talk with Kevin about various topics, covering professional development, the direction of Microsoft, SQL Server 2014, the role of the DBA, and more. Specifically, we cover: How well Microsoft is keeping up with the competition What Kevin thinks about SQL Server