PASS Summit 2011 Resource List : What's New in SQL Server 2012
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:
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
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
Leroy Tuttle AlwaysOn Solutions Guide: http://bit.ly/AB-2012-Tuttle
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
Windowing Functions
Itzik Ben-Gan: SQL Mag article / Tech Ed Video
EOMONTH()
FORMAT()
TRY_CONVERT / PARSE / TRY_PARSE / CHOOSE / CONCAT / IIF
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
List of changed system objects
Resource Governor changes
sys.sp_server_diagnostics
Deprecated / discontinued functionality
http://bit.ly/AB_Denali_
Deprecated
http://bit.ly/AB-RC0-Discontinued
Launch point for Denali BI resources
———————-
Download SQL Server 2012 RC0 (11.0.1750)
SQL Server 2012 RC0 Developer Training Kit
Feedback / suggestions / bug reports
http://web.archive.org/web/*/https://connect.microsoft.com/sql/