| title | Database Engine Tutorials | Microsoft Docs |
|---|---|
| description | Use these tutorials to learn about the SQL Server Database Engine, including getting started and using the SQL Server Management Studio. |
| ms.custom | |
| ms.date | 08/02/2016 |
| ms.prod | sql |
| ms.prod_service | database-engine, sql-database |
| ms.reviewer | |
| ms.technology | performance |
| ms.topic | conceptual |
| ms.assetid | 32bd8af8-a832-4dc8-afff-01668e6b2b51 |
| author | WilliamDAssafMSFT |
| ms.author | wiassaf |
| monikerRange | =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] This section contains tutorials for [!INCLUDEssDECurrent].
Tutorial: Getting Started with the Database Engine
This tutorial teaches how to connect to an instance of the [!INCLUDEssDE].
Tutorial: SQL Server Management Studio
This tutorial introduces you to the integrated environment for managing your [!INCLUDEssNoVersion] infrastructure. [!INCLUDEssManStudioFull] presents a graphical interface for configuring, monitoring, and administering instances of [!INCLUDEssNoVersion]. It also allows you to deploy, monitor, and upgrade the data-tier components used by your applications, such as databases and data warehouses. [!INCLUDEssManStudioFull] also provides [!INCLUDEtsql], 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 [!INCLUDEtsql] statements for creating and managing objects in a [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion].
Tutorial: Ownership Chains and Context Switching
This tutorial uses a scenario to illustrate [!INCLUDEssNoVersion] 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: SQL Server Backup and Restore to Azure Blob Storage Service
This tutorial illustrates how to do a SQL Server backup and restore to the Azure Blob Storage Service.
Tutorial: Using the Microsoft Azure Blob storage service with SQL Server 2016 databases
This tutorial helps you understand how to store SQL Server data files in the Azure Blob storage service directly.
Tutorials for SQL Server 2016
TechNet WIKI: SQL Server 2012 Samples