October 12, 2011 | SQL Server, SQL Server 2012

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:

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://web.archive.org/web/*/https://connect.microsoft.com/sql/