SQL Database

Official Documentation

Homepage
Pricing
Service Levels
Limitations

Homepage Pricing SLAs Limits

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

SQL Database Learning Path

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.
SQL Database Elastic Pools Learning Path

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...
Get started with Azure SQL Database

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,...
Explore Azure SQL Database - the intelligent cloud database for app developers

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...
Use Relational Database as a Service

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...
Azure SQL Database: The world's first intelligent cloud database service

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...
Put your databases on autopilot with Azure SQL Database

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...
Keynote Demo: Azure SQL Database and Migrating existing SQL Server

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...
Data on Azure: The big picture

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

Date	Title
5/21/2018	5/21/2018 In preview - Azure Blockchain Workbench Azure Roadmap Azure Blockchain Workbench, a new developer tool, makes it easier to build blockchain applications on Azure. With a few clicks, deploy an Azure-supported blockchain network that’s pre-integrated...
5/21/2018	5/21/2018 Tips & Tricks : What you need to do to creat SQL Login to authenticate to Azure SQL DBs members in Auto-Failover Group Sometimes we found it is tricky to setup SQL Login account other than default built-in SQL Admin and using them to allow SQL application access to login to Azure Server and Databases members in...
5/17/2018	5/17/2018 Now available - Vulnerability assessment for Azure SQL Database now generally available Azure Roadmap Now generally available, Vulnerability Assessment for Azure SQL Database provides you with a one-stop-shop to discover, track, and remediate potential database vulnerabilities.
5/17/2018	5/17/2018 Announcing SQL Advanced Threat Protection (ATP) and SQL Vulnerability Assessment general availability Microsoft Azure Blog We are delighted to announce the general availability of SQL Vulnerability Assessment for Azure SQL Database! SQL Vulnerability Assessment (VA) provides you a one-stop-shop to discover, track and…
5/12/2018	5/12/2018 Turbo boost data loads from Spark using SQL Spark connector Reviewed by: Dimitri Furman, Xiaochen Wu Apache Spark is a distributed processing framework commonly found in big data environments. Spark is often used to transform, manipulate, and aggregate...
5/12/2018	5/12/2018 At Build 2018: Data Platform Modernization Azure Friday [0:04:48] Azure Friday visited various Microsoft booths in the Expo Hall at Build 2018 to learn what's new. In this episode, Lara Rubbelke gets an update on SQL Database Migration Service from Kevin...
5/10/2018	5/10/2018 Now available - New standard tier performance levels in Azure SQL Database Azure Roadmap New standard performance levels S4, S6, S7, S9, and S12 for single databases are now generally available.
5/10/2018	5/10/2018 Lesson Learned #49: Does Azure SQL Database support Azure Active Directory connections using Service Principals? The answer is Yes!. Just finishing a service request following the instructions placed on this URL but with a limitation: Service Principal of the Managed Service Identity is not currently...
5/10/2018	5/10/2018 Lesson Learned #48: Does Azure SQL Database Managed Instance support Resource Governor? The answer is Yes! and it is great to know. Currently, using Azure SQL Database Managed Instance we could configure a subset of the physical resources of an instance of the Database Engine. SQL...
5/9/2018	5/9/2018 Export Azure SQL DB Error: “Missing the required ‘administratorLogin’ parameters for ImportExport operation.” Few days ago, I have been working on an issue that customer trying to Export Azure SQL Database using Azure Portal, facing this Error Message: ErrorCode: 400 ErrorMessage: Missing the required...
5/9/2018	5/9/2018 Lesson Learned #47: Do you have connectivity issues to Azure SQL DB from your PC? Often, we are working on with service requests that our customers are facing connectivity problem to Azure SQL Database from their office or from home. Time ago, my colleague Raghda and I,...
5/8/2018	5/8/2018 Database scoped default online options is in preview for Azure SQL DB SQL Server Blog This post is authored byJosh Gnanayutham, Program Manager, Azure SQL Database. We are happy to announce that database scoped default options for online and resumable are now available for public...

more...

Web Content

Azure Documentation

1. SQL DB Documentation
2. Overview
     2.1. About SQL DB
     2.2. PaaS or IaaS
