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
-
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.
-
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...
-
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,...
-
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...
-
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...
-
Azure SQL Database built-in intelligence features will maximize both performance and security of your applications, dramatically reducing the costs of running and managing...
-
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...
-
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...
-
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,...
Upcoming Events
| Date | Title |
|---|---|
| 11/1/2018 |
Latest Content
| Date | Title | |
|---|---|---|
| 10/19/2018 |
|
|
| 10/18/2018 |
|
|
| 10/18/2018 |
|
|
| 10/17/2018 |
|
|
| 10/16/2018 |
|
|
| 10/16/2018 |
|
|
| 10/9/2018 |
|
|
| 10/5/2018 |
|
|
| 10/5/2018 |
|
|
| 10/5/2018 |
|
|
| 10/5/2018 |
|
|
| 10/2/2018 |
|
Web Content
SQL Database Documentation
1. SQL Database Service1.1. About SQL DB
1.2. Choose a version of Azure SQL
2. Quickstarts
2.1. Create
2.1.1. Single database
2.1.2. Managed Instance
2.2. Configure
2.2.1. Logical server firewall rule
2.2.2. Client VM connection to a Managed Instance
2.2.3. Point-to-site connection to a Managed Instance
2.3. Load data
2.3.1. Import BACPAC into a single database
2.3.2. Restore a database backup to a Managed Instance
2.4. Query
2.4.1. SSMS
2.4.2. Azure Data Studio
2.4.3. Azure portal
2.4.4. VS Code
2.4.5. .NET with Visual Studio
2.4.6. .NET core
2.4.7. .NET with Active Directory MFA
2.4.8. Go
2.4.9. Java
2.4.10. Node.js
2.4.11. PHP
2.4.12. Python
2.4.13. Ruby
3. Tutorials
3.1. 1 - Design DB using SSMS
3.2. 2 - Design DB using .NET
3.3. 3 - Migrate to a single Azure SQL database using DMS
3.4. 4 - Secure your SQL DB
3.5. 5 - Implement a geo-distributed database
3.6. 6 - Migrate to a Managed Instance using DMS
3.7. 7 - Set up Azure SQL Data Sync
4. Samples
4.1. Code samples
4.2. Azure CLI
4.3. Azure PowerShell
5. Concepts
5.1. Purchasing models
5.1.1. vCore vs. DTU
5.1.2. vCore-based purchasing model
5.1.2.1. Choosing a vCore service tier
5.1.2.2. General Purpose / Business Critical
5.1.2.3. Hyperscale
5.1.2.4. Hyperscale FAQ
5.1.3. DTU service tiers
5.1.4. Prepay for reserved capacity
5.2. Logical servers
5.2.1. Create and manage
5.2.2. Resource limits
5.2.3. Connectivity architecture
5.2.4. T-SQL differences
5.2.5. Transactional replication - single DBs and elastic pools
5.3. Single databases
5.3.1. Create and manage
5.3.2. vCore-based resource limits
5.3.3. DTU-based resource limits
5.3.4. Scale resources
5.4. Elastic pools
5.4.1. Elastic pools
5.4.2. Create and manage
5.4.3. vCore-based resource limits
5.4.4. DTU-based resource limits
5.4.5. Scale resources
5.5. Managed instances
5.5.1. Managed instances
5.5.2. Resource limits
5.5.3. VNet configuration
5.5.4. Custom DNS
5.5.5. Sync network configuration
5.5.6. Connectivity architecture
5.5.7. Connect applications
5.5.8. T-SQL differences
5.5.9. Transactional replication
5.6. Business continuity
5.6.1. Business continuity
5.6.2. High availability
5.6.3. Accelerated database recovery
5.6.4. Database backups
5.6.5. Long-term backup retention
5.6.5.1. Long-term backup retention
5.6.5.2. Configure using Azure blob storage
5.6.5.3. Configure using Azure vault (deprecated)
5.6.6. Failover groups and geo-replication
5.6.6.1. Failover groups and geo-replication
5.6.6.2. Configure geo-replication - Portal
5.6.6.3. Configure security for replicas
5.6.7. Database recovery options
5.6.7.1. Recovery using backups
5.6.7.2. Outage recovery guidance
5.6.7.3. Recovery drills
5.6.8. App design
5.6.8.1. Design for disaster recovery
5.6.8.2. Design for elastic pools
5.6.8.3. Design for app upgrades
5.7. Security
5.7.1. Security
5.7.2. Advanced Threat Protection
5.7.2.1. Advanced Threat Protection
5.7.2.2. Data discovery and classification
5.7.2.3. Vulnerability assessment
5.7.2.4. Threat detection - SQL Database
5.7.2.5. Threat detection - Managed Instance
5.7.3. Firewall rules
5.7.3.1. Create and manage
5.7.3.2. Virtual network endpoints
5.7.3.3. Virtual network endpoints - PowerShell
5.7.4. Access control
5.7.4.1. Access control
5.7.4.2. Logins and users
5.7.5. Azure AD authentication
5.7.5.1. Azure AD authentication
5.7.5.2. Configure Azure AD auth
5.7.5.3. Conditional access
5.7.5.4. Multi-factor auth
5.7.5.5. Configure multi-factor auth
5.7.6. Auditing
5.7.6.1. Auditing - Servers, pools, and databases
5.7.6.2. Auditing - Managed Instance
5.7.6.3. Table auditing (deprecated)
5.7.7. Dynamic data masking
5.7.7.1. Dynamic data masking
5.7.7.2. Configure masking
5.7.8. Always encrypted
5.7.8.1. Use the certificate store
5.7.8.2. Use the Azure key vault
5.7.9. TDE with Azure SQL
5.7.9.1. TDE with Azure SQL
5.7.9.2. TDE with Bring Your Own Key
5.7.9.3. Configure TDE with BYOK
5.7.9.4. Rotate TDE BYOK keys
5.7.9.5. Remove TDE protector
5.8. Elastic scalability
5.8.1. Resource scalability
5.8.2. Read Scale-Out
5.8.3. Database sharding
5.8.3.1. Database sharding
5.8.3.2. Elastic client library - consolidate
5.8.3.3. Upgrade elastic database client library
5.8.3.4. Shard maps
5.8.3.5. Query routing
5.8.3.6. Manage credentials
5.8.3.7. Shard querying
5.8.3.8. Elastic tools
5.8.3.9. Move sharded data
5.8.3.10. Elastic client library - Dapper
5.8.3.11. Elastic tools FAQ
5.8.3.12. Create sharded app
5.8.3.13. Query horizontally-sharded data
5.8.3.14. Move sharded data
5.8.3.15. Security configuration
5.8.3.16. Add a shard
5.8.3.17. Fix shard map problems
5.8.3.18. Migrate sharded DB
5.8.3.19. Create counters
5.8.3.20. Use entity framework
5.9. SQL features comparison
5.10. Monitoring and performance tuning
5.10.1. Monitoring and tuning overview
5.10.2. Intelligent performance
5.10.2.1. Querying
5.10.2.1.1. Intelligent query processing
5.10.2.1.2. Adaptive query processing
5.10.2.2. Monitoring and tuning
5.10.2.2.1. Database advisor performance recommendations
5.10.2.2.2. Tuning actions and recommendations
5.10.2.2.3. Apply performance recommendations
5.10.2.3. Intelligent Insights
5.10.2.3.1. Intelligent Insights overview
5.10.2.3.2. Diagnostic logging
5.10.2.3.3. Use the diagnostics log
5.10.2.3.4. Query Performance Insight
5.10.2.3.5. Performance troubleshooting
5.10.2.4. Automatic tuning
5.10.2.4.1. Automatic tuning overview
5.10.2.4.2. Enable automatic tuning
5.10.2.4.3. Enable E-mail notifications
5.10.3. Manual tuning
5.10.3.1. Manual tuning
5.10.3.2. Use DMVs to monitor perf
5.10.3.3. Operate query store
5.10.3.4. In-memory
5.10.3.5. Extended events
5.10.3.5.1. Extended events
5.10.3.5.2. Extended events - event file
5.10.3.5.3. Extended events - ring buffer
5.10.4. Create alerts
5.10.5. Troubleshoot connectivity
5.10.6. Azure Automation
5.11. Cross-database operations
5.11.1. Elastic Database jobs
5.11.1.1. Elastic Database jobs
5.11.1.2. Create and manage (PowerShell)
5.11.1.3. Create and manage (T-SQL)
5.11.1.4. Migrate (from old Elastic jobs)
5.11.1.5. Elastic jobs (deprecated)
5.11.1.5.1. Elastic jobs (deprecated)
5.11.1.5.2. Install elastic job (deprecated)
5.11.1.5.3. Create job - Portal (deprecated)
5.11.1.5.4. Create job - Azure PowerShell (deprecated)
5.11.1.5.5. Create job - Sample app (deprecated)
5.11.1.5.6. Uninstall elastic job (deprecated)
5.11.2. Elastic queries
5.11.2.1. Elastic queries
5.11.2.2. Query vertically partitioned data
5.11.2.3. Report across scaled-out data tier
5.11.2.4. Query across tables with different schemas
5.11.3. Elastic transactions
5.12. Multi-tenant SaaS
5.12.1. SaaS design patterns
5.12.2. SaaS video indexer
5.12.3. SaaS app security
5.13. Develop databases
5.13.1. Develop databases
5.13.2. JSON data
5.13.3. In-memory
5.13.4. Temporal tables
5.13.5. Retention policies
5.13.6. Configure In-Memory
6. How-to guides
6.1. Migrate to SQL Database
6.1.1. Migrate to SQL Database
6.1.2. Migrate to Managed Instance
6.1.3. Migrate TDE cert to Managed Instance
6.1.4. Manage SQL Database after migration
6.2. Load and move data
6.2.1. Copy a DB within Azure
6.2.2. Import a DB from a BACPAC
6.2.3. Export a DB to BACPAC
6.2.4. Data sync
6.2.4.1. SQL Data Sync
6.2.4.2. Replicate schema changes
6.2.4.3. Monitor with OMS
6.2.4.4. Best practices for Data Sync
6.2.4.5. Troubleshoot Data Sync
6.2.5. Load data with BCP
6.2.6. Load data with ADF
6.3. Manage file space
6.4. Develop apps
6.4.1. Connectivity
6.4.2. Use Spark Connector
6.4.3. Authenticate app
6.4.4. Error messages
6.4.5. Batching for perf
6.4.6. Connectivity guidance
6.4.7. DNS aliases
6.4.8. DNS alias PowerShell
6.4.9. Ports - ADO.NET
6.4.10. C and C ++
6.4.11. Excel
6.5. Multi-tenant SaaS sample application
6.5.1. Wingtip Tickets sample
6.5.2. General guidance
6.5.3. Standalone application
6.5.3.1. Deploy example app
6.5.3.2. Provision tenants
6.5.4. Database per tenant
6.5.4.1. Tutorial intro
6.5.4.2. Deploy example app
6.5.4.3. Provision tenants
6.5.4.4. Monitor database performance
6.5.4.5. Monitor with log analytics
6.5.4.6. Restore one tenant
6.5.4.7. Manage tenant schema
6.5.4.8. Cross-tenant reporting
6.5.4.9. Tenant analytics
6.5.4.9.1. With SQL DB
6.5.4.9.2. With SQL DW
6.5.4.10. Disaster recovery using geo-restore
6.5.4.11. Disaster recovery using database geo-replication
6.5.5. Multi-tenant database
6.5.5.1. Deploy example app
6.5.5.2. Provision tenants
6.5.5.3. Monitor database performance
6.5.5.4. Run ad-hoc queries
6.5.5.5. Manage tenant schema
6.5.5.6. ETL for analytics
7. Reference
7.1. Azure PowerShell
7.2. Azure CLI
7.3. .NET
7.4. Java
7.5. Node.js
7.6. Python
7.7. Ruby
7.8. PHP
7.9. T-SQL
7.10. REST
7.11. SQL Server tools
7.12. SQL Server Management Studio (SSMS)
7.13. SQL Server Data Tools (SSDT)
7.14. BCP
7.15. SQLCMD
7.16. SqlPackage
7.17. SQL Database Management Library package
7.18. SQL Server drivers
7.18.1. ADO.NET
7.18.2. JDBC
7.18.3. ODBC
8. Resources
8.1. Build your skills with Microsoft Learn
8.2. Azure Roadmap
8.3. FAQ
8.4. Public data sets
8.5. Troubleshoot connectivity
8.6. Pricing
8.7. MSDN forum
8.8. Stack Overflow
8.9. Videos
8.10. Service updates
8.11. Architecture center
8.12. Customer stories
Web Pages
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. |
