SQL Database

Official Documentation

Service Description

SQL Database integrates relational database technology as a true cloud service into the Microsoft Azure platform. This includes a relational database and a synchronization service that can be used to synchronize the content of multiple databases. The administrative overhead is kept to a minimum because it is mostly handled by Microsoft Azure. With SQL Database, Microsoft Azure is equipped with a true relational database that is interface-compatible with SQL Server. Thanks to this compatibility, SQL Database can be accessed via familiar technologies (e.g., Entity Framework, ADO.NET, JDBC) and tools (e.g., SQL Server Management Studio). In many cases, addressing the target database using the connection string for a corresponding cloud database is sufficient.

Functionally, SQL Database maps a subset of SQL Server. The familiar database constructs such as tables, views, joins, atomic transactions, data integrity for competing accesses, etc. are available. The SQL security architecture is likewise supported, with the ability to create users and to assign them permissions.

In contrast with SQL Server (including an SQL server operated in a virtual machine), SQL Database is a true cloud service. Management of the environment (configuration of hardware and system software, monitoring, patch installation, etc.) is handled completely by Microsoft Azure. Setting up a new database server with an associated database takes a matter of seconds, and a database can be deleted just as quickly. Billing is based on the duration of provisioning and the size of the database.

Getting Started

  1. 9/28/2015, Video, 0:30:43
    Azure SQL Database is a robust relational database platform for developing, deploying, and managing the data tier in a wide range of cloud-based applications. In this session,...
  2. 10/17/2018, Video, 1:04:55
    Learn about advancements in the SQL Database platform which enable it to automatically adjust to changing conditions, and accelerate your workload with zero effort on your...
  3. 9/28/2016, Video, 0:55:04
    The new built-in intelligent features in Microsoft Azure SQL Database work around the clock to learn and profile your unique app patterns, and make your apps run faster, make...
  4. 9/30/2017, Video, 1:08:56
    Azure SQL Database built-in intelligence features will maximize both performance and security of your applications, dramatically reducing the costs of running and managing...
  5. 12/7/2017, Video, 0:15:26
    Azure SQL Database is the perfect choice to deliver the right mix of operational efficiencies, optimized for performance and cost, so you can focus on business enablement to...
  6. 9/28/2017, Video, 1:12:13
    Microsoft Azure provides a broad range of services for working with data. Using these services well requires knowing at least a little bit about all of them. In this session,...
  7. 12/6/2017, Video, 0:11:01
    In this demo Lara demonstrates how with Azure you can get the most intelligent database in the planet in less than a minute. She also shows how to deploy and configure the DMS...

Upcoming Events


Latest Content

Subscribe to News about SQL Database


Web Content

SQL Database Documentation

1. SQL Database Service
     1.1. What is SQL DB
     1.2. Choose a version of Azure SQL
2. Quickstarts
     2.1. Create
          2.1.1. Single database
          2.1.2. Managed Instance
     2.2. Configure
          2.2.1. Logical server firewall rule
          2.2.2. Client VM connection to a Managed Instance
          2.2.3. Point-to-site connection to a Managed Instance
     2.3. Load data
          2.3.1. Import BACPAC into a new database
          2.3.2. Restore database backup to a Managed Instance
     2.4. Query
          2.4.1. SSMS
          2.4.2. Azure Data Studio
          2.4.3. Azure portal
          2.4.4. VS Code
          2.4.5. .NET with Visual Studio
          2.4.6. .NET core
          2.4.7. .NET with Active Directory MFA
          2.4.8. Go
          2.4.9. Java
          2.4.10. Node.js
          2.4.11. PHP
          2.4.12. Python
          2.4.13. Ruby
          2.4.14. R
3. Tutorials
     3.1. Design Azure SQL Database
          3.1.1. Design database using SSMS
          3.1.2. Design database using .NET
     3.2. Migrate to Azure SQL Database
          3.2.1. Migrate to a Single Database using DMS
          3.2.2. Migrate to a Managed Instance using DMS
     3.3. Secure your database
     3.4. Implement a geo-distributed database
     3.5. Set up Azure SQL Data Sync
4. Samples
     4.1. Code samples
     4.2. Azure CLI
     4.3. Azure PowerShell
