Learn how to manage your Azure SQL databases.

This tutorial covers the key tasks involved in managing your Azure SQL databases, from creating and configuring them to monitoring performance and managing security.

Create an Azure SQL database

Follow these steps to create a new Azure SQL database in the Azure portal.


CREATE DATABASE MyDatabase

Configure your Azure SQL database

Modify your database settings to optimize performance and security.


ALTER DATABASE MyDatabase
SET FAMILY=S

Monitor your Azure SQL database performance

Track your database's performance using the Azure portal or Azure Monitor.


SELECT * FROM sys.dm_exec_requests

Performance Monitoring

Understand your database's resource usage and identify potential bottlenecks.

Security

Implement security best practices to protect your data.

Backup and Restore

Create regular backups of your database to protect against data loss.