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. SQL Database Learning Path
    10/3/2016, Webpage
  2. SQL Database Elastic Pools Learning Path
    10/3/2016, Webpage
  3. Azure SQL Database overview
    11/16/2016, Video, 0:08:06
  4. Get started with Azure SQL Database
    9/28/2015, Video, 0:30:43
  5. Explore Azure SQL Database - the intelligent cloud database for app developers
    9/28/2016, Video, 0:55:04
  6. Use Relational Database as a Service
    12/10/2015, Mva

Latest Content

RSS Feed

Microsoft database migration tools Blog
Azure SQL hybrid data movement Blog
SQL DB now supports 4TB max database size Blog
Announcing Azure SQL Database Premium RS, 4TB storage options, and enhanced portal experience Blog
Data Migration Assistant Azure SQL Database Assessment Video
Azure Data Sync update Blog
Public preview: Loading files from Azure Blob storage into Azure SQL Database Blog
Data Migration Assistant - Adding SQL Database Video
ODBC Driver 13.1 for Linux Released Blog
SQL tools for Linux, Mac OS, and Windows Video
SQL Database Query Editor available in Azure Portal Blog
New T-SQL string functions in Azure SQL Database Blog

Azure Documentation

1. Overview
     1.1. What is SQL Database?
          1.1.1. Service tiers
          1.1.2. DTUs and eDTUs
          1.1.3. DTU benchmark overview
          1.1.4. Resource limits
          1.1.5. Features
          1.1.6. SQL Database FAQ
     1.2. Comparisons
          1.2.1. SQL Database versus SQL on a VM
          1.2.2. T-SQL differences
          1.2.3. SQL versus NoSQL
     1.3. SQL Database tools
     1.4. SQL Database tutorials
     1.5. Security
          1.5.1. Security overview
          1.5.2. Azure Security Center for Azure SQL Database
          1.5.3. SQL Security Center
2. Get Started
     2.1. Databases and servers
          2.1.1. Learn
      Single databases
      Multiple databases
           Mapping tenants
                Elastic client library
                Shard map manager
                Data-dependent routing
                Manage credentials
                Multishard querying
           Elastic pools (resource pools)
                What is an elastic pool?
                When to use an elastic pool
                Elastic pool pricing
           Sharded databases
                Elastic tools glossary
                Moving data between shards
                Elastic tools FAQ
           Elastic query (cross-database queries)
                What is an elastic query?
           Elastic transactions (distributed transactions)
                Transactions across cloud databases
           Elastic jobs (cross-database jobs)
                What is an elastic job?
      Using Azure RemoteApp to connect to SQL Database
      Managing SQL Databases using the Azure Automation service
          2.1.2. Do
      Create a single database using the Azure portal
      Reporting across scaled-out databases
      Create a single database using PowerShell
      Create a single database using C#
      Create sharded application
      Move data between shards
      Get started with elastic jobs
      Get started with elastic queries
      Create reports using elastic query
      Query databases with different schemas
     2.2. Migrate and move data
          2.2.1. Learn
      Migrate a database
      Transactional replication
      Data sync
      Copy a SQL database
     2.3. Firewall rules, authentication, and authorization
          2.3.1. Learn
      Access control
      Manage logins
          2.3.2. Do
      SQL authentication and authorization
      Azure AD authentication and authorization
     2.4. Secure and protect data
          2.4.1. Learn
           Downlevel clients support and IP endpoint changes for auditing
      Threat detection
      Encrypt data
           Azure key vault
           Transparent data encryption
           Column encryption
      Mask data
           Dynamic data masking
                Azure portal
          2.4.2. Do
      Dynamic data masking using the Azure portal
           Always Encrypted using the Windows certificate store
     2.5. Business continuity
          2.5.1. Learn
      Rolling upgrades
      Perform disaster recovery drills
      Active Geo-Replication overview
      Database backups
      Long-term retention
      Database recovery using backups
      Recover a single table
      Recover from a data center outage
      Authentication requirements for disaster recovery
      Business continuity design scenarios
      Disaster recovery strategies with elastic pools
          2.5.2. Do
      Azure portal: Backup and restore
      PowerShell: Backup and restore
     2.6. App development
          2.6.1. Learn
      Database application development overview
      Connectivity libraries
      Multitenant SaaS applications
      Scaling multitenant SaaS applications with row-level security
      Use ports beyond 1433 for ADO.NET 4.5
      Get required values for authenticating an application
          2.6.2. Do
      Connect an application
           C and C++
      Connect with Visual Studio
      Build a client application
      Work with error messages
      Use entity framework
      Use client library with Dapper
          2.6.3. Customer implementations
      Daxko/CSI Software
     2.7. Database development
          2.7.1. Learn
      Temporal tables
           Temporal tables
           Retention policies
      JSON data
      In-memory optimization
          2.7.2. Do
      SQL Server development
      Adopt in-memory OLTP
     2.8. Monitoring and Tuning
          2.8.1. Learn
      Single databases
      SQL Database Advisor overview
      Single database guidance
      Performance insights: Azure portal
      Use batching
      Extended events
     2.9. SQL Database V11
          2.9.1. Web and business edition sunset
          2.9.2. Service tier advisor
          2.9.3. Elastic pool assessment tool
          2.9.4. Upgrade to V12
      Upgrade using the Azure portal
      Upgrade using PowerShell
