Database Engine Tutorials
This section contains tutorials for SQL Server 2012 Database Engine.
Tutorial: Getting Started with the Database Engine
This tutorial teaches how to connect to an instance of the Database Engine.
Tutorial: SQL Server Management Studio
This tutorial introduces you to the integrated environment for managing your SQL Server infrastructure. SQL Server Management Studio presents a graphical interface for configuring, monitoring, and administering instances of SQL Server. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases and data warehouses. SQL Server Management Studio also provides Transact-SQL, MDX, DMX, and XML language editors for editing and debugging scripts.
Tutorial: Writing Transact-SQL Statements
This tutorial teaches the fundamental skills of writing the Transact-SQL statements for creating and managing objects in a SQL Server database.
Tutorial: Database Engine Tuning Advisor
This tutorial introduces you to using the advisor to examine how queries are processed, and then review recommendations for improving query performance.
Tutorial: Using the hierarchyid Data Type
This tutorial teaches how to convert a table to a hierarchical structure, and then manage the data in the table.
Tutorial: Signing Stored Procedures with a Certificate
This tutorial illustrates signing stored procedures using a certificate generated by SQL Server.
Tutorial: Ownership Chains and Context Switching
This tutorial uses a scenario to illustrate SQL Server security concepts involving ownership chains and user context switching.
Tutorial: Administering Servers by Using Policy-Based Management
This tutorial teaches how to create policies that enforce site administration standards.
Tutorial: Evaluating Best Practices by Using Policy-Based Management
This tutorial teaches how to create policies that can be used to analyze instances of the Database Engine for known issues.
Tutorial: Getting Started with SQL Server Backup and Restore to Windows Azure Blob Storage Service
This tutorial illustrates how to do a SQL Server backup and restore to the Windows Azure Blob Storage Service.