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):
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.
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.
AlwaysOn resource site: http://bit.ly/AB_Denali_
PASS keynote video: http://bit.ly/AB_Denali_
Bob Dorr blog post: http://bit.ly/AB_Denali_
Brent Ozar blog post: http://bit.ly/AB_Denali_OzarAlwaysOn
Custom server roles
Mike Walsh blog post: http://bit.ly/AB_Denali_
TechEd Europe video: http://bit.ly/AB_Denali_
Intro / download: http://bit.ly/AB-Denali-Juneau
List of changed system objects