Show 6 – It’s the Cursor




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show006.mp3" target="_blank">Download Episode (mp3)</a> 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: * <a href="http://www.madeirasql.com/dba-in-the-cloud/" target="_blank">Guy Glantser - DBA in the Cloud: Threat or Opportunity?</a> * <a href="http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx" target="_blank">Adam Machanic - SQLCLR String Splitting Part 2: Even Faster, Even More Scalable</a> * <a href="http://www.sommarskog.se/arrays-in-sql.html" target="_blank">Erland Sommarskog - Arrays and Lists in SQL Server</a> * <a href="http://www.sqlpass.org/24hours/2014/summitpreview/Sessions.aspx" target="_blank">24 Hours of Pass Summit Preview Edition</a> * <a href="http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7290" target="_blank">Julie Koesmarno - "I Want It NOW!" Data Visualization with Power View</a> * <a href="http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7276" target="_blank">Kalen Delaney - In-Memory OLTP Internals: How is a 30x Performance Boost Possible?</a> * <a href="http://www.sqlpass.org/24hours/2014/portuguese/Sobre.aspx" target="_blank">24 Hours of Pass Portuguese Edition</a> * <a href="http://www.sqlpass.org/24hours/2014/ss2014launch/Home.aspx" target="_blank">24 Hours of Pass SQL Server 2014 Edition</a> * <a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7151" target="_blank">Sunil Agarwal - SQL Server 2014: In-Memory OLTP for Database Administrators</a> * <a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7158" target="_blank">Sunil Agarwal - Columnstore Technical Deep Dive</a> * <a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7159" target="_blank">Jimmy May - Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit</a> * <a href="https://www.sqlsaturday.com/360/eventhome.aspx" target="_blank">SQLSaturday Israel</a> * <a href="http://www.mssqltips.com/sqlservertip/3322/sql-server-video--tricks-to-play-on-your-dba--1/" target="_blank">Aaron Bertrand - Tricks to play on your DBA</a> * <a href="http://www.madeirasql.com/courses/course-catalog/sql-server-2014/" target="_blank">Madeira Course - What’s New in SQL Server 2014?</a>