Back to Details

azure-sql-database

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Azure SQL Database Skill

Azure SQL Database技能

This skill provides expert guidance for Azure SQL Database. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.
本技能为Azure SQL Database提供专业指导，涵盖故障排查、最佳实践、决策制定、架构与设计模式、限制与配额、安全、配置、集成与编码模式以及部署。它结合了本地快速参考内容与远程文档获取能力。

How to Use This Skill

如何使用本技能

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., 
L35-L120
), use 
read_file
with the specified lines. For categories with file links (e.g., 
[security.md](security.md)
), use 
read_file
on the linked reference file
IMPORTANT for Agent: If 
metadata.generated_at
is more than 3 months old, suggest the user pull the latest version from the repository. If 
mcp_microsoftdocs
tools are not available, suggest the user install it: Installation Guide
This skill requires network access to fetch documentation content:
  • Preferred: Use 
    mcp_microsoftdocs:microsoft_docs_fetch
    with query string 
    from=learn-agent-skill
    . Returns Markdown.
  • Fallback: Use 
    fetch_webpage
    with query string 
    from=learn-agent-skill&accept=text/markdown
    . Returns Markdown.
Agent注意事项：使用下方的分类索引查找相关章节。对于带有行范围的分类（例如
L35-L120
），使用
read_file
读取指定行；对于带有文件链接的分类（例如
[security.md](security.md)
），使用
read_file
读取链接的参考文件
Agent注意事项：如果
metadata.generated_at
已超过3个月，建议用户从仓库拉取最新版本。如果
mcp_microsoftdocs
工具不可用，建议用户安装：安装指南
本技能需要网络访问权限来获取文档内容：
  • 首选方式：使用
    mcp_microsoftdocs:microsoft_docs_fetch
    ，查询字符串为
    from=learn-agent-skill
    ，返回Markdown格式内容。
  • 备用方式：使用
    fetch_webpage
    ，查询字符串为
    from=learn-agent-skill&accept=text/markdown
    ，返回Markdown格式内容。

Category Index

分类索引

CategoryLinesDescription
TroubleshootingL37-L62Diagnosing and fixing Azure SQL issues: performance, deadlocks, blocking, CPU/memory, capacity, import/export, connectivity, geo-replication, Data Sync, serverless, and log-full errors.
Best PracticesL63-L79Best practices for Azure SQL operations: monitoring, auditing, security, HA/DR, failover, read replicas, maintenance, elastic pool tuning, file space, Data Sync, and T-SQL adaptation.
Decision MakingL80-L107Guidance for choosing Azure SQL tiers, pricing models, DR/HA, Hyperscale options, licensing/Reservations, automation, and migration paths (on-prem, DTU↔vCore, SQL Data Sync, elastic sharding).
Architecture & Design PatternsL108-L126Architectural patterns for Azure SQL apps: geo-replication, DR/BCP, connectivity/routing, sharding & elastic scale, multi-tenant SaaS models, Hyperscale internals, and upgrade/failover designs.
Limits & QuotasL127-L142Limits, quotas, and behaviors for Azure SQL: backups immutability, free tier offers, DTU/vCore pool/single DB caps, serverless billing rules, and maintenance window constraints.
SecurityL143-L209Securing Azure SQL: authentication (Entra, MI, MFA), network/firewall, auditing, encryption (TDE, Always Encrypted), threat protection, data masking/classification, and compliance policies.
ConfigurationL210-L278Configuring Azure SQL databases: monitoring, backups, security, scaling, geo-replication/failover, elastic pools/jobs, Data Sync, serverless, maintenance windows, and CLI/PowerShell/REST setup.
Integrations & Coding PatternsL279-L309Connecting apps and tools to Azure SQL (EF Core, .NET, Node.js, Python, Go), plus PowerShell/CLI automation for auditing, scaling, geo-replication, data sync, and streaming/Spark integration.
DeploymentL310-L322Deploying and managing Azure SQL databases: CI/CD with GitHub/Terraform, scaling and tier changes (Hyperscale, zones, elastic pools), regional moves, and checking feature availability by region.
分类行范围描述
故障排查L37-L62诊断并修复Azure SQL问题：性能、死锁、阻塞、CPU/内存、容量、导入/导出、连接性、异地复制、数据同步、无服务器以及日志已满错误。
最佳实践L63-L79Azure SQL操作的最佳实践：监控、审计、安全、高可用性/灾难恢复、故障转移、只读副本、维护、弹性池调优、文件空间、数据同步以及T-SQL适配。
决策制定L80-L107选择Azure SQL层级、定价模型、灾难恢复/高可用性、Hyperscale选项、许可/预留实例、自动化以及迁移路径（本地、DTU↔vCore、SQL数据同步、弹性分片）的指导。
架构与设计模式L108-L126Azure SQL应用的架构模式：异地复制、灾难恢复/业务连续性规划、连接性/路由、分片与弹性扩展、多租户SaaS模型、Hyperscale内部机制以及升级/故障转移设计。
限制与配额L127-L142Azure SQL的限制、配额与行为：备份不可变性、免费层级优惠、DTU/vCore池/单个数据库上限、无服务器计费规则以及维护窗口约束。
安全L143-L209Azure SQL安全配置：身份验证（Entra、托管标识、MFA）、网络/防火墙、审计、加密（TDE、Always Encrypted）、威胁防护、数据掩码/分类以及合规策略。
配置L210-L278Azure SQL数据库配置：监控、备份、安全、扩容、异地复制/故障转移、弹性池/作业、数据同步、无服务器、维护窗口以及CLI/PowerShell/REST设置。
集成与编码模式L279-L309将应用与工具连接到Azure SQL（EF Core、.NET、Node.js、Python、Go），以及用于审计、扩容、异地复制、数据同步和流处理/Spark集成的PowerShell/CLI自动化。
部署L310-L322部署与管理Azure SQL数据库：使用GitHub/Terraform的CI/CD、扩容与层级变更（Hyperscale、区域、弹性池）、跨区域迁移以及按区域检查功能可用性。