3. Quickstarts
     3.1. Create DB - Portal
     3.2. Create DB - Azure CLI
     3.3. Create DB - Azure PowerShell
     3.4. Connect & query
          3.4.1. SSMS
          3.4.2. SQL Operations Studio
          3.4.3. Azure portal
          3.4.4. VS Code
          3.4.5. .NET with Visual Studio
          3.4.6. .NET core
          3.4.7. .NET with Active Directory MFA
          3.4.8. Go
          3.4.9. Java
          3.4.10. Node.js
          3.4.11. PHP
          3.4.12. Python
          3.4.13. Ruby
4. Tutorials
     4.1. 1 - Design DB using SSMS
     4.2. 1 - Design DB using .NET
     4.3. 2 - Migrate to SQL Server DB using DMS
     4.4. 3 - Secure your SQL DB
     4.5. 4 - Implement a geo-distributed database
     4.6. 5 - Create Managed Instance
     4.7. 6 - Restore a backup to a Managed Instance
     4.8. 7 - Migrate to a Managed Instance using DMS
5. Samples
     5.1. Code samples
     5.2. Azure CLI
     5.3. Azure PowerShell
6. Concepts
     6.1. Servers and databases
     6.2. Managed instance
     6.3. DTU-based Service tiers
     6.4. vCore-based Service tiers
     6.5. Read Scale-Out
     6.6. DTU-based resource limits
     6.7. vCore-based resource limits
     6.8. Single databases
     6.9. Elastic pools
     6.10. Connectivity architecture
     6.11. DTUs and eDTUs
     6.12. DTU benchmark
     6.13. SQL Server common features
     6.14. High availability
     6.15. Security
          6.15.1. Overview
          6.15.2. Advanced Threat Protection
          6.15.3. Data discovery & classification
          6.15.4. Vulnerability assessment
          6.15.5. Threat detection - SQL Database
          6.15.6. Threat detection - Managed Instance
          6.15.7. Firewall rules
          6.15.8. Firewall virtual network rules
          6.15.9. Access control
          6.15.10. Azure AD
          6.15.11. Logins and users
          6.15.12. Multi-factor auth
          6.15.13. Auditing - SQL Database
          6.15.14. Auditing - Managed Instance
          6.15.15. Table auditing & TDS
          6.15.16. Dynamic data masking
     6.16. Business continuity
          6.16.1. Overview
          6.16.2. Database backups
          6.16.3. Long-term backup retention
          6.16.4. Failover groups
          6.16.5. Database recovery
          6.16.6. Configure security
          6.16.7. App design & recovery
          6.16.8. App design & pools
          6.16.9. App design & app upgrades
          6.16.10. Recover from outage
          6.16.11. Perform recovery drill
     6.17. Migrate to SQL Database
          6.17.1. Migrate to SQL Database
          6.17.2. Migrate to Managed Instance
          6.17.3. SQL Database T-SQL details
          6.17.4. Managed Instance T-SQL details
          6.17.5. Manage SQL Database after migration
     6.18. Load & move data
          6.18.1. Copy a DB
          6.18.2. Import a DB
          6.18.3. Export a DB
          6.18.4. Sync data
     6.19. Monitor & tune
          6.19.1. Overview
          6.19.2. Perf monitoring
          6.19.3. Perf recommendations
          6.19.4. Automatic tuning
          6.19.5. Intelligent Insights
          6.19.6. Intelligence Insights diagnostics log
          6.19.7. Manual tuning
          6.19.8. Operate query store
          6.19.9. Extended events
          6.19.10. Monitor in-memory
     6.20. Scale out
          6.20.1. Overview
          6.20.2. Elastic client library
          6.20.3. Elastic queries
          6.20.4. Elastic transactions
          6.20.5. Elastic jobs
          6.20.6. Shard maps
          6.20.7. Query routing
          6.20.8. Manage credentials
          6.20.9. Shard querying
          6.20.10. Elastic tools
          6.20.11. Move sharded data
          6.20.12. Elastic client library - Dapper
          6.20.13. Elastic tools FAQ
     6.21. Multi-tenant SaaS
          6.21.1. SaaS design patterns
          6.21.2. SaaS video indexer
          6.21.3. SaaS app security
     6.22. Develop databases
          6.22.1. Overview
          6.22.2. JSON data
          6.22.3. In-memory
          6.22.4. Temporal tables
          6.22.5. Retention policies
          6.22.6. Configure In-Memory
     6.23. Develop apps
          6.23.1. Connectivity
          6.23.2. Authenticate app
          6.23.3. Error messages
          6.23.4. Batching for perf
          6.23.5. Connectivity guidance
          6.23.6. DNS alias overview
          6.23.7. DNS alias PowerShell
          6.23.8. Ports - ADO.NET
