| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | monikerRange |
|---|---|---|---|---|---|---|---|---|
Database Engine Tutorials |
Use these tutorials to learn about the SQL Server Database Engine, including getting started and using the SQL Server Management Studio. |
WilliamDAssafMSFT |
wiassaf |
02/28/2023 |
sql |
performance |
tutorial |
=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 [!INCLUDE ssdenoversion-md].
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
This tutorial illustrates how to do a SQL Server backup and restore to Azure Blob Storage.
Tutorial: Use Azure Blob Storage with SQL Server databases
This tutorial helps you understand how to store SQL Server data files in Azure Blob Storage directly.