Migrating to SQL Server 2012

SQL Server 2012 includes several groundbreaking new features, such as AlwaysOn and Power View, that customers want to take advantage of in their environments. This Project Plan walks customers through the process of planning for and migrating to SQL Server 2012, and then walks customers step-by-step through the process of implementing each of the key new features in this release.

Contact FAQs Product Details

Planning

Welcome to SQL Server 2012
by Richard Waymire

The Case to Upgrade to SQL Server Denali
by Michael Otey

SQL Server 2012 Editions
by Michael Otey

Microsoft SQL Server 2012's Editions and Licensing
by Michael Otey

SQL Server 2012 Virtual Labs
by Michael Otey

Microsoft SQL Server 2012 Licensing Options
by Richard Waymire

Things You Might Not Know about SQL Server 2012
by Michael Otey

SQL Server 2012’s Hardware and Software Requirements
by Michael Otey

Visual Studio 2012 and SQL Server 2012 Reporting Services—Still Out of Sync
by William Vaughn

Details

Migrating

Migrating to SQL Server 2012
by Michael Otey

Upgrade Assistant for SQL Server 2012 (UAFS) and SQL Server Upgrade Advisor
by Kevin Kline

Details

Implementing SQL Server 2012's New Features

High Availability
SQL Server 2012 High Availability by Michael Otey Microsoft SQL Server 2012: AlwaysOn Availability Groups Feature by Michael Otey Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used by Denny Cherry	Planning and Implementing a SQL Server Cluster by Denny Cherry Be Invincible with AlwaysOn Availability Groups by: Brent Ozar Database Mirroring for Disaster Recovery by Robert L. Davis
Details
Power View
Introducing Microsoft Power View by Tyler Chessman Getting the Most Out of Microsoft Power View by Tyler Chessman Microsoft SQL Server 2012 Takes on Big Data with Hadoop by Michael Otey What's New in Microsoft SQL Server 2012 PowerPivot by Tyler Chessman	Improve the Performance of Data Warehouse Queries with Columnstore Indexes by Benjamin Nevarez Master Data Services and Data Quality Services by Michael Otey SQL Server 2012 BI with SQL System Center Data Warehouse by Derek Comingore & Mark Kromer Dive into SQL Server 2012 EIM Tools (DQS) by Derek Comingore & Mark Kromer
Details

Contained Databases

SQL Server 2012 Contained Databases
by Michael K. Campbell

Using SQL Server 2012 Contained Databases
by Michael Otey

Details

T-SQL
T-SQL Join Types by: Steve Stedman How to Use Microsoft SQL Server 2012's Window Functions, Part 1 by Itzik Ben-Gan Microsoft SQL Server 2012: How to Write T-SQL Window Functions, Part 2 by Itzik Ben-Gan SQL Server 2012: How to Write T-SQL Window Functions, Part 3 by Itzik Ben-Gan	Solving Gaps and Islands with Enhanced Window Functions by Itzik Ben-Gan Using the New OFFSET and FETCH NEXT Options by Eli Leiba Take Advantage of SQL Server 2012's Window Functionality by D. Yitzhak SQL Server 2012 Solutions for Median Calculation by Itzik Ben-Gan
Details
Database Administration
SQL Server 2012 Keeps Your Data a Little More Secure by Don Kiely SQL Server 2012’s INDIRECT CHECKPOINTs by Michael K. Campbell SQL Server 2012 Databases on File Shares by Denny Cherry Introduction to SQL Server Data Tools by Michael Otey	Cool New SQL Server 2012 Metadata by Kalen Delaney SQL Server’s Undocumented Changes by Kalen Delaney Using Solid State Disks in SQL Server Storage Solutions by Denny Cherry
Details

SQL Server 2012 and Windows Server

Windows Server 2012 and SQL Server 2012: Better Together
by Michael Otey

Creating a SQL Server 2012 Installation for Windows Server Core
by Michael Otey

Details

Development

New Features in SQL Server Data Tools
by Michael Otey

Details