Azure SQL Database Reference

This section provides comprehensive technical documentation, API references, and technical specifications for Azure SQL Database.

Key Reference Areas

Azure SQL Database T-SQL Language Reference

Learn about the Transact-SQL (T-SQL) syntax, functions, and statements supported by Azure SQL Database. This includes differences from on-premises SQL Server.

• Built-in Functions
• Statements
• System Stored Procedures
• System Catalog Views

Azure SQL Database REST API Reference

Details on how to programmatically manage Azure SQL Database resources using the Azure REST API.

• Servers
• Databases
• Elastic Pools
• Firewall Rules

Azure SQL Database PowerShell Reference

Documentation for the Azure SQL Database PowerShell cmdlets to automate management tasks.

• SqlServer Cmdlets
• SqlDatabase Cmdlets
• FirewallRule Cmdlets

Azure CLI Reference for Azure SQL Database

Information on using the Azure Command-Line Interface (CLI) to manage Azure SQL Database.

• az sql db
• az sql server
• az sql vm

Azure SQL Database Features and Specifications

Detailed specifications for various features, including performance tiers, storage limits, and compatibility levels.

• Performance Tiers (DTU and vCore)
• Storage Limits
• Compatibility Levels
• Service Limits

Commonly Referenced Topics

Error Codes and Troubleshooting

A catalog of common error codes encountered with Azure SQL Database and guidance on resolving them.

View Error Codes

Security and Compliance References

Information on security features, compliance certifications, and best practices for Azure SQL Database.

Security Features

Compliance Certifications