Troubleshooting

故障排查

TopicURL
Troubleshoot Azure SQL capacity deployment and scaling errorshttps://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
Resolve common Azure SQL database watcher issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
Analyze and prevent deadlocks in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/analyze-prevent-deadlocks?view=azuresql
Fix slow database import and export in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Use RecoveryManager to fix Azure SQL shard mapshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-recovery-manager?view=azuresql
Troubleshoot Azure SQL Database Elastic Scale issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-faq?view=azuresql
Diagnose and fix high CPU in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-cpu-diagnose-troubleshoot?view=azuresql
Troubleshoot performance issues in Azure SQL Hyperscalehttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-performance-diagnostics?view=azuresql
Diagnose Azure SQL query performance bottleneckshttps://learn.microsoft.com/en-us/azure/azure-sql/database/identify-query-performance-issues?view=azuresql
Monitor and troubleshoot In-Memory OLTP storage capacityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-monitor-space?view=azuresql
Use DMVs to troubleshoot Azure SQL performancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql
Use Azure Resource Health to troubleshoot Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql
Troubleshoot auto-pause and resume in Azure SQL serverlesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-auto-pause-resume?view=azuresql
Troubleshoot common Azure SQL Data Sync issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot?view=azuresql
Troubleshoot transient connectivity errors for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
Troubleshoot Azure SQL and Fabric SQL connectivity errorshttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
Troubleshoot geo-replication and redo lag in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
Investigate and fix memory issues in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
Resolve transaction log full errors in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
Identify and resolve blocking in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/understand-resolve-blocking?view=azuresql
Resolve known issues in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
Resolve transaction log full errors in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi
主题URL
排查Azure SQL容量部署和扩容错误https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
解决Azure SQL数据库观察器常见问题https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
分析并预防Azure SQL Database中的死锁https://learn.microsoft.com/en-us/azure/azure-sql/database/analyze-prevent-deadlocks?view=azuresql
修复Azure SQL中缓慢的数据库导入和导出https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
使用RecoveryManager修复Azure SQL分片映射https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-recovery-manager?view=azuresql
排查Azure SQL Database弹性扩展问题https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-faq?view=azuresql
诊断并修复Azure SQL Database中的高CPU问题https://learn.microsoft.com/en-us/azure/azure-sql/database/high-cpu-diagnose-troubleshoot?view=azuresql
排查Azure SQL Hyperscale的性能问题https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-performance-diagnostics?view=azuresql
诊断Azure SQL查询性能瓶颈https://learn.microsoft.com/en-us/azure/azure-sql/database/identify-query-performance-issues?view=azuresql
监控并排查内存中OLTP存储容量问题https://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-monitor-space?view=azuresql
使用DMV排查Azure SQL性能问题https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql
使用Azure资源健康排查Azure SQL问题https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql
排查Azure SQL无服务器的自动暂停和恢复问题https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-auto-pause-resume?view=azuresql
排查Azure SQL数据同步常见问题https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot?view=azuresql
排查Azure SQL的临时连接错误https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
排查Azure SQL和Fabric SQL的连接错误https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
排查Azure SQL Database的异地复制和重做延迟问题https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
调查并修复Azure SQL Database中的内存问题https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
解决Azure SQL Database中的事务日志已满错误https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
识别并解决Azure SQL Database中的阻塞问题https://learn.microsoft.com/en-us/azure/azure-sql/database/understand-resolve-blocking?view=azuresql
解决Azure SQL托管实例中的已知问题https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
解决Azure SQL托管实例中的事务日志已满错误https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi

Best Practices

最佳实践

TopicURL
Analyze Azure SQL monitoring data with KQL and T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Apply auditing best practices in production Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-best-practices?view=azuresql
Run disaster recovery drills for Azure SQL workloadshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-drills?view=azuresql
Optimize resource management in dense Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql
Configure and operate Azure SQL failover groups with best practiceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql
Manage Azure SQL Database file space efficientlyhttps://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db
Apply HA and DR configuration checklist for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-disaster-recovery-checklist?view=azuresql
Plan for Azure SQL planned maintenance eventshttps://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
Configure and use read scale-out replicas in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
Apply security best practices to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database?view=azuresql
Apply security best practices for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
Apply best practices for Azure SQL Data Synchttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practices?view=azuresql
Adapt SQL Server T-SQL for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server?view=azuresql
主题URL
使用KQL和T-SQL分析Azure SQL监控数据https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
在生产环境Azure SQL中应用审计最佳实践https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-best-practices?view=azuresql
为Azure SQL工作负载运行灾难恢复演练https://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-drills?view=azuresql
优化密集型Azure SQL弹性池的资源管理https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql
按最佳实践配置和操作Azure SQL故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql
高效管理Azure SQL Database文件空间https://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db
应用Azure SQL高可用性和灾难恢复配置检查清单https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-disaster-recovery-checklist?view=azuresql
规划Azure SQL计划内维护事件https://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
配置并使用Azure SQL的只读横向扩展副本https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
为Azure SQL Database应用安全最佳实践https://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database?view=azuresql
为Azure SQL应用安全最佳实践https://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
应用Azure SQL数据同步最佳实践https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practices?view=azuresql
为Azure SQL Database适配SQL Server T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server?view=azuresql

Decision Making

决策制定

