Operate SQL Server 2012

Find resources and tools to help you better manage your SQL Server 2012 infrastructure and troubleshoot issues.

Learning Resources

• Microsoft SQL Server 2012 training
• SQL Server Certification
• Books Online for SQL Server 2012
• Tutorials for SQL Server 2012
• Technical Reference Guides for Designing Mission-Critical Solutions
• SQL Server "How do I?" Videos

Sample Code

On-Premises

• Download an AdventureWorks Database - Download an AdventureWorks OLTP or DW samples database for SQL Server 2012 or SQL Server 2008 R2, or an OLTP database for SQL Azure. You can also get more information, provide feedback, or post questions about these databases.
• DataBooster - Extension to ADO.NET Data Provider - The dbParallel DataBooster library is a high-performance extension to ADO.NET Data Provider, including... ( More)
• SSIS Restart Framework - A framework that provides restartability for SSIS 2012 projects. It is very much work in progress so...( More)
• Database Task Parallel Foundation-dbParallel for Oracle and SQL Server - The dbParallel is a Database Task Parallel Foundation that provides database developers an application level support for parallel programming. (More)
• Official Visual Studio 2010 Samples for C# 4.0 - These are the official samples for Visual Studio 2010 C# 4.0.
• 101 LINQ Samples - Learn how to use LINQ in your applications with these code samples, covering the entire range of LINQ... ( More)

Cloud

• Windows Azure SQL Reporting Admin Sample - The SQLReportingAdmin sample for Windows Azure SQL Reporting demonstrates the usage of SQL Reporting APIs, and manages (add/update/delete) permissions of SQL Reporting users.
• Windows Azure SQL Reporting ReportViewer-SOAP API usage sample - These sample projects demonstrate how to embed a Microsoft ReportViewer control that points to reports hosted on SQL Reporting report servers and how to use SQL Reporting SOAP APIs in your Windows Azure Web application.
• Enterprise Library 5.0 - Integration Pack for Windows Azure - The Microsoft Enterprise Library Integration Pack for Windows Azure is an extension to the Microsoft Enterprise Library 5.0 that can be used with Windows Azure.

Hybrid

• SQL Azure Migration Wizard - SQL Azure Migration Wizard (SQLAzureMW) is designed to help you migrate your SQL Server 2005/2008/2012 databases to SQL Azure.
• Sharding in Azure Using Custom LINQ and Custom OData Providers - This example implements a sharding sample for Azure. It shows how to implement a custom LINQ provider that contains the sharding logic. A custom OData service enables REST queries to the sharded database. Finally it compares the performance using a cloud-based load testing tool.
• Backup SQL Azure To Windows Azure Blob Storage - This sample shows how to create SQL Azure database snapshots using SQL Azure's COPY DATABASE feature and the BACPAC CTP. It demonstrates practical use of startup tasks for Azure roles and solves the burning problem of backup/restore for SQL Azure to a certain extent.

Most Popular

• Tabular AMO 2012 - Tabular AMO 2012 involves creating and managing tabular models using the AMO API. It is a sample geared for developers who are interested in managing Analysis Services.

Other Resources

Technical Guides

• SQL Server 2012 Upgrade Technical Guide
• Technical Reference Guides for Designing Mission-Critical Solutions

White Papers

• What's New in SQL Server 2012
• Migration Guide: Migrating to AlwaysOnAvailability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

TechNet Wiki

• SQL Server 2012 Early Adoption Cook Book
• E-Book Gallery for Microsoft Technologies
• White Paper Gallery for SQL Server

More TechNet Wiki...

SQL Server Technologies and Solutions