Microsoft Azure SQLデータベース 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.
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 Databases and how to adopt this technology properly in custom application development initiatives.
The 9-page whitepaper “Windows Azure SQL Database Architecture” 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.
The author, 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.
Click here to read the whitepaper.
SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It supports Azure SQL Database.
ER/Studio データアーキテクト is a powerful data modeling tool, and enables companies to discover, document, and re-use data assets. It supports data modeling operations for Azure SQL Database.
DB Artisan protects data security by managing permissions and privileges for cloud and on-premises deployments of SQL Server, Azure SQL Database, Oracle Database, PostgreSQL, and more.
SQL Doctor analyzes cloud and on-premises deployments of Microsoft SQL Server (including Azure SQL Database) to generate expert recommendations with executable scripts to improve security and performance.