TopicURL
Decide when to use Azure Hybrid Benefit for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql
Use Azure SQL decision tree to choose servicehttps://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
Understand Copilot in Azure SQL capabilities and usagehttps://learn.microsoft.com/en-us/azure/azure-sql/copilot/copilot-azure-sql-faq?view=azuresql
Plan deployment of Always Encrypted secure enclaveshttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-plan?view=azuresql
Plan and manage Azure SQL Database costshttps://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management?view=azuresql
Choose Azure SQL disaster recovery options for regional outageshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance?view=azuresql
Choose migration path from elastic query shard map managerhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-horizontal-partitioning-migration?view=azuresql
Compare Azure SQL Database vs Managed Instance featureshttps://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
Plan and use Hyperscale elastic pools for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-overview?view=azuresql
Choose job automation options for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview?view=azuresql
Plan and manage Azure SQL Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/manage-hyperscale-database?view=azuresql
Migrate Azure SQL databases from DTU to vCore modelhttps://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql
Choose Azure SQL Database vCore vs DTU purchasinghttps://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?view=azuresql
Choose and use Azure Reservations for Azure SQL computehttps://learn.microsoft.com/en-us/azure/azure-sql/database/reservations-discount-overview?view=azuresql
Reverse migrate Azure SQL Hyperscale to General Purposehttps://learn.microsoft.com/en-us/azure/azure-sql/database/reverse-migrate-from-hyperscale?view=azuresql
Choose Azure SQL serverless vs provisioned tiershttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql
Evaluate Azure SQL Hyperscale capabilities and constraintshttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq?view=azuresql
Choose and use Hyperscale secondary replica typeshttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql
Decide when to use Azure SQL Hyperscale tierhttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql
Use DTU-based purchasing model for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql
Choose Azure SQL Database vCore service tiershttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql
Select migration alternatives for retiring SQL Data Synchttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-retirement-migration?view=azuresql
Configure license-free standby replicas for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/standby-replica-how-to-configure?view=azuresql
Plan and decide SQL Server to Azure SQL migrationshttps://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/modernization?view=azuresql
主题URL
决定何时为Azure SQL使用Azure混合权益https://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql
使用Azure SQL决策树选择服务https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
了解Azure SQL中Copilot的功能和用法https://learn.microsoft.com/en-us/azure/azure-sql/copilot/copilot-azure-sql-faq?view=azuresql
规划Always Encrypted安全隔离区的部署https://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-plan?view=azuresql
规划并管理Azure SQL Database成本https://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management?view=azuresql
为区域中断选择Azure SQL灾难恢复选项https://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance?view=azuresql
选择从弹性查询分片映射管理器迁移的路径https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-horizontal-partitioning-migration?view=azuresql
比较Azure SQL Database与托管实例的功能https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
规划并使用Azure SQL的Hyperscale弹性池https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-overview?view=azuresql
为Azure SQL和Synapse选择作业自动化选项https://learn.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview?view=azuresql
规划并管理Azure SQL Hyperscale数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/manage-hyperscale-database?view=azuresql
将Azure SQL数据库从DTU模型迁移到vCore模型https://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql
选择Azure SQL Database的vCore与DTU购买模式https://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?view=azuresql
选择并使用Azure预留实例以获取Azure SQL计算折扣https://learn.microsoft.com/en-us/azure/azure-sql/database/reservations-discount-overview?view=azuresql
将Azure SQL Hyperscale反向迁移到通用层级https://learn.microsoft.com/en-us/azure/azure-sql/database/reverse-migrate-from-hyperscale?view=azuresql
选择Azure SQL无服务器与预配层级https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql
评估Azure SQL Hyperscale的功能和约束https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq?view=azuresql
选择并使用Hyperscale辅助副本类型https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql
决定何时使用Azure SQL Hyperscale层级https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql
为Azure SQL使用基于DTU的购买模式https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql
选择Azure SQL Database的vCore服务层级https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql
选择SQL数据同步停用后的迁移替代方案https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-retirement-migration?view=azuresql
为Azure SQL配置无许可备用副本https://learn.microsoft.com/en-us/azure/azure-sql/database/standby-replica-how-to-configure?view=azuresql
规划并决定SQL Server到Azure SQL的迁移https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/modernization?view=azuresql

Architecture & Design Patterns

架构与设计模式

TopicURL
Design and use active geo-replication for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql
Plan Azure SQL Database business continuity and DRhttps://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql
Understand Azure SQL connectivity architecture and routinghttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
Understand Azure SQL connectivity architecture and connection policieshttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
Choose geo-replication patterns for global Azure SQL appshttps://learn.microsoft.com/en-us/azure/azure-sql/database/designing-cloud-solutions-for-disaster-recovery?view=azuresql
Disaster recovery patterns for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-strategies-for-applications-with-elastic-pool?view=azuresql
Configure elastic queries over sharded Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-horizontal-partitioning?view=azuresql
Query vertically partitioned Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-vertical-partitioning?view=azuresql
Design elastic scale-out architectures with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-introduction?view=azuresql
Move and rebalance data between sharded Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-overview-split-and-merge?view=azuresql
Configure geo-distributed Azure SQL applications with failoverhttps://learn.microsoft.com/en-us/azure/azure-sql/database/geo-distributed-application-configure-tutorial?view=azuresql
Design Azure SQL local and zone redundancyhttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql
Understand Azure SQL Hyperscale distributed architecturehttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-architecture?view=azuresql
Design rolling upgrade patterns with Azure SQL geo-replicationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/manage-application-rolling-upgrade?view=azuresql
Select multitenant SaaS tenancy models on Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/saas-tenancy-app-design-patterns?view=azuresql
主题URL
设计并使用Azure SQL数据库的主动异地复制https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql
规划Azure SQL Database业务连续性和灾难恢复https://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql
了解Azure SQL连接架构和路由https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
了解Azure SQL连接架构和连接策略https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
为全球Azure SQL应用选择异地复制模式https://learn.microsoft.com/en-us/azure/azure-sql/database/designing-cloud-solutions-for-disaster-recovery?view=azuresql
Azure SQL弹性池的灾难恢复模式https://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-strategies-for-applications-with-elastic-pool?view=azuresql
为分片Azure SQL数据库配置弹性查询https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-horizontal-partitioning?view=azuresql
查询垂直分区的Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-vertical-partitioning?view=azuresql
使用Azure SQL设计弹性横向扩展架构https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-introduction?view=azuresql
在分片Azure SQL数据库之间移动和重新平衡数据https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-overview-split-and-merge?view=azuresql
配置带有故障转移的地理分布式Azure SQL应用https://learn.microsoft.com/en-us/azure/azure-sql/database/geo-distributed-application-configure-tutorial?view=azuresql
设计Azure SQL本地和区域冗余https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql
了解Azure SQL Hyperscale分布式架构https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-architecture?view=azuresql
使用Azure SQL异地复制设计滚动升级模式https://learn.microsoft.com/en-us/azure/azure-sql/database/manage-application-rolling-upgrade?view=azuresql
在Azure SQL上选择多租户SaaS租户模型https://learn.microsoft.com/en-us/azure/azure-sql/database/saas-tenancy-app-design-patterns?view=azuresql