5. Concepts
     5.1. Purchasing models
          5.1.1. Overview
          5.1.2. vCore-based model
          5.1.3. DTU model
          5.1.4. Prepay for reserved capacity
          5.1.5. Migrate from Premium RS service tier
     5.2. Compute & storage
          5.2.1. Overview
          5.2.2. General Purpose / Standard
          5.2.3. Business Critical / Premium
          5.2.4. Hyperscale
          5.2.5. Hyperscale FAQ
     5.3. Single databases
          5.3.1. Single database overview
          5.3.2. Create and manage
          5.3.3. Logical servers
      Create and manage
      Resource limits
      Connectivity architecture
      T-SQL differences
          5.3.4. Elastic pools
      Elastic pools
      Create and manage
      vCore-based resource limits
      DTU-based resource limits
      Scale resources
          5.3.5. vCore-based resource limits
          5.3.6. DTU-based resource limits
          5.3.7. Scale resources
     5.4. Managed instances
          5.4.1. Managed instances overview
          5.4.2. Managed instance capabilities
          5.4.3. Management API reference
          5.4.4. Resource limits
          5.4.5. Connectivity architecture
          5.4.6. T-SQL differences
     5.5. Platform as a Service
          5.5.1. Platform as a Service overview
          5.5.2. Business continuity
          5.5.3. High availability
          5.5.4. Automated backups
          5.5.5. Long-term backup retention
          5.5.6. Failover groups and geo-replication
      Active geo-replication
      Auto-failover groups
      Configure active geo-replication - Portal
      Configure security for replicas
          5.5.7. Database recovery options
      Recovery using backups
      Accelerated database recovery
      Outage recovery guidance
      Recovery drills
     5.6. Security
          5.6.1. Security overview
          5.6.2. Security capabilities
          5.6.3. Advanced Threat Protection
      Advanced Threat Protection
      Data discovery and classification
      Vulnerability assessment
      Threat detection
          5.6.4. Firewall rules
      Create and manage
      Virtual network endpoints
      Virtual network endpoints - PowerShell
          5.6.5. Access control
      Access control
      Logins and users
          5.6.6. Azure AD authentication
          5.6.7. Auditing
      Auditing - Servers, pools, and databases
      Auditing - Managed Instance
      Table auditing (deprecated)
          5.6.8. Dynamic data masking
          5.6.9. Always encrypted
      Use the certificate store
      Use the Azure key vault
          5.6.10. Transparent Data Encryption (TDE)
      TDE with Azure SQL
      TDE with Bring Your Own Key
     5.7. Scalability
          5.7.1. Scalability overview
          5.7.2. Scale Up/Down
          5.7.3. Read Scale-Out
          5.7.4. Database sharding
      Database sharding
      Elastic client library - consolidate
      Shard maps
      Query routing
      Manage credentials
      Move sharded data
      Elastic tools FAQ
          5.7.5. Elastic queries
          5.7.6. Elastic transactions
          5.7.7. Elastic Database jobs
     5.8. SQL features comparison
     5.9. Monitoring and tuning
          5.9.1. Monitoring and tuning overview
          5.9.2. Monitoring and performance tuning
          5.9.3. Performance monitoring
      Query Performance Insight
      Azure SQL Analytics monitoring
      Diagnostic telemetry logging
          5.9.4. Intelligent performance
      Automatic tuning
      Intelligent insights into performance
      Tuning actions and recommendations
      Database advisor performance recommendations
     5.10. Load and move data
          5.10.1. SQL Data Sync
          5.10.2. Transactional replication
     5.11. Databases features
          5.11.1. Databases features
          5.11.2. Multi-model capabilities
          5.11.3. In-memory
          5.11.4. Temporal tables
