At PASS I am giving a presentation on Denali SQL Server 2012 - What's New in Engine and Tools. In previous blog posts I've compiled a list of resources and, now that CTP3 is out, I thought I'd compile a much larger list that flows somewhat like my slide deck.
Here is the deck and sample files:
http://bit.ly/AB-PASS-2012
The second demo file, 11.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 - largely 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.
Licensing FAQ
http://bit.ly/AB-2012-Licensing
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
Leroy Tuttle AlwaysOn Solutions Guide: http://bit.ly/AB-2012-Tuttle
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
Windowing Functions
Itzik Ben-Gan: SQL Mag article / Tech Ed Video
EOMONTH()
http://bit.ly/AB-Denali-EOMONTH
FORMAT()
http://bit.ly/AB-Denali-Format
TRY_CONVERT / PARSE / TRY_PARSE / CHOOSE / CONCAT / IIF
Itzik Ben-Gan's post for SQL Mag
FORCESEEK / FORCESCAN
http://bit.ly/AB_Denali_ForceSeek
Spatial Whitepaper
http://bit.ly/AB_Denali_Spatial_WP
Columnstore Index
ColumnStore Performance Tuning: http://bit.ly/AB-2012-ColumnStoreTuning
ColumnStore Index FAQ: http://bit.ly/AB-2012-ColumnStoreFAQ
My blog post: http://bit.ly/AB_Denali_Apollo
Full-Text Search : Semantic Search
Naveen Grag's blog post
List of changed system objects
http://bit.ly/AB_Denali_SystemObjects
http://bit.ly/AB-Denali-SystemObjectsCTP3
Resource Governor changes
http://bit.ly/AB-Denali-RG
sys.sp_server_diagnostics
Joe Sack's blog - part 1 / part 2
Deprecated / discontinued functionality
http://bit.ly/AB_Denali_Deprecated
http://bit.ly/AB-RC0-Discontinued
Launch point for Denali BI resources
http://bit.ly/AB_Denali_BI
----------------------
Download SQL Server 2012 RC0 (11.0.1750)
http://bit.ly/AB-RC0-Download
SQL Server 2012 RC0 Developer Training Kit
http://bit.ly/AB-RC0-TrainingKit
Forums
http://bit.ly/AB_Denali_Forums
Feedback / suggestions / bug reports
http://connect.microsoft.com/sql/