Azure SQL

  • A fully managed database built upon the SQL Server engine.
  • SLA durability up to 99.995%.
  • SQL Databases Resource type:
    • Single Database – offers serverless and hyperscale storage (up to 100TB).
    • Elastic Pool – a collection of databases with a shared set of resources.
    • Database Server – manage groups of single databases and elastic pools.
  • SQL Managed Instances are for migrations “lift-and-shift” to the cloud.
    • The features of both SQL Server database engine and Azure SQL are available in SQL Managed Instance. 
      • PaaS benefits – Azure will handle all infrastructure management.
      • Business continuity – the data are protected with automated backups.
      • Security and compliance – supports native VNet implementation and it is exposed only through a private IP address.
      • Management operations –  automatically deploy new instances, update instance properties, and delete instances that are no longer needed.
    • Automate the migration of existing SQL Server instance to SQL Managed Instance with Azure Data Migration Service
    • Azure Hybrid Benefit for SQL Server allows you to exchange existing licenses to get discounted rates on SQL Managed Instance.
  • SQL Virtual Machines are used for applications requiring OS-level access.
  • Endpoint: <server_name>
  • vCore-based service tiers:
    • General Purpose is for common workloads.
    • Hyperscale is appropriate for online transaction processing (OLTP) and hybrid transactional analytical workloads (HTAP).
    • Business Critical is best for OLTP applications with high transaction rates and low IO latency.
  • Azure Hybrid Benefit for SQL Server enables you to use your SQL Server licenses to pay a reduced rate on Azure SQL.
  • Azure Data Studio is a modern cross-platform database tool with customizable code snippets, lightning-fast IntelliSense, useful peek definitions, and an integrated terminal to run other SQL tools.
  • IT Certification Category (English)728x90


  • You can use Intelligent Insights to continuously monitor your Azure SQL usage and detect disruptive events that may lead to poor database performance.
  • Azure SQL Analytics can be used to monitor your databases across multiple subscriptions. It can collect and visualize key performance metrics of your databases and enables you to create custom monitoring rules and alerts.
  • Automatic tuning in Azure SQL continuously monitors queries executed on your database, and automatically improves the performance using artificial intelligence. 


  • Private endpoint connections provide access to all databases in the server.
  • Allow communications from all resources inside the Azure boundary with firewall rules.


  • You can use Advanced Data Security (ADS) for data classification, vulnerability assessment, and advanced threat protection.


  • The resources are billed hourly at a fixed rate based on the service tier and compute size you choose.
  • You are billed for outgoing Internet traffic.


Pass your AWS and Azure Certifications with the Tutorials Dojo Portal

Tutorials Dojo portal

Our Bestselling AWS Certified Solutions Architect Associate Practice Exams

AWS Certified Solutions Architect Associate Practice Exams

Enroll Now – Our AWS Practice Exams with 95% Passing Rate

AWS Practice Exams Tutorials Dojo

Enroll Now – Our Azure Certification Exam Reviewers

azure reviewers tutorials dojo

Tutorials Dojo Study Guide and Cheat Sheets eBooks

Tutorials Dojo Study Guide and Cheat Sheets-2

FREE Intro to Cloud Computing for Beginners

FREE AWS Practice Test Samplers

Browse Other Courses

Generic Category (English)300x250

Recent Posts