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:

Guy Glantser - DBA in the Cloud: Threat or Opportunity?
Adam Machanic - SQLCLR String Splitting Part 2: Even Faster, Even More Scalable
Erland Sommarskog - Arrays and Lists in SQL Server
24 Hours of Pass Summit Preview Edition
Julie Koesmarno - "I Want It NOW!" Data Visualization with Po