Configure and manage content reference - Azure SQL Database
APPLIES TO: Azure SQL Database
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 Azure Active Directory (Azure AD) auth
- Configure Conditional Access
- Multi-factor Azure AD auth
- Configure Multi-Factor Authentication
- 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 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 security for geo-replicas.
Monitor and tune your database
- 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 distributed data
- 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
Elastic Database jobs
- Create and manage Elastic Database Jobs using PowerShell.
- Create and manage Elastic Database Jobs using Transact-SQL.
- Migrate from old Elastic job.
- 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.
- Use Spark Connector
- Authenticate app
- Use batching for better performance
- Connectivity guidance
- DNS aliases
- Setup DNS alias PowerShell
- Ports - ADO.NET
- C and C ++
Design Multi-tenant software as a service (SaaS) applications
- Learn more about How-to guides for Azure SQL Managed Instance