PASS Summit 2011 Resource List : What's New in SQL Server 2012

AaronBertrand — Wed, 12 Oct 2011 15:00:00 GMT

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/

Search results matching tags 'sqlpass', 'presentations', and 'denali'

PASS Summit 2011 Resource List : What's New in SQL Server 2012