June 6, 2011 | SQL Server

SQLCruise : What's New in Denali?

During SQLCruise Alaska last week, I was tasked with presenting "What's New in Denali?" If you've been following here, or paying attention to the SQL Rally, SQL Bits or SQL Saturday circuits, you'll know that I have given this talk before. My challenge this time around: make my 60-minute presentation a 90-minute presentation. With this crowd, it was no problem; I think we spent more time on open discussion than I spent actually presenting. And to me this was a good thing – while you didn't get to see the things we were talking about, I still thought the conversations were fantastic!

Here is the deck from the session (sorry Buck, it is more than 4 slides):

Denali.pptx.zip

I also have some demo files and sample snippets. Note that most of the demo files will work on Denali CTP1; however, two of the files (08.Forceseek.sql and 09.NewDMVs.sql) will require SQL Server 2008 R2 SP1 CTP, since the DMVs and hints mentioned there are not yet in Denali.

Denali_SamplesSnippets.zip

The second demo file, 02.SSMS.sql, doesn't really help you at all, since it was meant to be an interactive demo where I would show you visually what I was doing. I do plan to write a more extensive blog post on the snippets feature specifically, but some of the benefits of the new VS shell for Management Studio are ones you just have to touch and feel for yourself.

In any case, since I cleared out a lot of the noise in the deck (mostly links), I promised a resource list, and here it is – in the order of the slides. Please note that much of the content being linked to was written months ago, and that some of the information may have changed (and continues to change) – so may not be 100% in line with what is on the slide deck above.


Setup

       http://bit.ly/AB_Denali_Setup


Books Online

       http://bit.ly/AB_Denali_BOL


AlwaysOn

AlwaysOn resource site: http://bit.ly/AB_Denali_AlwaysOn
PASS keynote video: http://bit.ly/AB_Denali_Keynote2
Bob Dorr blog post: http://bit.ly/AB_Denali_BobDorr
Brent Ozar blog post: http://bit.ly/AB_Denali_OzarAlwaysOn


Contained Databases

http://bit.ly/AB_Denali_CDBtag


Custom server roles

Mike Walsh blog post: http://bit.ly/AB_Denali_MikeWalsh


Juneau

TechEd Europe video: http://bit.ly/AB_Denali_BIDSVid

Intro / download: http://bit.ly/AB-Denali-Juneau


Programmability / SSMS

http://bit.ly/AB_Denali_SSMS


Metadata discovery / EXEC … WITH RESULT SETS

http://bit.ly/AB_Denali_Metadata


OFFSET

http://bit.ly/AB_Denali_OFFSET

SEQUENCE

http://bit.ly/AB_Denali_SEQUENCEtag

THROW

http://bit.ly/AB_Denali_THROW

EOMONTH()

http://bit.ly/AB-Denali-EOMONTH

FORMAT()

http://bit.ly/AB-Denali-Format

FORCESEEK / FORCESCAN

http://bit.ly/AB_Denali_ForceSeek

Spatial Whitepaper

http://bit.ly/AB_Denali_Spatial_WP

Columnstore Index

http://bit.ly/AB_Denali_Apollo

List of changed system objects

http://bit.ly/AB_Denali_SystemObjects

http://bit.ly/AB-Denali-SystemObjectsCTP3

Deprecated functionality

http://bit.ly/AB_Denali_Deprecated

Launch point for Denali BI resources

http://bit.ly/AB_Denali_BI

———————-

Download CTP3 (11.1103.9)

http://bit.ly/AB-Download-CTP3

Forums

http://bit.ly/AB_Denali_Forums

Feedback / suggestions / bug reports

http://web.archive.org/web/*/https://connect.microsoft.com/sql/