SQL Server/Database in Azure

A collection of useful links regarding SQL Server on Azure VM and PaaS SQL Database.

SQL Server on Azure VM

SQL Server on Azure VM overview

• How to provision a Windows SQL Server virtual machine in the Azure portal

Provision a Windows virtual machine with the Azure portal - SQL Server on Azure VM

• Frequently asked questions about SQL Server running on Windows virtual machines in Azure

SQL Server on Windows Virtual Machines in Azure FAQ - SQL Server on Azure VM

About SQL Server on Azure pricing

• Pricing guidance for SQL Server Azure VMs

Price guidance & managing costs - SQL Server on Azure VM

About storage configuration in SQL Server on Azure VM

• Storage Configuration Guidelines for SQL Server on Azure VM

Storage Configuration Guidelines for SQL Server on Azure VM

PssS SQL Database

SQL Database overview

What is the Azure SQL Database service? - Azure SQL Database

Comparison with SQL Server

• Feature comparison: Azure SQL Database and SQL Server

Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database…

Azure SQL Database purchase model

• Azure SQL Database purchase model

Compare the database engine features of SQL Database and SQL Managed Instance - Azure SQL Database…

• Compare SQL Server DTU and vCore roughly

DTU vs vCore in Azure SQL Database

Migrate from DTU to vCore - Azure SQL Database

Microsoft Azure SQL Database - vCore versus DTU which one to choose?

Azure SQL Database backup/recovery

• Automatic backup

Automatic, geo-redundant backups - Azure SQL Database & Azure SQL Managed Instance

• Azure SQL database recovery using automatic database backup

Restore a database from a backup - Azure SQL Database & SQL Managed Instance

Usage from application

• SQL error code for SQL Database client application: Database connection error and other issues

Troubleshoot common connection issues to Azure SQL Database - Azure SQL Database

Performance

• Find and apply performance recommendations

Apply performance recommendations - Azure SQL Database

• Detectable types of query performance bottlenecks in Azure SQL Database

Types of query performance issues in Azure SQL Database - Azure SQL

• Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views

Monitor performance using DMVs - Azure SQL Database & SQL Managed Instance

Security

• Private link to Azure SQL Database and Azure Synapse Analytics

Azure Private Link - Azure SQL Database and Azure Synapse Analytics

• Frequently Asked Questions (FAQ) for Azure Private Link

Azure Private Link frequently asked questions (FAQ)