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

Title  
Blog
Blog
Blog
Blog
Blog
Blog
Blog
Video
Video
Blog
Blog
Blog
more...


Azure Documentation

1. SQL DB Documentation
2. Overview
     2.1. About SQL DB
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. Azure portal
          3.4.3. VS Code
          3.4.4. .NET with Visual Studio
          3.4.5. .NET core
          3.4.6. Go
          3.4.7. Java
          3.4.8. Node.js
          3.4.9. PHP
          3.4.10. Python
          3.4.11. Ruby
4. Tutorials
     4.1. 1 - Design DB using SSMS
     4.2. 1 - Design DB using .NET
     4.3. 2 - Migrate SQL Server DB
     4.4. 3 - Secure your SQL DB
     4.5. 4 - Implement a geo-distributed database
5. Samples
     5.1. Code samples
     5.2. Azure CLI
     5.3. Azure PowerShell
6. Concepts
     6.1. Service features
          6.1.1. Service tiers
          6.1.2. Resource limits
          6.1.3. Single databases
          6.1.4. Elastic pools
          6.1.5. Connectivity architecture
          6.1.6. Firewall rules
          6.1.7. Firewall virtual network rules
          6.1.8. DTUs and eDTUs
          6.1.9. DTU benchmark
          6.1.10. PaaS or IaaS
          6.1.11. Auditing
          6.1.12. Threat detection
          6.1.13. Database backups
          6.1.14. Backup retention
          6.1.15. Failover groups
          6.1.16. Elastic client library
          6.1.17. Elastic queries
          6.1.18. Elastic transactions
          6.1.19. Elastic jobs
          6.1.20. SQL Vulnerability Assessment
          6.1.21. SQL Server common features
     6.2. Security
          6.2.1. Access control
          6.2.2. Azure AD
          6.2.3. Logins and users
          6.2.4. Multi-factor auth
          6.2.5. Table auditing & TDS
          6.2.6. Data masking
     6.3. High availability
     6.4. Business continuity
          6.4.1. Database recovery
          6.4.2. Configure security
          6.4.3. App design & recovery
          6.4.4. App design & pools
          6.4.5. App design & app upgrades
          6.4.6. Recover from outage
          6.4.7. Perform recovery drill
     6.5. Migrate to SQL Database
          6.5.1. T-SQL changes
          6.5.2. Manage database after migration
     6.6. Load & move data
          6.6.1. Copy a DB
          6.6.2. Import a DB
          6.6.3. Export a DB
          6.6.4. Sync data
     6.7. Monitor & tune
          6.7.1. Perf monitoring
          6.7.2. Perf recommendations
          6.7.3. Automatic tuning
          6.7.4. Intelligent Insights
          6.7.5. Intelligence Insights diagnostics log
          6.7.6. Manual tuning
          6.7.7. Operate query store
          6.7.8. Extended events
          6.7.9. Monitor in-memory
     6.8. Scale out
          6.8.1. Shard maps
          6.8.2. Query routing
          6.8.3. Manage credentials
          6.8.4. Shard querying
          6.8.5. Elastic tools
          6.8.6. Move sharded data
          6.8.7. Elastic client library - Dapper
          6.8.8. Elastic tools FAQ
     6.9. Multi-tenant SaaS
          6.9.1. SaaS design patterns
          6.9.2. SaaS video indexer
          6.9.3. SaaS app security
     6.10. Develop databases
          6.10.1. JSON data
          6.10.2. In-memory
          6.10.3. Temporal tables
          6.10.4. Retention policies
          6.10.5. Configure In-Memory
     6.11. Develop apps
          6.11.1. Connectivity
          6.11.2. Authenticate app
          6.11.3. Error messages
          6.11.4. Batching for perf
          6.11.5. Connectivity guidance
          6.11.6. 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. Security
          7.2.1. Configure Azure AD auth
          7.2.2. Conditional access
          7.2.3. Always encrypted cert store
          7.2.4. Always encrypted key vault
          7.2.5. Configure masking
          7.2.6. Configure multi-factor auth
          7.2.7. Virtual network rules by PowerShell
     7.3. Business continuity
          7.3.1. Configure vault - backups
          7.3.2. Geo-replicate - Portal
     7.4. Load & move data
          7.4.1. Load data with BCP
          7.4.2. Load data with ADF
          7.4.3. Sync data
     7.5. Monitor & tune
          7.5.1. Monitor & improve performance
          7.5.2. Use Query Performance Insight
          7.5.3. Apply performance recommendations
          7.5.4. Enable automatic tuning
          7.5.5. Intelligent Insights performance troubleshooting
          7.5.6. Use DMVs to monitor perf
          7.5.7. Create alerts
          7.5.8. Extended events - event file
          7.5.9. Extended events - ring buffer
          7.5.10. Diagnostic logging
          7.5.11. Troubleshoot connectivity
          7.5.12. Azure Automation
          7.5.13. Monitor SQL Data Sync with OMS Log Analytics
          7.5.14. Best practices for SQL Data Sync
          7.5.15. Troubleshoot SQL Data Sync
     7.6. Scale out
          7.6.1. Create sharded app
          7.6.2. Query horizontally-sharded data
          7.6.3. Move sharded data
          7.6.4. Security configuration
          7.6.5. Add a shard
          7.6.6. Fix shard map problems
          7.6.7. Migrate sharded DB
          7.6.8. Create counters
          7.6.9. Use entity framework
     7.7. Multi-tenant SaaS
          7.7.1. Wingtip Tickets sample
          7.7.2. General guidance
          7.7.3. Standalone application
               7.7.3.1. Deploy example app
          7.7.4. Database per tenant
               7.7.4.1. Tutorial intro
               7.7.4.2. Deploy example app
               7.7.4.3. Provision tenants
               7.7.4.4. Monitor database performance
               7.7.4.5. Monitor with log analytics
               7.7.4.6. Restore one tenant
               7.7.4.7. Manage tenant schema
               7.7.4.8. Run ad-hoc queries
               7.7.4.9. ETL for analysis
          7.7.5. Multi-tenant database
               7.7.5.1. Deploy example app
               7.7.5.2. Provision tenants
               7.7.5.3. Monitor database performance
               7.7.5.4. Run ad-hoc queries
               7.7.5.5. Manage tenant schema
               7.7.5.6. ETL for analysis
     7.8. Develop apps
          7.8.1. C and C ++
          7.8.2. Excel
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

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

Tools

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.

Videos

Date Title Length
12/7/2017 Put your databases on autopilot with Azure SQL Database 0:15:26
12/6/2017 Keynote Demo: Azure SQL Database and Migrating existing SQL Server 0:11:01
12/4/2017 Cloud Tech 10 - 4th December 2017 - Location Based Services, Azure Migrate and more! 0:04:26
11/17/2017 Get graph support in SQL Server 2017 and Azure SQL Database | T146 0:16:27
11/17/2017 Migrate SQL Server data by using Azure SQL Database Managed Instance | T142 0:04:57
11/17/2017 Put your databases on autopilot with Azure SQL Database 0:03:29
11/15/2017 Migrate SQL Server data by using Azure SQL Database Managed Instance 0:04:56
11/15/2017 Protect customer data with advanced security features in SQL Database 0:13:32
11/15/2017 Accelerate SaaS app development in SQL Database with SaaS patterns 0:09:09
11/15/2017 Get graph support in SQL Server 2017 and Azure SQL Database 0:16:26

Page 1 of 19