6. How-to guides
     6.1. Overview
     6.2. Single database
          6.2.1. Overview
          6.2.2. Migrate to SQL Database
          6.2.3. Manage SQL database after migration
          6.2.4. Configure replication
          6.2.5. Configure threat detection
          6.2.6. Configure backup retention using Azure blob storage
          6.2.7. Configure dynamic data masking
          6.2.8. Configure geo-replication - Portal
          6.2.9. Configure security for geo-replicas
          6.2.10. Try in-memory features
          6.2.11. Enable automatic tuning
          6.2.12. Enable e-mail notifications for automatic tuning
          6.2.13. Apply performance recommendations
          6.2.14. Create alerts
          6.2.15. Troubleshoot connectivity
          6.2.16. Configure backup retention using Azure vault (deprecated)
          6.2.17. Manage file space
          6.2.18. Use Resource Health for connectivity issues
          6.2.19. Database sharding
      Upgrade elastic database client library
      Create sharded app
      Query horizontally-sharded data
      Multi-shard queries
      Move sharded data
      Security configuration
      Add a shard
      Fix shard map problems
      Migrate sharded DB
      Create counters
      Use entity framework
      Use Dapper framework
          6.2.20. Query distributed data
      Query vertically partitioned data
      Report across scaled-out data tier
      Query across tables with different schemas
          6.2.21. Elastic Database Jobs
      Create and manage (PowerShell)
      Create and manage (T-SQL)
      Migrate (from old Elastic jobs)
     6.3. Managed instance
          6.3.1. Overview
          6.3.2. Migrate to Managed instance
          6.3.3. Migrate TDE cert to Managed instance
          6.3.4. Determine size of Managed Instance subnet
          6.3.5. Create new VNet and subnet for Managed Instance
          6.3.6. Configure existing VNet and subnet for Managed Instance
          6.3.7. Configure custom DNS
          6.3.8. Sync network configuration
          6.3.9. Find management endpoint IP address
          6.3.10. Verify built-in firewall protection
          6.3.11. Transactional replication
          6.3.12. Configure threat detection
          6.3.13. Connect applications
     6.4. Load and move data
          6.4.1. Copy a DB within Azure
          6.4.2. Import a DB from a BACPAC
          6.4.3. Export a DB to BACPAC
          6.4.4. Data sync
      Data Sync Agent
      Replicate schema changes
      Monitor with OMS
      Best practices for Data Sync
      Troubleshoot Data Sync
          6.4.5. Load data with BCP
          6.4.6. Load data with ADF
     6.5. Monitor and tune database
          6.5.1. Manual tuning
          6.5.2. Use DMVs to monitor performance
          6.5.3. Use Query store to monitor performance
          6.5.4. Troubleshoot performance with Intelligent Insights
          6.5.5. Use Intelligent Insights diagnostics log
          6.5.6. Monitor In-memory OLTP space
          6.5.7. Extended events
      Extended events
      Extended events - event file
      Extended events - ring buffer
     6.6. Configure features
          6.6.1. Configure Azure AD auth
          6.6.2. Conditional access
          6.6.3. Multi-factor AAD auth
          6.6.4. Configure multi-factor auth
          6.6.5. Configure temporal retention policy
          6.6.6. Configure TDE with BYOK
          6.6.7. Rotate TDE BYOK keys
          6.6.8. Remove TDE protector
          6.6.9. Configure In-Memory OLTP
          6.6.10. Azure Automation
     6.7. Develop apps
          6.7.1. Connectivity
          6.7.2. Working with JSON data
          6.7.3. Use Spark Connector
          6.7.4. Authenticate app
          6.7.5. Error messages
          6.7.6. Batching for perf
          6.7.7. Connectivity guidance
          6.7.8. DNS aliases
          6.7.9. DNS alias PowerShell
          6.7.10. Ports - ADO.NET
          6.7.11. C and C ++
          6.7.12. Excel
     6.8. Design applications
          6.8.1. Design for disaster recovery
          6.8.2. Design for elastic pools
          6.8.3. Design for app upgrades
          6.8.4. Multi-tenant SaaS
      SaaS design patterns
      SaaS video indexer
      SaaS app security
      Multi-tenant SaaS sample application
           Wingtip Tickets sample
           General guidance
           Standalone application
                Deploy example app
                Provision tenants
           Database per tenant
                Tutorial intro
                Deploy example app
                Provision tenants
                Monitor database performance
                Monitor with log analytics
                Restore one tenant
                Manage tenant schema
                Cross-tenant reporting
                Tenant analytics
                     With SQL DB
                     With SQL DW
           Disaster recovery using geo-restore
           Disaster recovery using database geo-replication
      Multi-tenant database
           Deploy example app
           Provision tenants
           Monitor database performance
           Run ad-hoc queries
           Manage tenant schema
           ETL for analytics
