Show 6 – It’s the Cursor

10/06/14 • 41 min

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:

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:

Previous Episode

Show 5 – Kevin Kline

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.

Items mentioned in the show:

Next Episode

Show 7 – In-Memory OLTP and Columnstore Indexes

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: