Whitepaper : Azure SQL Database Architecture

Microsoft Azure SQL Database is the relational database service offered as a Platform as a Service on the Microsoft Azure cloud. SQL Database has evolved significantly over the years and has become a robust and highly available database platform wrapped as a service offering with specialized security features.

SQL Database is built as a shared infrastructure service, in which databases may reside alongside other customers’ databases. Also, SQL Database requires a flexible self-service architecture. Consequently, some of the traditional database concepts are implemented differently than on SQL Server, such as the master database. Also, SQL Database imposes performance constraints that vary based on your service level, such as throttling, to ensure a fair repartition of resources between tenants. Last but not least, it is important to note that SQL Database, like any other service offered on the Azure cloud, evolves rapidly with frequent updates offering enhanced management, development, and operational capabilities.

Using SQL Database is simple. Creating a database instance in SQL Database is as simple as pushing a few buttons, and within minutes you can have a fully supported, production-ready database infrastructure at your fingertips. However, you may wonder how this technology is put together; you may even ask yourself how Microsoft can guarantee high availability, or what the master database is in a SQL Database, or even how the built-in connection firewall is implemented behind the scenes, both at the server and database level.

Most database professionals can use SQL Database without understanding its underpinnings. However, it can be useful to study some of its underlying architecture to understand better how to manage SQL Database and how to adopt this technology properly in custom application development initiatives.

This whitepaper introduces SQL Database, discusses the internal architecture of SQL Database, and brings to light some of the critical concepts that are the foundation of SQL Database. This white paper also explains how some of the underlying services provide high availability, security, and replication.

Here is your download link for SQL Diagnostic Manager for SQL Server!

Please choose the file that meets your system requirements:

You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected].

Topics :

Products :

Herve Roggero

Herve Roggero is a Microsoft Azure MVP and the founder of Enzo Unified. His experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He also holds a Master’s degree in Business Administration from Indiana University. He is the co-author of “PRO SQL Azure” and “PRO SQL Server Practices” from Apress, a PluralSight author, and runs the Azure Florida Association.

Try SQL Compliance Manager FREE for 14 days


SQL-Compliance-Manager-Audit-SQL-Database-Screenshot

Monitor, audit and alert on SQL Server changes

  • Audit sensitive data to see who did what, when, where, and how
  • Monitor and alert on suspicious activity to detect and track problems
  • Satisfy audits for multiple industry regulatory requirements
  • Select from over 25 pre-defined compliance reports and create custom views
  • Lightweight data collection agent minimizes server impact

Start for Free