| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
Configure & manage content reference |
Find a reference of content that teaches you to configure and manage Azure SQL Database. |
WilliamDAssafMSFT |
wiassaf |
mathoma |
01/14/2020 |
sql-database |
deployment-configuration |
conceptual |
sqldbrb=1 |
[!INCLUDEappliesto-sqldb]
In this article you can find a content reference of various guides, scripts, and explanations that can help you to manage and configure your Azure SQL Database.
- Migrate to SQL Database
- Learn how to manage SQL Database after migration.
- Copy a database
- Import a DB from a BACPAC
- Export a DB to BACPAC
- Load data with BCP
- Load data with ADF
- Configure Microsoft Entra auth
- Configure Conditional Access
- Microsoft Entra multifactor authentication
- Configure backup retention for a database to keep your backups on Azure Blob Storage.
- Configure geo-replication to keep a replica of your database in another region.
- Configure failover group to fail over a group of single or pooled databases to a secondary server in another region in the event of a disaster.
- Configure temporal retention policy
- Configure TDE with BYOK
- Rotate TDE BYOK keys
- Remove TDE protector
- Configure In-Memory OLTP
- Configure Azure Automation
- Configure transactional replication to replicate your date between databases.
- Configure threat detection to let Azure SQL Database identify suspicious activities such as SQL Injection or access from suspicious locations.
- Configure dynamic data masking to protect your sensitive data.
- Configure security for geo-replicas.
- Manual tuning
- Use DMVs to monitor performance
- Use Query store to monitor performance
- Enable automatic tuning to let Azure SQL Database optimize performance of your workload.
- Enable e-mail notifications for automatic tuning to get information about tuning recommendations.
- Apply performance recommendations and optimize your database.
- Create alerts to get notifications from Azure SQL Database.
- Troubleshoot connectivity if you notice some connectivity issues between the applications and the database. You can also use Resource Health for connectivity issues.
- Troubleshoot performance with Intelligent Insights
- Manage file space to monitor storage usage in your database.
- Use Intelligent Insights diagnostics log
- Monitor In-memory OLTP space
- Query vertically partitioned data across multiple databases.
- Report across scaled-out data tier.
- Query across tables with different schemas.
- SQL Data Sync
- Data Sync Agent
- Replicate schema changes
- Monitor with OMS
- Best practices for Data Sync
- Troubleshoot Data Sync
- Create and manage Elastic Database Jobs using PowerShell.
- Create and manage Elastic Database Jobs using Transact-SQL.
- Upgrade elastic database client library.
- Create sharded app.
- Query horizontally sharded data.
- Run Multi-shard queries.
- Move sharded data.
- Configure security in database shards.
- Add a shard to the current set of database shards.
- Fix shard map problems.
- Migrate sharded DB.
- Create counters.
- Use entity framework to query sharded data.
- Use Dapper framework to query sharded data.
- Connectivity
- Use Spark Connector
- Authenticate app
- Use batching for better performance
- Connectivity guidance
- DNS aliases
- Setup DNS alias PowerShell
- Ports - ADO.NET
- C and C ++
- Excel
- Learn more about How-to guides for Azure SQL Managed Instance