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

Title  
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
               2.1.1.1. Servers
               2.1.1.2. Single databases
               2.1.1.3. Multiple databases
                    2.1.1.3.1. Mapping tenants
                         2.1.1.3.1.1. Elastic client library
                         2.1.1.3.1.2. Shard map manager
                         2.1.1.3.1.3. Data-dependent routing
                         2.1.1.3.1.4. Manage credentials
                         2.1.1.3.1.5. Multishard querying
                    2.1.1.3.2. Elastic pools (resource pools)
                         2.1.1.3.2.1. What is an elastic pool?
                         2.1.1.3.2.2. When to use an elastic pool
                         2.1.1.3.2.3. Elastic pool pricing
                    2.1.1.3.3. Sharded databases
                         2.1.1.3.3.1. Elastic tools glossary
                         2.1.1.3.3.2. Moving data between shards
                         2.1.1.3.3.3. Elastic tools FAQ
                    2.1.1.3.4. Elastic query (cross-database queries)
                         2.1.1.3.4.1. What is an elastic query?
                    2.1.1.3.5. Elastic transactions (distributed transactions)
                         2.1.1.3.5.1. Transactions across cloud databases
                    2.1.1.3.6. Elastic jobs (cross-database jobs)
                         2.1.1.3.6.1. What is an elastic job?
               2.1.1.4. Using Azure RemoteApp to connect to SQL Database
               2.1.1.5. Managing SQL Databases using the Azure Automation service
          2.1.2. Do
               2.1.2.1. Create a single database using the Azure portal
               2.1.2.10. Reporting across scaled-out databases
               2.1.2.2. Create a single database using PowerShell
               2.1.2.3. Create a single database using C#
               2.1.2.4. Create sharded application
               2.1.2.5. Move data between shards
               2.1.2.6. Get started with elastic jobs
               2.1.2.7. Get started with elastic queries
               2.1.2.8. Create reports using elastic query
               2.1.2.9. Query databases with different schemas
     2.2. Migrate and move data
          2.2.1. Learn
               2.2.1.1. Migrate a database
               2.2.1.2. Transactional replication
               2.2.1.3. Data sync
               2.2.1.4. Copy a SQL database
     2.3. Firewall rules, authentication, and authorization
          2.3.1. Learn
               2.3.1.1. Access control
               2.3.1.2. Firewall
               2.3.1.3. Manage logins
          2.3.2. Do
               2.3.2.1. SQL authentication and authorization
               2.3.2.2. Azure AD authentication and authorization
     2.4. Secure and protect data
          2.4.1. Learn
               2.4.1.1. Auditing
                    2.4.1.1.1. Audit
                    2.4.1.1.2. Downlevel clients support and IP endpoint changes for auditing
               2.4.1.2. Threat detection
               2.4.1.3. Encrypt data
                    2.4.1.3.1. Azure key vault
                    2.4.1.3.2. Transparent data encryption
                    2.4.1.3.3. Column encryption
               2.4.1.4. Mask data
                    2.4.1.4.1. Dynamic data masking
                         2.4.1.4.1.1. Azure portal
          2.4.2. Do
               2.4.2.1. Dynamic data masking using the Azure portal
                    2.4.2.1.1. Always Encrypted using the Windows certificate store
     2.5. Business continuity
          2.5.1. Learn
               2.5.1.1. Overview
               2.5.1.10. Rolling upgrades
               2.5.1.11. Perform disaster recovery drills
               2.5.1.12. Active Geo-Replication overview
               2.5.1.2. Database backups
               2.5.1.3. Long-term retention
               2.5.1.4. Database recovery using backups
               2.5.1.5. Recover a single table
               2.5.1.6. Recover from a data center outage
               2.5.1.7. Authentication requirements for disaster recovery
               2.5.1.8. Business continuity design scenarios
               2.5.1.9. Disaster recovery strategies with elastic pools
          2.5.2. Do
               2.5.2.1. Azure portal: Backup and restore
               2.5.2.2. PowerShell: Backup and restore
     2.6. App development
          2.6.1. Learn
               2.6.1.1. Database application development overview
               2.6.1.2. Connectivity libraries
               2.6.1.3. Multitenant SaaS applications
               2.6.1.4. Scaling multitenant SaaS applications with row-level security
               2.6.1.5. Use ports beyond 1433 for ADO.NET 4.5
               2.6.1.6. Get required values for authenticating an application
          2.6.2. Do
               2.6.2.1. Connect an application
                    2.6.2.1.1. .NET
                    2.6.2.1.2. C and C++
                    2.6.2.1.3. Java
                    2.6.2.1.4. Node.js
                    2.6.2.1.5. PHP
                    2.6.2.1.6. Python
                    2.6.2.1.7. Ruby
                    2.6.2.1.8. Excel
               2.6.2.2. Connect with Visual Studio
               2.6.2.3. Build a client application
               2.6.2.4. Work with error messages
               2.6.2.5. Use entity framework
               2.6.2.6. Use client library with Dapper
          2.6.3. Customer implementations
               2.6.3.1. Daxko/CSI Software
               2.6.3.2. GEP
               2.6.3.3. SnelStart
               2.6.3.4. Umbraco
     2.7. Database development
          2.7.1. Learn
               2.7.1.1. Temporal tables
                    2.7.1.1.1. Temporal tables
                    2.7.1.1.2. Retention policies
               2.7.1.2. JSON data
               2.7.1.3. In-memory optimization
          2.7.2. Do
               2.7.2.1. SQL Server development
               2.7.2.2. Adopt in-memory OLTP
     2.8. Monitoring and Tuning
          2.8.1. Learn
               2.8.1.1. Single databases
               2.8.1.2. SQL Database Advisor overview
               2.8.1.3. Single database guidance
               2.8.1.4. Performance insights: Azure portal
               2.8.1.5. Use batching
               2.8.1.6. 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
               2.9.4.1. Upgrade using the Azure portal
               2.9.4.2. 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
               3.1.4.1. Create servers
               3.1.4.2. View or update server settings
          3.1.5. Single databases
               3.1.5.1. Create single databases
               3.1.5.2. View or update database settings
          3.1.6. Firewall rules
               3.1.6.1. Create firewall rules using the Azure portal
               3.1.6.2. Create firewall rules using PowerShell
               3.1.6.3. Create firewall rules using REST API
               3.1.6.4. Create firewall rules using T-SQL
          3.1.7. Multiple databases
               3.1.7.1. Upgrade client library in client applications
               3.1.7.2. Sharded databases
                    3.1.7.2.1. Security configuration
                    3.1.7.2.2. Add a shard
                    3.1.7.2.3. Fix shard map problems
                    3.1.7.2.4. Migrate existing scaled-out databases to sharded databases
                    3.1.7.2.5. Create performance counters for shard map manager
               3.1.7.3. Elastic jobs
                    3.1.7.3.1. How do I install the elastic jobs service?
                    3.1.7.3.2. Create and manage elastic jobs using PowerShell
                    3.1.7.3.3. Create and manage elastic jobs using the Azure portal
                    3.1.7.3.4. How do I uninstall elastic jobs?
               3.1.7.4. Elastic pools
                    3.1.7.4.1. Create using the Azure portal
                    3.1.7.4.2. Create using PowerShell
                    3.1.7.4.3. Create using C#
                    3.1.7.4.4. Manage using the Azure portal
                    3.1.7.4.5. Manage using PowerShell
                    3.1.7.4.6. Manage using C#
                    3.1.7.4.7. 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
               3.4.1.1. Determine compatibility using the SQL Package utility
               3.4.1.2. Determine compatibility using SSMS
          3.4.2. Fix compatibility issues
               3.4.2.1. Fix compatibility issues using SSDT
               3.4.2.2. Fix compatibility issues using SSMS
               3.4.2.3. 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
               3.5.6.1. Change service tiers using the Azure portal
               3.5.6.2. Change service tiers using PowerShell
          3.5.7. Create alerts
               3.5.7.1. Monitor In-Memory OLTP Storage
          3.5.8. Query Store
               3.5.8.1. Monitoring performance by using the Query Store
               3.5.8.2. Query Store usage scenarios
               3.5.8.3. Operating the Query Store
          3.5.9. Extended events
               3.5.9.1. Event file target code
               3.5.9.2. Ring buffer target code
     3.6. Move data
          3.6.1. Copy a SQL database
               3.6.1.1. Copy using the Azure portal
               3.6.1.2. Copy using PowerShell
               3.6.1.3. Copy using T-SQL
          3.6.2. Export database to a BACPAC file
               3.6.2.1. Export using the Azure portal
               3.6.2.2. Export using SSMS
               3.6.2.3. Export using SQL Package utility
               3.6.2.4. Export using PowerShell
          3.6.3. Import database from a BACPAC file
               3.6.3.1. Import using the Azure portal
               3.6.3.2. Import using PowerShell
               3.6.3.3. Import using SSMS
               3.6.3.4. 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
               3.8.1.1. Configure long-term backup retention
               3.8.1.2. View backups in a Recovery Services vault
               3.8.1.3. Restore from long-term backup retention
               3.8.1.4. Delete from long-term backup retention
          3.8.2. Restore deleted database
               3.8.2.1. Restore deleted using the Azure portal
               3.8.2.2. Restore deleted using PowerShell
          3.8.3. Point in time restore
               3.8.3.1. Restore to a point in time
               3.8.3.2. 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

Tools

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.