info@sqlidol.com     +12345678910

SQL Idol – Database Insurance

Subscribe

Azure SQL Database Architecture

By Mustafa El-MasryPosted on Posted in ArchitectureTagged , , , , No Comments on Azure SQL Database Architecture

There are four layers in Azure SQL Architecture most quite similar to on-premises

  • Client Layer
  • Service Layer
  • Platform Layer
  • Infrastructure Layer
  • Client Layer: Is the interface for applications to access a SQL database the client layer includes SQL Server tools, (ODBC), ADO.NET, (PHP) and Tabular Data Stream (TDS) is used to transfer data between a SQL database and applications. SQL Server also uses TDS to communicate with applications. This allows applications such as .NET, ODBC, ADO.NET, and Java to easily connect to Azure SQL Database without any additional requirements
  • Service Layer: acts as a gateway between the client and platform layers
  • Platform Layer: (SQL Server, Azure Fabric, Management Services) Azure Services Fabric is Responsible for Load Balancing , Automatic Failover and Automatic replication of the SQL Databases between Physical Servers https://docs.microsoft.com/en-us/azure/service-fabric/service-fabric-overview and Management Services takes care of an individual server’s health monitoring and patch updates.
  • Infrastructure Layer: Layer responsible for administrating the OS and physical hardware

Mustafa El-Masry

Microsoft Database Consultant | Performance Tuning | Cloud | Azure |SSIS | SSRS | SSAS | MCSA | MCSE | MCT | Author My Name is Mustafa Elmasry Working in Saudi Arabia KSA Since 2010 I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) for more information about my experiences and my activity for spreading the knowledge please check my webpage https://mostafaelmasry.com/about-me/  You will find on it my certification, Articles, Technical documents in Azure I participated on writing it
View all posts
Azure SQL Database Architecture

Leave a Reply

Your email address will not be published. Required fields are marked *