Documentation

Homepage

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.

Pricing SLAs Limits Learning Twitter

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...

SQL Database News

1/16/2020, Data Exposed [0:02:43]
Want to get started with Azure Data Studio (https://docs.microsoft.com/en-us/sql/azure-data-studio/download) but don't know where to begin?In this video, Anna Hoffman shows you how to get...
1/16/2020, YouTube: Microsoft Ignite [0:19:12]
As businesses and applications reach global scale, you know that SQL Server and Azure SQL Database can support international applications using Unicode. And you’ve been working with SQL Server...
1/14/2020, YouTube: Microsoft Ignite [0:18:24]
Join an upbeat theater session which details how Azure Data Share makes it easy for you to share data with third-party organizations in a safe and secure manner from multiple data sources,...
1/14/2020, YouTube: Microsoft Ignite [0:21:35]
During this session, learn the best practices on how to implement a disaster recovery architecture for Azure SQL Database managed instance using failover groups. Azure SQL Database managed...
1/14/2020, YouTube: Microsoft Ignite [0:47:40]
This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift and shift, modernize, and extend ETL workflows. We first show you...
1/14/2020, YouTube: Microsoft Ignite [0:47:35]
Private Link brings Azure services into your private virtual network (VNet). Not only can you map Azure PaaS services such as Azure Storage, Azure SQL Database, and Azure Cosmos DB in to your...
1/14/2020, YouTube: Microsoft Ignite [1:05:28]
SQL Server is the world’s leading operational database. Today 98 of the Fortune 100 companies use it to power their mission critical applications across all verticals. In this one session we show...
1/14/2020, YouTube: Microsoft Ignite [0:48:47]
When you move to Azure SQL Database, you select a pre-defined set of allocated resources across several dimensions such as CPU, memory, storage, and more. For a typical business application you...
1/14/2020, YouTube: Microsoft Ignite [0:39:59]
Azure SQL Database serverless is a new compute tier that optimizes price-performance and simplifies performance management for single databases with intermittent, unpredictable usage. Serverless...
1/14/2020, YouTube: Microsoft Ignite [0:46:40]
Customers are increasingly asking for better controls to secure their data as it moves across platforms and organizational boundaries. For example, financial institutions are turning towards...
1/14/2020, YouTube: Microsoft Ignite [0:38:48]
In this session we show how you can use the SQL Machine Learning platform using Azure Data Studio. We walk through with the experience to collect and query data from an edge device, and then show...
1/14/2020, YouTube: Microsoft Ignite [0:46:06]
Azure SQL Database Managed Instance offers the best combination of a fully managed cloud service and SQL Server compatibility. This makes it the recommended destination for migration of most SQL...
1/14/2020, YouTube: Microsoft Ignite [0:44:00]
Azure SQL Database Edge offers the same SQL database engine which is optimized to run at the edge with a small resource footprint and with built-in capabilities like streaming support. This...
1/9/2020, Data Exposed [0:24:17]
Learn more about the deployment options for Azure SQL Database.More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-technical-overview[00:00] - Introduction[00:41] -...
1/9/2020, YouTube: Microsoft Developer [0:24:18]
Learn more about the deployment options for Azure SQL Database. More information:...
1/9/2020, Azure Podcast
In this round-table discussion, Cynthia, Kendall, Cale, Evan and Sujit weigh-in on what Azure features they are most excited about for 2020. Media file:...
1/9/2020, Azure Podcast
In this round-table discussion, Cynthia, Kendall, Cale, Evan and Sujit weigh-in on what Azure features they are most excited about for 2020. Media file:...
1/5/2020, Azure Tips and Tricks
No Description available.
1/2/2020, Data Exposed [0:04:12]
You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance?In this video, Anna Thomas and Colin Murphy cover a brief overview of...
1/2/2020, YouTube: Microsoft Developer [0:04:13]
You're probably familiar with Collations in SQL Server, but how do Collations change in Azure SQL Database Managed Instance? In this video, Anna Thomas and Colin Murphy cover a brief overview...