7. How-to guides
     7.1. Service features
          7.1.1. Upgrade elastic database client library
          7.1.2. Install elastic job
          7.1.3. Create job - Portal
          7.1.4. Create job - Azure PowerShell
          7.1.5. Create job - Sample app
          7.1.6. Uninstall elastic job
          7.1.7. Query vertically partitioned data
          7.1.8. Report across scaled-out data tier
          7.1.9. Query across tables with different schemas
     7.2. Managed Instance
          7.2.1. VNet configuration
          7.2.2. Custom DNS
          7.2.3. Connect applications
          7.2.4. Sync network configuration
     7.3. Security
          7.3.1. Configure Azure AD auth
          7.3.2. Conditional access
          7.3.3. Always encrypted cert store
          7.3.4. Always encrypted key vault
          7.3.5. Configure masking
          7.3.6. Configure multi-factor auth
          7.3.7. Virtual network rules by PowerShell
     7.4. Business continuity
          7.4.1. Geo-replicate - Portal
          7.4.2. Configure long-term backup retention - SQL storage
          7.4.3. Configure long-term backup retention - Azure vault
     7.5. Load & move data
          7.5.1. Load data with BCP
          7.5.2. Load data with ADF
          7.5.3. Sync data
     7.6. Monitor & tune
          7.6.1. Monitor & improve performance
          7.6.2. Use Query Performance Insight
          7.6.3. Apply performance recommendations
          7.6.4. Enable automatic tuning
          7.6.5. Automatic tuning e-mail notifications
          7.6.6. Intelligent Insights performance troubleshooting
          7.6.7. Use DMVs to monitor perf
          7.6.8. Create alerts
          7.6.9. Extended events - event file
          7.6.10. Extended events - ring buffer
          7.6.11. Diagnostic logging
          7.6.12. Troubleshoot connectivity
          7.6.13. Azure Automation
          7.6.14. Monitor SQL Data Sync with OMS Log Analytics
          7.6.15. Best practices for SQL Data Sync
          7.6.16. Troubleshoot SQL Data Sync
     7.7. Scale out
          7.7.1. Create sharded app
          7.7.2. Query horizontally-sharded data
          7.7.3. Move sharded data
          7.7.4. Security configuration
          7.7.5. Add a shard
          7.7.6. Fix shard map problems
          7.7.7. Migrate sharded DB
          7.7.8. Create counters
          7.7.9. Use entity framework
     7.8. Multi-tenant SaaS
          7.8.1. Wingtip Tickets sample
          7.8.2. General guidance
          7.8.3. Standalone application
               7.8.3.1. Deploy example app
               7.8.3.2. Provision tenants
          7.8.4. Database per tenant
               7.8.4.1. Tutorial intro
               7.8.4.2. Deploy example app
               7.8.4.3. Provision tenants
               7.8.4.4. Monitor database performance
               7.8.4.5. Monitor with log analytics
               7.8.4.6. Restore one tenant
               7.8.4.7. Manage tenant schema
               7.8.4.8. Cross-tenant reporting
               7.8.4.9. Tenant analytics
                    7.8.4.9.1. With SQL DB
                    7.8.4.9.2. With SQL DW
               7.8.4.10. Disaster recovery using geo-restore
               7.8.4.11. Disaster recovery using database geo-replication
          7.8.5. Multi-tenant database
               7.8.5.1. Deploy example app
               7.8.5.2. Provision tenants
               7.8.5.3. Monitor database performance
               7.8.5.4. Run ad-hoc queries
               7.8.5.5. Manage tenant schema
               7.8.5.6. ETL for analytics
     7.9. Develop apps
          7.9.1. C and C ++
          7.9.2. Excel
          7.9.3. Use Spark Connector