7. Reference
     7.1. Azure PowerShell
     7.2. Azure CLI
     7.3. .NET
     7.4. Java
     7.5. Node.js
     7.6. Python
     7.7. Ruby
     7.8. PHP
     7.9. T-SQL
     7.10. REST
     7.11. Resource Manager templates for SQL
     7.12. SQL Server tools
     7.13. SQL Server Management Studio (SSMS)
     7.14. SQL Server Data Tools (SSDT)
     7.15. BCP
     7.16. SQLCMD
     7.17. SqlPackage
     7.18. SQL Database Management Library package
     7.19. SQL Server drivers
          7.19.1. ADO.NET
          7.19.2. JDBC
          7.19.3. ODBC
8. Resources
     8.1. Build your skills with Microsoft Learn
     8.2. Azure Roadmap
     8.3. FAQ
     8.4. Public data sets
     8.5. Troubleshoot connectivity
     8.6. Pricing
     8.7. MSDN forum
     8.8. Stack Overflow
     8.9. Videos
     8.10. Service updates
     8.11. Architecture center
     8.12. Customer stories
     8.13. Elastic jobs (deprecated)
          8.13.1. Elastic jobs (deprecated)
          8.13.2. Install elastic job (deprecated)
          8.13.3. Create job - Portal (deprecated)
          8.13.4. Create job - Azure PowerShell (deprecated)
          8.13.5. Create job - Sample app (deprecated)
          8.13.6. Uninstall elastic job (deprecated)

Online Training Content

Date Title
5/24/2017 Developing Microsoft Azure Solutions
5/24/2017 Orchestrating Big Data with Azure Data Factory
5/24/2017 Provisioning SQL Server and Azure SQL Databases
3/24/2017 Microsoft Azure for IT Pros Content Series: Data Services
3/5/2017 Cloud Application Development
2/25/2017 SQL Database Fundamentals
2/3/2017 SQL Database Fundamentals
12/2/2016 Web and Data Application Development with Visual Studio 2017 and Azure
9/30/2016 Migrating SQL Server Databases to Azure
7/4/2016 Elastic Database Capabilities with Azure SQL DB

Page 1 of 4


Tool Description
Enable diagnostics and OMS on Azure SQL DB DescriptionThis PowerShell automation runbook enables diagnostics on a SQL Database and forward logs to OMS. The script can enable multiple SQL Servers at once and multiple SQL Databases - but also with the possibility to enable single items. 
Microsoft Data Migration Assistant Data Migration Assistant (DMA) delivers scenarios that reduce the effort to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality after an upgrade. It recommends performance and reliability improvements for your target environment. DMA replaces SQL Server Upgrade Advisor.
Azure Feature Pack for Integration Services (SSIS) SQL Server Integration Services (SSIS) Feature Pack for Azure for SQL Server 2016 is an extension that provides the following components for SSIS to connect to Azure, transfer data between Azure and on-premises data sources, and process data stored in Azure.
CloudMonix CloudMonix enhances Microsoft Azure by providing deep monitoring of most of Azure's infrastructure via live dashboards, ability to self-heal from many different production issues, on-demand historical performance and uptime reports, customizable alerts & notifications, sophisticated auto-scaling engine, integration to third party systems, and a lot more.
SQL Database Migration Wizard SQL Database Migration Wizard (SQLAzureMW) is designed to help you migrate your SQL Server 2005/2008/2012/2014 databases to Azure SQL Database.


Date Title Length
RI instance size flexibility & reservations for Azure Cosmos DB, SQL DB, and SUSE | Azure Friday
RI instance size flexibility & reservations for Azure Cosmos DB, SQL DB, and SUSE
Making AI real with SQL Server Azure databases and Azure big data analytics services - GS005
Migrating to Azure: Moving from on-premises SQL Server and Oracle databases to Azure - BRK3164
Azure SQL Database Managed Instance: Migrate SQL Servers easily to a fully managed - BRK3165
New performance and scale enhancements for Azure SQL Database - BRK3150
What's new in Azure SQL Database - your operational database in the cloud - BRK3166
In the security trenches of Azure SQL Database and Azure SQL Data Warehouse - BRK3149
Migrating to SQL Server: Removing expensive technical debt - BRK3270
Build hybrid data platform with Azure SQL Database and SQL Server - BRK2185

Page 1 of 25