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.

Load data

• 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 features

• 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.

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

Extended events

• Extended events
• Store Extended events into event file
• Store Extended events into ring buffer

Query distributed data

• Query vertically partitioned data across multiple databases.
• Report across scaled-out data tier.
• Query across tables with different schemas.

Data sync

• 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.

Database sharding

• 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.

Develop applications

• 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

Design applications

• Design for disaster recovery
• Design for elastic pools
• Design for app upgrades

Design multitenant software as a service (SaaS) applications

• SaaS design patterns
• SaaS video indexer
• SaaS app security

Related content

• Learn more about How-to guides for Azure SQL Managed Instance