March 17, 2011 | SQL Server

Presenting "What's New in SQL Server Denali" for WVPASS

Recently I was asked by John Sterrett (blog | twitter) to present to his SQL Server user group (WVPASS) in Wheeling, West Virginia. Well, today is the day, and I will be presenting, "What's new in SQL Server Denali" at tonight's meeting, sponsored by SQL Sentry. The slide deck is attached below; the samples are available here.

If you attended this presentation, please feel free to provide feedback at SpeakerRate.

 

File Attachment: Demos_Snippets.zip

3 comments on this post

    • Julian Kuiters - March 18, 2011, 4:18 AM

      Hi Aaron,
      I noticed in your MetaDiscovery.sql Demo 3 you say it does not work for temp tables…..
      What if you use:
      EXEC tempdb.sys.sp_describe_first_result_set N'DECLARE @x TABLE(i INT);SELECT i FROM @x;';
      EXEC tempdb.sys.sp_describe_first_result_set N'CREATE TABLE #y (j INT);SELECT j FROM #y;';
      GO
      its similar to the work around to get object_ids for temp tables

    • AaronBertrand - March 18, 2011, 5:20 AM

      Hi Julian, in this case it's not about location, it's about literal parsing. With the tempdb prefix I get the same error:
      Msg 11525, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
      The metadata could not be determined because statement 'SELECT j FROM #y;' uses a temp table.

    • Julian Kuiters - March 18, 2011, 5:33 AM

      Ah thanks Aaron
      I'm looking forward to getting my hands on Denali – quite a few of the new functionality shown in your demo scripts would be really useful on my projects

Comments are closed.