8. Reference
     8.1. Azure PowerShell
     8.2. PowerShell (Elastic DB)
     8.3. Azure CLI 2.0
     8.4. .NET
     8.5. Java
     8.6. Node.js
     8.7. Python
     8.8. Ruby
     8.9. PHP
     8.10. T-SQL
     8.11. REST
     8.12. SQL Server tools
     8.13. SQL Server Management Studio (SSMS)
     8.14. SQL Server Data Tools (SSDT)
     8.15. BCP
     8.16. SQLCMD
     8.17. SqlPackage
     8.18. SQL Database Management Library package
     8.19. SQL Server drivers
          8.19.1. ADO.NET
          8.19.2. JDBC
          8.19.3. ODBC
9. Resources
     9.1. Azure Roadmap
     9.2. FAQ
     9.3. Public data sets
     9.4. Troubleshoot connectivity
     9.5. Pricing
     9.6. MSDN forum
     9.7. Stack Overflow
     9.8. Videos
     9.9. Service updates
     9.10. Architecture center
     9.11. Customer stories

Web Pages

Content	Type
Optimizing performance with Azure SQL Database	Event
Azure SQL Database DTU Calculator	Website
SQL Database Elastic Pools Learning Path	Webpage
SQL Database Learning Path	Webpage
SQL Server (IaaS) on an Azure Virtual Machine Learning Path	Webpage
Microsoft Azure Essentials Migrating SQL Server Databases to Azure	Ebook
High Availability Checklist	Webpage
Security and Azure SQL Database	Whitepaper
Introducing Microsoft SQL Server 2016	Ebook
SQL Azure Migration Wizard	Webpage
Understanding Azure SQL Database and SQL Server in Azure VMs	Webpage
Azure SQL Database General Guidelines and Limitations	Webpage
Protecting Data in Microsoft Azure	Whitepaper

Online Training Content

Date	Title
5/24/2017	Developing Microsoft Azure Solutions In this computer science course, you will learn how to deploy an ASP.NET MVC application, which is a web application framework developed by Microsoft, which implements the model–view–controller (MVC) pattern, to the Microsoft Azure platform. We will expand on the application by learning about Microsoft Azure’s capabilities and then adding functionality...
5/24/2017	Orchestrating Big Data with Azure Data Factory This data analysis course teaches you how to use Azure Data Factory to coordinate data movement and transformation using technologies such as Hadoop, SQL, and Azure Data Lake Analytics. You will learn how to create data pipelines that will allow you to group activities to perform a certain task.
5/24/2017	Provisioning SQL Server and Azure SQL Databases The role of a SQL Server database administrator has expanded from the server rack to the datacenter to the cloud, and from Windows Server OS to Platform as a Service and Linux. In this course, you will learn how to install or provision SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.
3/24/2017	Microsoft Azure for IT Pros Content Series: Data Services Need practical help with Microsoft Azure data solutions? Get the basics from MVP Corey Hynes, in the “data services” installment of our series of Azure for IT Pros courses. See helpful demos, get a look at built-in tools, and explore security features. Begin with an overview of Azure SQL, learn about data platform options, and see how to manage them...
3/5/2017	Cloud Application Development Wondering how cloud app development can help solve business problems? MVPs and popular instructors Colin Dembovsky and Steven Borg of Northwest Cadence offer helpful guidance on the subject, in this up-close look at Azure app development, platform as a service (PaaS), and DevOps on Visual Studio Team Services. In this demo-rich course, see how Azure...
2/25/2017	SQL Database Fundamentals Would you like to learn the basics of relational databases? Join us for this look at SQL Database fundamentals, along with those of database management systems and database components. Get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus,...
2/3/2017	SQL Database Fundamentals Would you like to learn the basics of relational databases? Join us for this look at SQL Database fundamentals, along with those of database management systems and database components. Get an in-depth introduction to the terminology, concepts, and skills you need to understand database objects, administration, security, and management tools. Plus,...
12/2/2016	Web and Data Application Development with Visual Studio 2017 and Azure If you’d like to learn application development, end to end, be sure to take this course. Get a look at a number of cloud-based technologies, see practical demonstrations, and dig into what’s new in Visual Studio 2017, in this course, part of Connect(); //2016 Day 3. In six in-depth modules, take a look at the interoperability of many tools, platforms,...
9/30/2016	Migrating SQL Server Databases to Azure If you're an experienced SQL Server database administrator or developer and if you have a need to "lift and shift" databases to the cloud, this course is for you. Carl Rabeler, author of the Microsoft Press book Migrating SQL Server Databases to Azure, and Microsoft Senior Content Developer Chris Randall, who was the book’s technical reviewer, walk you...
7/4/2016	Elastic Database Capabilities with Azure SQL DB Want to build a database application in the cloud that scales seamlessly as you add more customers, users, or tenants? In this practical course, explore the different scenarios and patterns that work best for implementing the data tiers of these applications.