Limits & Quotas

限制与配额

TopicURL
Understand automatic backup immutability for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/automatic-backup-immutability?view=azuresql
Track new Azure SQL Database features and free tier limitshttps://learn.microsoft.com/en-us/azure/azure-sql/database/doc-changes-updates-release-notes-whats-new?view=azuresql
Understand Azure SQL Database free offer limitshttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql
Understand Azure SQL Database free tier limitshttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql
Use Azure free account to deploy free Azure SQL databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-sql-db-free-account-how-to-deploy?view=azuresql
Understand Azure SQL Database maintenance window behaviorhttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-faq?view=azuresql
Elastic pool DTU resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-elastic-pools?view=azuresql
Single database DTU resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases?view=azuresql
Review vCore resource limits for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-elastic-pools?view=azuresql
Review vCore resource limits for single Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql
Understand Azure SQL serverless billing limits and ruleshttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-billing?view=azuresql
Azure SQL serverless FAQ on limits and behaviorhttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-faq?view=azuresql
主题URL
了解Azure SQL自动备份不可变性https://learn.microsoft.com/en-us/azure/azure-sql/automatic-backup-immutability?view=azuresql
跟踪Azure SQL Database新功能和免费层级限制https://learn.microsoft.com/en-us/azure/azure-sql/database/doc-changes-updates-release-notes-whats-new?view=azuresql
了解Azure SQL Database免费优惠限制https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql
了解Azure SQL Database免费层级限制https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql
使用Azure免费账户部署免费Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/free-sql-db-free-account-how-to-deploy?view=azuresql
了解Azure SQL Database维护窗口行为https://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-faq?view=azuresql
Azure SQL弹性池DTU资源限制https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-elastic-pools?view=azuresql
Azure SQL单个数据库DTU资源限制https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases?view=azuresql
查看Azure SQL弹性池vCore资源限制https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-elastic-pools?view=azuresql
查看Azure SQL单个数据库vCore资源限制https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql
了解Azure SQL无服务器计费限制和规则https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-billing?view=azuresql
Azure SQL无服务器限制与行为常见问题https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-faq?view=azuresql

Security

安全