3. How To
     3.1. Create and manage
          3.1.1. Manage SQL Database using the Azure portal
          3.1.2. Manage SQL Database using PowerShell
          3.1.3. Manage SQL Database using SSMS
          3.1.4. Servers
      Create servers
      View or update server settings
          3.1.5. Single databases
      Create single databases
      View or update database settings
          3.1.6. Firewall rules
      Create firewall rules using the Azure portal
      Create firewall rules using PowerShell
      Create firewall rules using REST API
      Create firewall rules using T-SQL
          3.1.7. Multiple databases
      Upgrade client library in client applications
      Sharded databases
           Security configuration
           Add a shard
           Fix shard map problems
           Migrate existing scaled-out databases to sharded databases
           Create performance counters for shard map manager
      Elastic jobs
           How do I install the elastic jobs service?
           Create and manage elastic jobs using PowerShell
           Create and manage elastic jobs using the Azure portal
           How do I uninstall elastic jobs?
      Elastic pools
           Create using the Azure portal
           Create using PowerShell
           Create using C#
           Manage using the Azure portal
           Manage using PowerShell
           Manage using C#
           Manage using T-SQL
     3.10. Troubleshoot
          3.10.1. Connection issues
          3.10.2. Transient connection error
          3.10.3. Diagnose and prevent
          3.10.4. Permissions
          3.10.5. Moving databases
     3.2. Authenticate and authorize
          3.2.1. Azure AD authentication
          3.2.2. Multi-factor authentication
     3.3. Encrypt data
          3.3.1. Transparent data encryption
          3.3.2. Column encryption
     3.4. Migrate databases
          3.4.1. Determine compatibility
      Determine compatibility using the SQL Package utility
      Determine compatibility using SSMS
          3.4.2. Fix compatibility issues
      Fix compatibility issues using SSDT
      Fix compatibility issues using SSMS
      Fix compatibility issues using SMW
          3.4.3. Migrate using the SSMS Migration Wizard
     3.5. Monitor and tune
          3.5.1. Query Performance Insight
          3.5.2. SQL Database Advisor
          3.5.3. DMVs
          3.5.4. Compatibility levels
          3.5.5. Performance tuning tips
          3.5.6. Change service tiers and performance levels
      Change service tiers using the Azure portal
      Change service tiers using PowerShell
          3.5.7. Create alerts
      Monitor In-Memory OLTP Storage
          3.5.8. Query Store
      Monitoring performance by using the Query Store
      Query Store usage scenarios
      Operating the Query Store
          3.5.9. Extended events
      Event file target code
      Ring buffer target code
     3.6. Move data
          3.6.1. Copy a SQL database
      Copy using the Azure portal
      Copy using PowerShell
      Copy using T-SQL
          3.6.2. Export database to a BACPAC file
      Export using the Azure portal
      Export using SSMS
      Export using SQL Package utility
      Export using PowerShell
          3.6.3. Import database from a BACPAC file
      Import using the Azure portal
      Import using PowerShell
      Import using SSMS
      Import using SQL Package utility
          3.6.4. Load from CSV file using BCP
     3.7. Query
          3.7.1. Query using SSMS
     3.8. Backup and Restore
          3.8.1. Long-term backup retention
      Configure long-term backup retention
      View backups in a Recovery Services vault
      Restore from long-term backup retention
      Delete from long-term backup retention
          3.8.2. Restore deleted database
      Restore deleted using the Azure portal
      Restore deleted using PowerShell
          3.8.3. Point in time restore
      Restore to a point in time
      View oldest restore point
          3.8.4. Restore from geo-redundant backup
     3.9. Active Geo-Replication
          3.9.1. Configure using the Azure portal
          3.9.2. Configure using PowerShell
          3.9.3. Configure using T-SQL
          3.9.4. Failover using the Azure portal
          3.9.5. Failover using PowerShell
          3.9.6. Failover using T-SQL
4. Reference
     4.1. PowerShell
     4.10. T-SQL
     4.11. REST
     4.2. PowerShell (Elastic DB)
     4.3. Azure CLI 2.0
     4.4. .NET
     4.5. Java
     4.6. Node.js
     4.7. Python
     4.8. Ruby
     4.9. PHP
5. Related
     5.1. SQL Database Management Library
          5.1.1. Get the SQL Database Management Library package
     5.2. SQL Server Drivers
          5.2.1. ADO.NET
          5.2.2. JDBC
          5.2.3. ODBC
6. Resources
     6.1. Pricing
     6.10. SQLCMD
     6.11. SqlPackage
     6.2. MSDN forum
     6.3. Stack Overflow
     6.4. Videos
     6.5. Service updates
     6.6. SQL Server Tools
     6.7. SQL Server Management Studio (SSMS)
     6.8. SQL Server Data Tools (SSDT)
     6.9. BCP


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