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 SQLSaturday 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.
Setup
Books Online
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
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
Metadata discovery / EXEC … WITH RESULT SETS
EOMONTH()
FORMAT()
Columnstore Index
List of changed system objects
Launch point for Denali BI resources
———————-
Feedback / suggestions / bug reports
http://web.archive.org/web/*/https://connect.microsoft.com/sql/