TopicURL
Connect .NET to Azure SQL with Entra MFAhttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-directory-interactive-connect-azure-sql-db?view=azuresql
Configure security for Azure SQL disaster recovery replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-security-configure?view=azuresql
Configure Azure Attestation for Always Encrypted enclaveshttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-configure-attestation?view=azuresql
Enable Always Encrypted with secure enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-enable?view=azuresql
Get started with Always Encrypted secure enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started?view=azuresql
Register Entra applications for Azure SQL accesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/application-authentication-get-client-id-keys?view=azuresql
Configure Azure SQL auditing to storage behind VNethttps://learn.microsoft.com/en-us/azure/azure-sql/database/audit-write-storage-account-behind-vnet-firewall?view=azuresql
Configure managed identity for Azure SQL auditing to storagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-managed-identity?view=azuresql
Audit Microsoft support operations on Azure SQL servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-microsoft-support-operations?view=azuresql
Understand server vs database-level auditing policieshttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-server-level-database-level?view=azuresql
Configure auditing for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql
Configure Microsoft Entra authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
Understand Directory Readers role requirements for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
Configure Microsoft Entra authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
Configure Entra service principals for Azure SQL accesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal-tutorial?view=azuresql
Use Entra service principals with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal?view=azuresql
Create and manage Entra logins in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins-tutorial?view=azuresql
Use Microsoft Entra server principals in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql
Create Azure SQL server with Entra-only authenticationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql
Create Azure SQL logical server with user-assigned managed identityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity-create-server?view=azuresql
Configure managed identities for Azure SQL accesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
Configure Microsoft Entra authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql?view=azuresql
Configure and use Microsoft Defender for SQL with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql
Migrate Node.js apps to passwordless Azure SQL authhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-nodejs?view=azuresql
Migrate Python apps to passwordless Azure SQL authenticationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-python?view=azuresql
Migrate .NET apps to passwordless Azure SQL authhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration?view=azuresql
Use backup immutability for long-term retention in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability?view=azuresql
Block T-SQL CRUD for Azure SQL resource protectionhttps://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
Classify and label sensitive data in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
Import/export Azure SQL databases with Azure services access disabledhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-azure-services-off?view=azuresql
Use managed identity for Azure SQL import and exporthttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-managed-identity?view=azuresql
Import/export Azure SQL databases over Private Linkhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-private-link?view=azuresql
Set up dynamic data masking in Azure SQL portalhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-configure-portal?view=azuresql
Configure dynamic data masking in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
Configure regex-based dynamic data masking in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-regex?view=azuresql
Configure split-merge service security with certificateshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-split-merge-security-configuration?view=azuresql
Configure Azure SQL Database IP firewall rules securelyhttps://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql
Configure isolated security for Hyperscale named replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-security-configure?view=azuresql
Configure logins and user access in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
Configure network access controls for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview?view=azuresql
Configure Network Security Perimeter for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/network-security-perimeter?view=azuresql
Configure outbound firewall rules for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/outbound-firewall-rule-overview?view=azuresql
Apply built-in Azure Policy definitions for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
Manage Azure SQL VNet service endpoints with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/vnet-service-endpoint-rule-powershell-create?view=azuresql
Secure an Azure SQL Database using built-in featureshttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial?view=azuresql
Use Azure Policy regulatory controls for Azure SQL compliancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
Use fixed server roles on Azure SQL logical servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-server-roles?view=azuresql
Store SQL Vulnerability Assessment scans in secured storagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-vulnerability-assessment-storage?view=azuresql
Configure Advanced Threat Protection for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-configure?view=azuresql
Use Advanced Threat Protection for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql
Enable TDE with Azure Key Vault for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql
Configure cross-tenant CMK TDE with user-assigned identityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server-cross-tenant?view=azuresql
Create Azure SQL server with user-assigned identity and CMK TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server?view=azuresql
Set up cross-tenant customer-managed keys for Azure SQL TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
Manage database-level customer-managed TDE keys in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-basic-actions?view=azuresql
Configure geo-replication and restore for database-level CMK TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-geo-replication-restore?view=azuresql
Configure database-level TDE with customer-managed keys in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-overview?view=azuresql
Configure TDE with user-assigned managed identity in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
Rotate Azure SQL TDE protector with PowerShell and CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-key-rotation?view=azuresql
Implement customer-managed TDE with Azure Key Vaulthttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
Rotate and remove BYOK TDE protector via PowerShell/CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-remove-tde-protector?view=azuresql
Secure Azure SQL with virtual network service endpoints and ruleshttps://learn.microsoft.com/en-us/azure/azure-sql/database/vnet-service-endpoint-rule-overview?view=azuresql
Prepare for Azure SQL TLS root certificate rotationhttps://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql
主题URL
使用Entra MFA将.NET连接到Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-directory-interactive-connect-azure-sql-db?view=azuresql
为Azure SQL灾难恢复副本配置安全https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-security-configure?view=azuresql
为Always Encrypted隔离区配置Azure证明https://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-configure-attestation?view=azuresql
在Azure SQL中启用带有安全隔离区的Always Encryptedhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-enable?view=azuresql
开始使用Azure SQL中的Always Encrypted安全隔离区https://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started?view=azuresql
注册Entra应用以访问Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/application-authentication-get-client-id-keys?view=azuresql
将Azure SQL审计配置到VNet后方的存储https://learn.microsoft.com/en-us/azure/azure-sql/database/audit-write-storage-account-behind-vnet-firewall?view=azuresql
为Azure SQL审计到存储配置托管标识https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-managed-identity?view=azuresql
审计Microsoft支持人员对Azure SQL服务器的操作https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-microsoft-support-operations?view=azuresql
了解服务器级与数据库级审计策略https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-server-level-database-level?view=azuresql
为Azure SQL和Synapse配置审计https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql
为Azure SQL配置Microsoft Entra身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
了解Azure SQL的目录读取者角色要求https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
为Azure SQL配置Microsoft Entra身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
为Azure SQL访问配置Entra服务主体https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal-tutorial?view=azuresql
将Entra服务主体与Azure SQL配合使用https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal?view=azuresql
在Azure SQL中创建和管理Entra登录名https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins-tutorial?view=azuresql
在Azure SQL中使用Microsoft Entra服务器主体https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql
创建仅支持Entra身份验证的Azure SQL服务器https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql
使用用户分配的托管标识创建Azure SQL逻辑服务器https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity-create-server?view=azuresql
为Azure SQL访问配置托管标识https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
为Azure SQL配置Microsoft Entra身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-microsoft-entra-connect-to-azure-sql?view=azuresql
为Azure SQL配置并使用Microsoft Defender for SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql
将Node.js应用迁移到无密码Azure SQL身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-nodejs?view=azuresql
将Python应用迁移到无密码Azure SQL身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-python?view=azuresql
将.NET应用迁移到无密码Azure SQL身份验证https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration?view=azuresql
使用备份不可变性实现Azure SQL长期保留https://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability?view=azuresql
阻止T-SQL CRUD操作以保护Azure SQL资源https://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
在Azure SQL中分类和标记敏感数据https://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
在禁用Azure服务访问的情况下导入/导出Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-azure-services-off?view=azuresql
使用托管标识进行Azure SQL导入和导出https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-managed-identity?view=azuresql
通过专用链接导入/导出Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-private-link?view=azuresql
在Azure门户中设置动态数据掩码https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-configure-portal?view=azuresql
在Azure SQL中配置动态数据掩码https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
在Azure SQL中配置基于正则表达式的动态数据掩码https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-regex?view=azuresql
使用证书配置拆分合并服务安全https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-split-merge-security-configuration?view=azuresql
安全配置Azure SQL Database IP防火墙规则https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql
为Hyperscale命名副本配置隔离安全https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-security-configure?view=azuresql
在Azure SQL Database中配置登录名和用户访问权限https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
为Azure SQL和Synapse配置网络访问控制https://learn.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview?view=azuresql
为Azure SQL Database配置网络安全边界https://learn.microsoft.com/en-us/azure/azure-sql/database/network-security-perimeter?view=azuresql
为Azure SQL配置出站防火墙规则https://learn.microsoft.com/en-us/azure/azure-sql/database/outbound-firewall-rule-overview?view=azuresql
为Azure SQL应用内置Azure Policy定义https://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
使用PowerShell管理Azure SQL VNet服务终结点https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/vnet-service-endpoint-rule-powershell-create?view=azuresql
使用内置功能保护Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial?view=azuresql
使用Azure Policy法规控制实现Azure SQL合规性https://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
在Azure SQL逻辑服务器上使用固定服务器角色https://learn.microsoft.com/en-us/azure/azure-sql/database/security-server-roles?view=azuresql
将SQL漏洞评估扫描存储在安全存储中https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-vulnerability-assessment-storage?view=azuresql
为Azure SQL配置高级威胁防护https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-configure?view=azuresql
为Azure SQL数据库使用高级威胁防护https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql
使用Azure Key Vault为Azure SQL启用TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql
使用用户分配的标识配置跨租户CMK TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server-cross-tenant?view=azuresql
使用用户分配的标识和CMK TDE创建Azure SQL服务器https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server?view=azuresql
为Azure SQL TDE设置跨租户客户管理密钥https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
在Azure SQL中管理数据库级客户管理TDE密钥https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-basic-actions?view=azuresql
为数据库级CMK TDE配置异地复制和恢复https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-geo-replication-restore?view=azuresql
在Azure SQL中配置带有客户管理密钥的数据库级TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-overview?view=azuresql
在Azure SQL中配置带有用户分配托管标识的TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
使用PowerShell和CLI轮换Azure SQL TDE保护器https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-key-rotation?view=azuresql
使用Azure Key Vault实现客户管理TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
通过PowerShell/CLI轮换和移除BYOK TDE保护器https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-remove-tde-protector?view=azuresql
使用虚拟网络服务终结点和规则保护Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/vnet-service-endpoint-rule-overview?view=azuresql
为Azure SQL TLS根证书轮换做准备https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql

Configuration

配置

TopicURL
Configure Azure Monitor alerts for database watcher datahttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
Understand Azure SQL database watcher datasets and schemahttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
Configure Azure SQL Database watcher settingshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
Create a database watcher with Entra auth and private connectivityhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-quickstart?view=azuresql
Configure active geo-replication and failover for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-configure-portal?view=azuresql
Configure ADO.NET direct routing ports for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/adonet-v12-develop-direct-route-ports?view=azuresql
Configure advance maintenance notifications for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/advance-notifications?view=azuresql
Configure Always Encrypted with Intel SGX enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-sgx?view=azuresql
Configure Always Encrypted with VBS enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-vbs?view=azuresql
Define and deploy Azure SQL resources with ARM templateshttps://learn.microsoft.com/en-us/azure/azure-sql/database/arm-templates-content-guide?view=azuresql
Interpret Azure SQL Database audit log formathttps://learn.microsoft.com/en-us/azure/azure-sql/database/audit-log-format?view=azuresql
Change automated backup retention and redundancy in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-change-settings?view=azuresql
Configure legal hold immutability for Azure SQL LTR backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-legal-hold?view=azuresql
Configure time-based immutability for Azure SQL LTR backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-time-based?view=azuresql
Configure MAXDOP for Azure SQL and Fabric databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism?view=azuresql
Configure TLS and connection policy for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql
Configure and execute Azure SQL database copyhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql
Configure and use soft delete for Azure SQL logical servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/deleted-logical-server-restore?view=azuresql
Understand DTU benchmark characteristics for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
Use performance counters for Azure SQL shard mapshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-perf-counters?view=azuresql
Understand and configure Azure SQL elastic jobshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql
Configure Azure SQL elastic jobs with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-powershell-create?view=azuresql
Configure Azure SQL elastic jobs with T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql
Create and manage Azure SQL elastic jobshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tutorial?view=azuresql
Create and manage Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-manage?view=azuresql
Configure scaling for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql
Configure elastic queries for vertically partitioned databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical?view=azuresql
Enable availability zone redundancy for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/enable-zone-redundancy?view=azuresql
Configure failover groups for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-configure-sql-db?view=azuresql
Configure automated backups for Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-automated-backups-overview?view=azuresql
Configure and manage Azure SQL Hyperscale named replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-configure?view=azuresql
Configure In-Memory OLTP for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-configure?view=azuresql
Configure Intelligent Insights monitoring for Azure SQL performancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
Configure dev container templates for Azure SQL developmenthttps://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers?view=azuresql
Configure long-term backup retention for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql
Configure maintenance windows for Azure SQL databases and poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-configure?view=azuresql
Understand and use maintenance windows for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window?view=azuresql
Identify modifiable settings in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/modifiable-configuration-reference?view=azuresql
Reference for Azure SQL Database monitoring metrics and logshttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
Configure monitoring for Azure SQL with Azure Monitorhttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor?view=azuresql
Restore Azure SQL databases from automatic backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql
Query Azure SQL resources with Azure Resource Graphhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-graph-samples?view=azuresql
Add Azure SQL databases to failover groups via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-cli?view=azuresql
Configure failover groups for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-cli?view=azuresql
Back up Azure SQL databases to storage with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/backup-database-cli?view=azuresql
Copy Azure SQL databases to new servers via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-cli?view=azuresql
Create and configure an Azure SQL database with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-cli?view=azuresql
Create and configure an Azure SQL database with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-powershell?view=azuresql
Import BACPAC files into Azure SQL using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-cli?view=azuresql
Monitor and scale an Azure SQL database with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-cli?view=azuresql
Move Azure SQL databases between elastic pools via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-cli?view=azuresql
Restore Azure SQL databases from backups using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-cli?view=azuresql
Scale Azure SQL elastic pools using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/scale-pool-cli?view=azuresql
Configure active geo-replication for Azure SQL via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-database-cli?view=azuresql
Configure Azure SQL failover groups with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-group-cli?view=azuresql
Set up geo-replication for pooled databases with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-pool-cli?view=azuresql
Configure SQL Data Sync between Azure SQL databases via RESThttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases-rest-api?view=azuresql
Configure autoscaling for Azure SQL serverless computehttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-auto-scaling?view=azuresql
Configure Azure SQL Database serverless settingshttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-create-configure?view=azuresql
Configure scaling for single Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-scale?view=azuresql
Install and configure Data Sync Agent for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-agent-overview?view=azuresql
Set up Azure SQL Data Sync groups and scheduleshttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql
Configure maintenance windows for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/maintenance-window-azure-sql?view=azuresql
Identify modifiable settings in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/modifiable-configuration-reference?view=azuresql
Reference monitoring metrics for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql
主题URL
为数据库观察器数据配置Azure Monitor警报https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
了解Azure SQL数据库观察器数据集和架构https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
配置Azure SQL Database观察器设置https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
使用Entra身份验证和专用连接创建数据库观察器https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-quickstart?view=azuresql
为Azure SQL配置主动异地复制和故障转移https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-configure-portal?view=azuresql
为Azure SQL配置ADO.NET直接路由端口https://learn.microsoft.com/en-us/azure/azure-sql/database/adonet-v12-develop-direct-route-ports?view=azuresql
为Azure SQL配置提前维护通知https://learn.microsoft.com/en-us/azure/azure-sql/database/advance-notifications?view=azuresql
在Azure SQL中配置带有Intel SGX隔离区的Always Encryptedhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-sgx?view=azuresql
在Azure SQL中配置带有VBS隔离区的Always Encryptedhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-vbs?view=azuresql
使用ARM模板定义和部署Azure SQL资源https://learn.microsoft.com/en-us/azure/azure-sql/database/arm-templates-content-guide?view=azuresql
解读Azure SQL Database审计日志格式https://learn.microsoft.com/en-us/azure/azure-sql/database/audit-log-format?view=azuresql
更改Azure SQL自动备份保留期和冗余选项https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-change-settings?view=azuresql
为Azure SQL LTR备份配置法定保留不可变性https://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-legal-hold?view=azuresql
为Azure SQL LTR备份配置基于时间的不可变性https://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-time-based?view=azuresql
为Azure SQL和Fabric数据库配置MAXDOPhttps://learn.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism?view=azuresql
为Azure SQL配置TLS和连接策略https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql
配置并执行Azure SQL数据库复制https://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql
配置并使用Azure SQL逻辑服务器软删除https://learn.microsoft.com/en-us/azure/azure-sql/database/deleted-logical-server-restore?view=azuresql
了解Azure SQL Database的DTU基准特性https://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
使用性能计数器监控Azure SQL分片映射https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-perf-counters?view=azuresql
了解并配置Azure SQL弹性作业https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql
使用PowerShell配置Azure SQL弹性作业https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-powershell-create?view=azuresql
使用T-SQL配置Azure SQL弹性作业https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql
创建并管理Azure SQL弹性作业https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tutorial?view=azuresql
创建并管理Azure SQL弹性池https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-manage?view=azuresql
为Azure SQL弹性池配置扩容https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql
为垂直分区数据库配置弹性查询https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical?view=azuresql
为Azure SQL Database启用区域冗余https://learn.microsoft.com/en-us/azure/azure-sql/database/enable-zone-redundancy?view=azuresql
为Azure SQL数据库配置故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-configure-sql-db?view=azuresql
为Hyperscale数据库配置自动备份https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-automated-backups-overview?view=azuresql
配置并管理Azure SQL Hyperscale命名副本https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-configure?view=azuresql
为Azure SQL Database配置内存中OLTPhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-configure?view=azuresql
配置Intelligent Insights监控以优化Azure SQL性能https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
为Azure SQL开发配置开发容器模板https://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers?view=azuresql
为Azure SQL Database配置长期备份保留https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql
为Azure SQL数据库和池配置维护窗口https://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-configure?view=azuresql
了解并使用Azure SQL维护窗口https://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window?view=azuresql
识别Azure SQL Database中的可修改设置https://learn.microsoft.com/en-us/azure/azure-sql/database/modifiable-configuration-reference?view=azuresql
Azure SQL Database监控指标和日志参考https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
使用Azure Monitor配置Azure SQL监控https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor?view=azuresql
从自动备份恢复Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql
使用Azure资源图查询Azure SQL资源https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-graph-samples?view=azuresql
通过CLI将Azure SQL数据库添加到故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-cli?view=azuresql
通过CLI为Azure SQL弹性池配置故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-cli?view=azuresql
通过CLI将Azure SQL数据库备份到存储https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/backup-database-cli?view=azuresql
通过CLI将Azure SQL数据库复制到新服务器https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-cli?view=azuresql
通过CLI创建并配置Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-cli?view=azuresql
通过PowerShell创建并配置Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-powershell?view=azuresql
通过CLI将BACPAC文件导入Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-cli?view=azuresql
通过CLI监控并扩容Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-cli?view=azuresql
通过CLI在弹性池之间移动Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-cli?view=azuresql
通过CLI从备份恢复Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-cli?view=azuresql
通过CLI扩容Azure SQL弹性池https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/scale-pool-cli?view=azuresql
通过CLI为Azure SQL配置主动异地复制https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-database-cli?view=azuresql
通过CLI配置Azure SQL故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-group-cli?view=azuresql
通过CLI为池化数据库设置异地复制https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-pool-cli?view=azuresql
通过REST配置Azure SQL数据库之间的SQL数据同步https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases-rest-api?view=azuresql
为Azure SQL无服务器计算配置自动扩容https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-auto-scaling?view=azuresql
配置Azure SQL Database无服务器设置https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-create-configure?view=azuresql
为单个Azure SQL数据库配置扩容https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-scale?view=azuresql
安装并配置Azure SQL数据同步代理https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-agent-overview?view=azuresql
设置Azure SQL数据同步组和计划https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql
为Azure SQL数据库配置维护窗口https://learn.microsoft.com/en-us/azure/azure-sql/maintenance-window-azure-sql?view=azuresql
识别Azure SQL托管实例中的可修改设置https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/modifiable-configuration-reference?view=azuresql
Azure SQL托管实例监控指标参考https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql

