| title | Database Engine Tutorials | |
|---|---|---|
| description | Use these tutorials to learn about the SQL Server Database Engine, including getting started and using the SQL Server Management Studio. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.date | 02/28/2023 | |
| ms.service | sql | |
| ms.subservice | performance | |
| ms.topic | tutorial | |
| ms.custom |
|
|
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB] 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.