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. Get started with Azure SQL Database
    9/28/2015, Video, 0:30:43
  4. Explore Azure SQL Database - the intelligent cloud database for app developers
    9/28/2016, Video, 0:55:04
  5. Use Relational Database as a Service
    12/10/2015, Mva
  6. Azure207x - Databases in Azure
    5/31/2017, Mva

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 - PowerShell
     3.4. Connect & query
          3.4.1. SSMS
          3.4.2. VS Code
          3.4.3. .NET
          3.4.4. PHP
          3.4.5. Node.js
          3.4.6. Java
          3.4.7. Python
          3.4.8. Ruby
4. Tutorials
     4.1. 1 - Create/design new SQL DB using SSMS
     4.2. 1 - Create/design new SQL DB using .NET
     4.3. 2 - Migrate SQL Server DB
     4.4. 3 - Secure your SQL DB
     4.5. 4 - Improve SQL DB performance
     4.6. 5 - Implement multi-tenant app
     4.7. 6 - Implement a geo-distributed database
5. Samples
     5.1. Azure CLI
     5.2. PowerShell
6. Concepts
     6.1. Databases & servers
          6.1.1. Databases
          6.1.2. Servers
          6.1.3. Service tiers
          6.1.4. Elastic pools
          6.1.5. Connectivity architecture
          6.1.6. DTUs and eDTUs
          6.1.7. DTU benchmark
          6.1.8. Limits
          6.1.9. PaaS or IaaS
          6.1.10. Features
          6.1.11. Tools
     6.2. Security
          6.2.1. Overview
          6.2.2. Access control
          6.2.3. Firewall rules
          6.2.4. Azure AD
          6.2.5. Logins and users
          6.2.6. Multi-factor auth
          6.2.7. Auditing
          6.2.8. Table auditing & TDS
          6.2.9. Threat detection
          6.2.10. TDE with SQL DB
          6.2.11. Always encrypted
          6.2.12. Data masking
     6.3. Business continuity
          6.3.1. Overview
          6.3.2. Database backups
          6.3.3. Backup retention
          6.3.4. Database recovery
          6.3.5. Failover groups
          6.3.6. Configure security
          6.3.7. App design & recovery
          6.3.8. App design & pools
          6.3.9. App design & app upgrades
          6.3.10. Recover from outage
          6.3.11. Perform recovery drill
     6.4. Load & move data
          6.4.1. Migrate SQL Server DB
          6.4.2. T-SQL changes
          6.4.3. Copy a DB
          6.4.4. Import a DB
          6.4.5. Export a DB
     6.5. Monitor & tune
          6.5.1. Overview
          6.5.2. Perf monitoring
          6.5.3. Perf recommendations
          6.5.4. Automatic tuning
          6.5.5. Manual tuning
          6.5.6. Operate query store
          6.5.7. Extended events
          6.5.8. Compatibility levels
          6.5.9. Monitor in-memory
     6.6. Scale out apps
          6.6.1. SaaS design patterns
          6.6.2. SaaS app security
          6.6.3. Sharded databases
          6.6.4. Elastic client library
          6.6.5. Shard maps
          6.6.6. Query routing
          6.6.7. Manage credentials
          6.6.8. Shard querying
          6.6.9. Elastic tools
          6.6.10. Move sharded data
          6.6.11. Elastic client library - Dapper
          6.6.12. Elastic tools FAQ
          6.6.13. Elastic queries
          6.6.14. Horizontal data
          6.6.15. Vertical data
          6.6.16. Transactions
          6.6.17. Elastic jobs
     6.7. Develop databases
          6.7.1. JSON data
          6.7.2. In-memory
          6.7.3. Temporal tables
          6.7.4. Retention policies
          6.7.5. Configure In-Memory
     6.8. Develop apps
          6.8.1. Overview
          6.8.2. Connectivity
          6.8.3. Authenticate App
          6.8.4. Error messages
          6.8.5. Batching for perf
          6.8.6. Connectivity guidance
          6.8.7. Ports - ADO.NET
7. How-to guides
     7.1. Databases & servers
          7.1.1. Elastic pools - Portal
          7.1.2. Elastic pools - PowerShell
          7.1.3. Elastic pools - T-SQL
          7.1.4. Elastic pools - C#
     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.3. Business continuity
          7.3.1. Configure vault - backups
          7.3.2. Geo-replicate - Portal
          7.3.3. Geo-replicate- T-SQL - Configure
          7.3.4. Geo-replicate - T-SQL - Failover
          7.3.5. Recover single table
     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. Use DMVs to monitor perf
          7.5.6. Create alerts
          7.5.7. Extended events - event file
          7.5.8. Extended events - ring buffer
          7.5.9. Diagnostic logging
          7.5.10. Troubleshoot connectivity
          7.5.11. Azure Automation
          7.5.12. Azure RemoteApp
     7.6. Scale out apps
          7.6.1. Create sharded app
          7.6.2. Move sharded data
          7.6.3. Security configuration
          7.6.4. Add a shard
          7.6.5. Fix shard map problems
          7.6.6. Migrate sharded DB
          7.6.7. Create counters
          7.6.8. Use entity framework
          7.6.9. Upgrade clients
          7.6.10. Install elastic job
          7.6.11. Create job - Portal
          7.6.12. Create job - PowerShell
          7.6.13. Create job - Sample app
          7.6.14. Uninstall elastic job
          7.6.15. Query horizontal data
          7.6.16. Query vertical data
          7.6.17. SaaS app tutorial
     7.7. Develop apps
          7.7.1. C and C ++
          7.7.2. Excel
          7.7.3. Create DB with C#
8. Reference
     8.1. 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 guidance
     9.11. Customer implementations
     9.12. Sample applications
          9.12.1. Tailspin Surveys
          9.12.2. Contoso Clinic
          9.12.3. Elastic pool telemetry
          9.12.4. Elastic pool custom dashboard

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.