Integrations & Coding Patterns

集成与编码模式

TopicURL
Manage Azure SQL auditing using APIs and automationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-manage-using-api?view=azuresql
Use Entity Framework Core with Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-entity-framework-core-quickstart?view=azuresql
Connect and query Azure SQL using .NET SqlClienthttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-quickstart?view=azuresql
Query Azure SQL from Node.js using mssql packagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-javascript-mssql-quickstart?view=azuresql
Connect to Azure SQL using Python mssql-python driverhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-python-quickstart?view=azuresql
Connect to Azure SQL using Go and go-mssqldbhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-go?view=azuresql
Connect and query Azure SQL using Pythonhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
Manage Azure SQL DNS aliases with PowerShell and CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dns-alias-powershell-create?view=azuresql
Manage shard maps with Elastic Database client libraryhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management?view=azuresql
Integrate Elastic Database tools with Entity Frameworkhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-use-entity-framework-applications-visual-studio?view=azuresql
Integrate Elastic Database tools with Dapperhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-working-with-dapper?view=azuresql
Use in-memory OLTP and columnstore samples in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-sample?view=azuresql
Configure transactional replication to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql
Create Azure SQL failover group and add database via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-powershell?view=azuresql
Add Azure SQL elastic pool to failover group with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-powershell?view=azuresql
Copy Azure SQL database to new logical server via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-powershell?view=azuresql
Import BACPAC into Azure SQL database using PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-powershell?view=azuresql
Monitor and scale single Azure SQL database using PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-powershell?view=azuresql
Monitor and scale Azure SQL elastic pool with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-pool-powershell?view=azuresql
Move Azure SQL databases between elastic pools with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-powershell?view=azuresql
Restore Azure SQL database from automatic backups with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-powershell?view=azuresql
Configure Azure SQL active geo-replication with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-database-powershell?view=azuresql
Set up elastic pool geo-replication with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-elastic-pool-powershell?view=azuresql
Sync data between Azure SQL Database and SQL Server with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-azure-onprem?view=azuresql
Configure SQL Data Sync between Azure SQL databases via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases?view=azuresql
Configure and use Spark connector with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
Stream real-time data into Azure SQL using Stream Analyticshttps://learn.microsoft.com/en-us/azure/azure-sql/database/stream-data-stream-analytics-integration?view=azuresql
主题URL
使用API和自动化管理Azure SQL审计https://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-manage-using-api?view=azuresql
将Entity Framework Core与Azure SQL Database配合使用https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-entity-framework-core-quickstart?view=azuresql
使用.NET SqlClient连接并查询Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-quickstart?view=azuresql
使用mssql包从Node.js查询Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-javascript-mssql-quickstart?view=azuresql
使用Python mssql-python驱动连接到Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-python-quickstart?view=azuresql
使用Go和go-mssqldb连接到Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-go?view=azuresql
使用Python连接并查询Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
使用PowerShell和CLI管理Azure SQL DNS别名https://learn.microsoft.com/en-us/azure/azure-sql/database/dns-alias-powershell-create?view=azuresql
使用弹性数据库客户端库管理分片映射https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management?view=azuresql
将弹性数据库工具与Entity Framework集成https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-use-entity-framework-applications-visual-studio?view=azuresql
将弹性数据库工具与Dapper集成https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-working-with-dapper?view=azuresql
在Azure SQL中使用内存中OLTP和列存储示例https://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-sample?view=azuresql
配置到Azure SQL Database的事务复制https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql
通过PowerShell创建Azure SQL故障转移组并添加数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-powershell?view=azuresql
通过PowerShell将Azure SQL弹性池添加到故障转移组https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-powershell?view=azuresql
通过PowerShell将Azure SQL数据库复制到新逻辑服务器https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-powershell?view=azuresql
通过PowerShell将BACPAC导入Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-powershell?view=azuresql
通过PowerShell监控并扩容单个Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-powershell?view=azuresql
通过PowerShell监控并扩容Azure SQL弹性池https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-pool-powershell?view=azuresql
通过PowerShell在弹性池之间移动Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-powershell?view=azuresql
通过PowerShell从自动备份恢复Azure SQL数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-powershell?view=azuresql
通过PowerShell为Azure SQL配置主动异地复制https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-database-powershell?view=azuresql
通过PowerShell设置弹性池异地复制https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-elastic-pool-powershell?view=azuresql
通过PowerShell在Azure SQL Database和SQL Server之间同步数据https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-azure-onprem?view=azuresql
通过PowerShell配置Azure SQL数据库之间的SQL数据同步https://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases?view=azuresql
配置并使用Azure SQL的Spark连接器https://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
使用Stream Analytics将实时数据流式传输到Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/stream-data-stream-analytics-integration?view=azuresql