Page 1 of 4

Tools

Tool	Description	Author
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.	Microsoft
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.	Microsoft
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.	Paraleap Technologies
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.	Microsoft

Videos

Date	Title	Length
5/12/2018	At Build 2018: Data Platform Modernization Azure Friday Azure Friday visited various Microsoft booths in the Expo Hall at Build 2018 to learn what's new. In this episode, Lara Rubbelke gets an update on SQL Database Migration Service from Kevin Farlee.For more information, see:SQL Database...	0:04:48
5/6/2018	Securing your data with Azure SQL DB Come learn about new security features like Vulnerability Assessment, Information Protection, Thread Detection and Always Encrypt to see how Azure SQL Database is securing your data in the most secure database on the planet.	1:33:22
5/6/2018	Tales from the trenches with Azure SQL DB: Best practices from real customer deployments Come join us to hear directly from our senior engineers about why our customers choose Azure SQL DB when modernizing existing applications or building new business critical applications. We will discuss security, performance and all...	1:33:22
5/6/2018	Query Processing Innovations for data intensive, modern applications Learn how your application can benefit from new capabilities in the Azure SQL Database and SQL Server platform, including graph data processing to model complex relationships between objects, and advanced self-tuning query processing...	1:33:22
5/6/2018	Azure SQL DB Managed Instances - Built to easily modernize application data layer Managed Instances is the latest fully managed deployment model for Azure SQL Database that enables friction-free migration for SQL Server applications running on-premises. Come and learn why Managed Instance is the best PaaS...	1:33:22
5/6/2018	Azure SQL Database the intelligent database – Your database on Autopilot Come learn how Azure SQL DB, the most intelligent cloud database, uses machine learning and best practices to ensure your database is always performing at its best. Come learn about features like Adaptive Query Processing, Autotuning...	1:33:22
5/6/2018	Azure Service Fabric: The road ahead for microservices Service Fabric is the foundational technology powering core Azure infrastructure and large-scale Microsoft services such as Azure Cosmos DB, Azure SQL Database, Dynamics 365, and Cortana. Come to this session for a developer’s tour and...	1:33:22
5/3/2018	mssql-cli, an open source and cross-platform CLI for SQL Server Data Exposed This week's episode of Data Exposed welcomes Abhi Abhishek to the show! Abhi is a Software Engineer in the SQL Server engineering group focusing on SQL Tools. Today he is in the studio to talk about mssql-cli, a new open source and...	0:16:03
1/29/2018	Keep your applications and data secure and compliant YT: Microsoft Azure To learn more, visit: https://aka.ms/data-ebook6 Azure SQL Database, along with other Azure data services, has several measures in place to help keep your data secure and compliant. Especially with GDPR coming, you’ll be equipped...	0:01:01
12/7/2017	Put your databases on autopilot with Azure SQL Database 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 accelerate growth and innovation. In this session, you’ll...	0:15:26

Page 1 of 21