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. 10/3/2016, Webpage
    Follow this SQL database training to learn how to create, configure, and develop with Azure SQL database, a relational cloud database based on the Microsoft SQL Server engine.
  2. 10/3/2016, Webpage
    The elastic database features of Azure SQL Database are designed to simplify data tier development and management especially for Software as a Service (SaaS) developers—where...
  3. 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,...
  4. 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...
  5. 12/10/2015, Mva
    Interested in Azure SQL Database? Be sure to watch this session! Azure SQL Database is a robust relational database platform for developing, deploying, and managing the data...
  6. 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...
  7. 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...
  8. 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...
  9. 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,...

Latest Content

Subscribe to News about SQL Database


Web Content

SQL Database Documentation

1. SQL Database Service
     1.1. About SQL DB
     1.2. Choose a version of Azure SQL
2. Quickstarts
     2.1. Create DB - Portal
     2.2. Create DB - Azure CLI
     2.3. Create DB - Azure PowerShell
     2.4. Create Managed Instance
     2.5. Connect and query
          2.5.1. SSMS
          2.5.2. SQL Operations Studio
          2.5.3. Azure portal
          2.5.4. VS Code
          2.5.5. .NET with Visual Studio
          2.5.6. .NET core
          2.5.7. .NET with Active Directory MFA
          2.5.8. Go
          2.5.9. Java
          2.5.10. Node.js
          2.5.11. PHP
          2.5.12. Python
          2.5.13. Ruby
3. Tutorials
     3.1. 1 - Design DB using SSMS
     3.2. 2 - Design DB using .NET
     3.3. 3 - Migrate to SQL Server DB using DMA
     3.4. 4 - Secure your SQL DB
     3.5. 5 - Implement a geo-distributed database
     3.6. 6 - Create Managed Instance
     3.7. 7 - Restore a backup to a Managed Instance
     3.8. 8 - Migrate to a Managed Instance using DMS
     3.9. 9 - 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. vCore vs. DTU
          5.1.2. vCore model
          5.1.3. DTU model
          5.1.4. Resource limits
          5.1.5. Prepay for reserved capacity
     5.2. Logical servers
          5.2.1. Create and manage
          5.2.2. Connectivity architecture
          5.2.3. T-SQL differences
     5.3. Single databases
          5.3.1. Create and manage
          5.3.2. vCore-based resource limits
          5.3.3. DTU-based resource limits
          5.3.4. Scale resources
     5.4. Elastic pools
          5.4.1. Elastic pools
          5.4.2. Create and manage
          5.4.3. vCore-based resource limits
          5.4.4. DTU-based resource limits
          5.4.5. Scale resources
     5.5. Managed instances
          5.5.1. Managed instances
          5.5.2. VNet configuration
          5.5.3. Custom DNS
          5.5.4. Sync network configuration
          5.5.5. Connectivity architecture
          5.5.6. Connect applications
          5.5.7. T-SQL differences
     5.6. Business continuity
          5.6.1. Business continuity
          5.6.2. High availability
          5.6.3. Database backups
          5.6.4. Long-term backup retention
      Long-term backup retention
      Configure using Azure blob storage
      Configure using Azure vault (deprecated)
          5.6.5. Failover groups and geo-replication
      Failover groups and geo-replication
      Configure geo-replication - Portal
      Configure security for replicas
          5.6.6. Database recovery
      Database recovery
      Recover from outage
      Perform recovery drill
          5.6.7. App design
      Design for disaster recovery
      Design for elastic pools
      Design for app upgrades
     5.7. Security
          5.7.1. Security
          5.7.2. Advanced Threat Protection
      Advanced Threat Protection
      Data discovery and classification
      Vulnerability assessment
      Threat detection - SQL Database
      Threat detection - Managed Instance
          5.7.3. Firewall rules
      Create and manage
      Virtual network endpoints
      Virtual network endpoints - PowerShell
          5.7.4. Access control
      Access control
      Logins and users
          5.7.5. Azure AD authentication
      Azure AD authentication
      Configure Azure AD auth
      Conditional access
      Multi-factor auth
      Configure multi-factor auth
          5.7.6. Auditing
      Auditing - Servers, pools, and databases
      Auditing - Managed Instance
      Table auditing (deprecated)
          5.7.7. Dynamic data masking
      Dynamic data masking
      Configure masking
          5.7.8. Always encrypted
      Use the certificate store
      Use the Azure key vault
          5.7.9. TDE with Azure SQL
      TDE with Azure SQL
      TDE with Bring Your Own Key
      Configure TDE with BYOK
      Rotate TDE BYOK keys
      Remove TDE protector
     5.8. Elastic scalability
          5.8.1. Resource scalability
          5.8.2. Read Scale-Out
          5.8.3. Database sharding
      Database sharding
      Elastic client library - consolidate
      Upgrade elastic database client library
      Shard maps
      Query routing
      Manage credentials
      Shard querying
      Elastic tools
      Move sharded data
      Elastic client library - Dapper
      Elastic tools FAQ
      Create sharded app
      Query horizontally-sharded data
      Move sharded data
      Security configuration
      Add a shard
      Fix shard map problems
      Migrate sharded DB
      Create counters
      Use entity framework
     5.9. SQL features comparison
     5.10. Monitor and tune
          5.10.1. Monitor and tune
          5.10.2. Perf monitoring
          5.10.3. Perf recommendations
          5.10.4. Intelligent query processing
      Intelligent query processing
      Adaptive query processing
          5.10.5. Automatic tuning
      Automatic tuning
      Enable automatic tuning
      Enable E-mail notifications
          5.10.6. Intelligent Insights
      Intelligent Insights
      Diagnostic logging
      Use diagnostics log
      Performance troubleshooting
          5.10.7. Performance recommendations
          5.10.8. Use Query Performance Insight
          5.10.9. Apply performance recommendations
          5.10.10. Manual tuning
      Manual tuning
      Use DMVs to monitor perf
      Operate query store
          5.10.11. Monitor in-memory
          5.10.12. Extended events
      Extended events
      Extended events - event file
      Extended events - ring buffer
          5.10.13. Create alerts
          5.10.14. Troubleshoot connectivity
          5.10.15. Azure Automation
     5.11. Cross-database operations
          5.11.1. Elastic Database jobs
      Elastic Database jobs
      Create and manage (PowerShell)
      Create and manage (T-SQL)
      Migrate (from old Elastic jobs)
      Elastic jobs (deprecated)
           Elastic jobs (deprecated)
           Install elastic job (deprecated)
           Create job - Portal (deprecated)
           Create job - Azure PowerShell (deprecated)
           Create job - Sample app (deprecated)
           Uninstall elastic job (deprecated)
          5.11.2. Elastic queries
      Elastic queries
      Query vertically partitioned data
      Report across scaled-out data tier
      Query across tables with different schemas
          5.11.3. Elastic transactions
     5.12. Multi-tenant SaaS
          5.12.1. SaaS design patterns
          5.12.2. SaaS video indexer
          5.12.3. SaaS app security
     5.13. Develop databases
          5.13.1. Develop databases
          5.13.2. JSON data
          5.13.3. In-memory
          5.13.4. Temporal tables
          5.13.5. Retention policies
          5.13.6. Configure In-Memory
6. How-to guides
     6.1. Migrate to SQL Database
          6.1.1. Migrate to SQL Database
          6.1.2. Migrate to Managed Instance
          6.1.3. Migrate TDE cert to Managed Instance
          6.1.4. Manage SQL Database after migration
     6.2. Load and move data
          6.2.1. Copy a DB within Azure
          6.2.2. Import a DB from a BACPAC
          6.2.3. Export a DB to BACPAC
          6.2.4. Data sync
      SQL Data Sync
      Replicate schema changes
      Monitor with OMS
      Best practices for Data Sync
      Troubleshoot Data Sync
          6.2.5. Load data with BCP
          6.2.6. Load data with ADF
     6.3. Manage file space
     6.4. Develop apps
          6.4.1. Connectivity
          6.4.2. Use Spark Connector
          6.4.3. Authenticate app
          6.4.4. Error messages
          6.4.5. Batching for perf
          6.4.6. Connectivity guidance
          6.4.7. DNS aliases
          6.4.8. DNS alias PowerShell
          6.4.9. Ports - ADO.NET
          6.4.10. C and C ++
          6.4.11. Excel
     6.5. Multi-tenant SaaS sample application
          6.5.1. Wingtip Tickets sample
          6.5.2. General guidance
          6.5.3. Standalone application
      Deploy example app
      Provision tenants
          6.5.4. 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
          6.5.5. 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 2.0
     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. SQL Server tools
     7.12. SQL Server Management Studio (SSMS)
     7.13. SQL Server Data Tools (SSDT)
     7.14. BCP
     7.15. SQLCMD
     7.16. SqlPackage
     7.17. SQL Database Management Library package
     7.18. SQL Server drivers
          7.18.1. ADO.NET
          7.18.2. JDBC
          7.18.3. ODBC
8. Resources
     8.1. Azure Roadmap
     8.2. FAQ
     8.3. Public data sets
     8.4. Troubleshoot connectivity
     8.5. Pricing
     8.6. MSDN forum
     8.7. Stack Overflow
     8.8. Videos
     8.9. Service updates
     8.10. Architecture center
     8.11. Customer stories

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
At Build 2018: Data Platform Modernization
Securing your data with Azure SQL DB
Tales from the trenches with Azure SQL DB: Best practices from real customer deployments
Query Processing Innovations for data intensive, modern applications
Azure SQL DB Managed Instances - Built to easily modernize application data layer
Azure SQL Database the intelligent database – Your database on Autopilot
Azure Service Fabric: The road ahead for microservices 
mssql-cli, an open source and cross-platform CLI for SQL Server
Keep your applications and data secure and compliant
Put your databases on autopilot with Azure SQL Database

Page 1 of 21