Deployment

部署

TopicURL
Deploy Azure SQL database changes with GitHub Actionshttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-github-actions-sql-db?view=azuresql
Convert Azure SQL Database to Hyperscale tierhttps://learn.microsoft.com/en-us/azure/azure-sql/database/convert-to-hyperscale?view=azuresql
Create zone-redundant Azure SQL Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-create-zone-redundant-database?view=azuresql
Manage Hyperscale elastic pools with CLI and PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-command-line?view=azuresql
Set up Azure SQL dev environment using dev containershttps://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers-quickstart?view=azuresql
Move Azure SQL databases and pools across regionshttps://learn.microsoft.com/en-us/azure/azure-sql/database/move-resources-across-regions?view=azuresql
Check Azure SQL Database feature availability by regionhttps://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
Scale Azure SQL Database and Managed Instance resourceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql
Provision Azure SQL server and database using Terraformhttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-terraform-quickstart?view=azuresql
Check Azure SQL Managed Instance feature availability by regionhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql
主题URL
使用GitHub Actions部署Azure SQL数据库变更https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-github-actions-sql-db?view=azuresql
将Azure SQL Database转换为Hyperscale层级https://learn.microsoft.com/en-us/azure/azure-sql/database/convert-to-hyperscale?view=azuresql
创建区域冗余Azure SQL Hyperscale数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-create-zone-redundant-database?view=azuresql
使用CLI和PowerShell管理Hyperscale弹性池https://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-command-line?view=azuresql
使用开发容器设置Azure SQL开发环境https://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers-quickstart?view=azuresql
跨区域移动Azure SQL数据库和池https://learn.microsoft.com/en-us/azure/azure-sql/database/move-resources-across-regions?view=azuresql
按区域检查Azure SQL Database功能可用性https://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
扩容Azure SQL Database和托管实例资源https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql
使用Terraform预配Azure SQL服务器和数据库https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-terraform-quickstart?view=azuresql
按区域检查Azure SQL托管实例功能可用性https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql