Show 11 – T-SQL

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
  • Our favorite and least favorite T-SQL features
  • T-SQL development best practices
  • How to avoid writing long Stored Procedures
  • How to avoid writing the “mother of all queries”
  • The Axis of Evil T-SQL featrues
  • Why you should (almost) never use table variables

Items mentioned in the show:


Show 10 – Coolest Thing Ever

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 of index builds and rebuilds
  • A new index maintenance script
  • Dangerous backups
  • And more..

Items mentioned in the show:

Show 9 – PASS Summit 2014 Recap

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 feature
  • The new Stretched Tables feature
  • Improvements to Cluster Quorum
  • Backup performance improvements
  • Database corruption recovery techniques
  • Interesting behavior of Sequence with Delayed Durability
  • The various activities during the summit
  • And more..

Items mentioned in the show:

Show 8 – SQLRally Interviews

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 our Hebrew version (of course the interviews were conducted in English).

The interviews cover a lot of topics. Among them are professional development, the future of DBA work, SQL Server 2014, storage, parallelism, virtualization and SQLCLR. If you missed it, it’s an opportunity to catch up.

After we return home, we have a lot of exciting stuff to talk about on the next shows.

Items mentioned in the show:


Show 7 – In-Memory OLTP and Columnstore Indexes

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.

We also talk about things you need to take into account and watch out for when working with them, and about the types of workloads that can benefit from them.

Items mentioned in the show:


Show 6 – It’s the Cursor

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 a threat or opportunity for DBAs?
  • The ways to pass a list of values to a Stored Procedure
  • The distribution of installations between SQL Server versions
  • Non-Blocking Sort – Is there a hidden Iterator that helps it?
  • Various presentations worth watching
  • The new SQL Server 2014 Cardinality Estimator
  • And more..


Items mentioned in the show:

Show 5 – Kevin Kline

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 2014 and where Microsoft going in the database market
  • How to take the leap from being a good DBA to being a manager
  • Why it’s important to have a mentor
  • His history at PASS, how he and the other founders envisioned it when they founded it, and what he wants to see PASS doing today
  • How the DBA role is going to change in the next few years
  • DBAs and Chauffeurs
  • Kevin’s biggest mistake
  • And more..

About Kevin:

Kevin is a renowned database expert and software industry veteran, a long-time Microsoft SQL Server MVP and noted leader in the IT industry. Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is also a top-rated speaker at industry trade shows worldwide.

Kevin Kline

Items mentioned in the show: