🛠️ 開発・MCP コミュニティ

azure-sql-managed-instance

Azure SQL Managed Instanceの設計、開発、トラブルシューティング、セキュリティ対策、他サービス連携に関する専門知識を提供し、最適な構成を支援するSkill。

📜 元の英語説明(参考)

Expert knowledge for Azure SQL Managed Instance development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when planning MI vs SQL choices, configuring networking/HA, tuning performance, securing access, or integrating apps/tools, and other Azure SQL Managed Instance related development tasks. Not for Azure SQL Database (use azure-sql-database), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Database for MySQL (use azure-database-mysql), Azure Database for PostgreSQL (use azure-database-postgresql).

🇯🇵 日本人クリエイター向け解説

一言でいうと

※ jpskill.com 編集部が日本のビジネス現場向けに補足した解説です。Skill本体の挙動とは独立した参考情報です。

⬇ このSkillをダウンロード(.skill) 元のソースを見る ↗

⚠️ ダウンロード・利用は自己責任でお願いします。当サイトは内容・動作・安全性について責任を負いません。

🎯 このSkillでできること

下記の説明文を読むと、このSkillがあなたに何をしてくれるかが分かります。Claudeにこの分野の依頼をすると、自動で発動します。

📦 インストール方法 (3ステップ)

1. 上の「ダウンロード」ボタンを押して .skill ファイルを取得
2. ファイル名の拡張子を .skill から .zip に変えて展開(macは自動展開可)
3. 展開してできたフォルダを、ホームフォルダの .claude/skills/ に置く
- · macOS / Linux: ~/.claude/skills/
- · Windows: %USERPROFILE%\.claude\skills\

Claude Code を再起動すれば完了。「このSkillを使って…」と話しかけなくても、関連する依頼で自動的に呼び出されます。

詳しい使い方ガイドを見る →

最終更新: 2026-05-17
取得日時: 2026-05-17
同梱ファイル: 1

📖 Skill本文(日本語訳)

※ 原文(英語/中国語)を Gemini で日本語化したものです。Claude 自身は原文を読みます。誤訳がある場合は原文をご確認ください。

Azure SQL Managed Instance スキル

このスキルは、Azure SQL Managed Instance に関する専門的なガイダンスを提供します。トラブルシューティング、ベストプラクティス、意思決定、アーキテクチャと設計パターン、制限とクォータ、セキュリティ、構成、統合とコーディングパターン、デプロイメントを網羅しています。ローカルのクイックリファレンスコンテンツとリモートドキュメント取得機能を組み合わせています。

このスキルの使い方

Agent への重要事項: 以下のカテゴリインデックスを使用して、関連するセクションを見つけてください。行範囲が指定されているカテゴリ (例: L35-L120) の場合は、指定された行で read_file を使用してください。ファイルリンクが指定されているカテゴリ (例: [security.md](security.md)) の場合は、リンクされた参照ファイルで read_file を使用してください。

Agent への重要事項: metadata.generated_at が 3 か月以上前の場合、ユーザーにリポジトリから最新バージョンをプルするよう提案してください。mcp_microsoftdocs ツールが利用できない場合、ユーザーにインストールするよう提案してください: インストールガイド

このスキルは、ドキュメントコンテンツを取得するためにネットワークアクセスを必要とします。

推奨: クエリ文字列 from=learn-agent-skill を指定して mcp_microsoftdocs:microsoft_docs_fetch を使用してください。Markdown を返します。
フォールバック: クエリ文字列 from=learn-agent-skill&accept=text/markdown を指定して fetch_webpage を使用してください。Markdown を返します。

カテゴリインデックス

カテゴリ	行	説明
トラブルシューティング	L37-L54	Azure SQL Managed Instance の問題 (パフォーマンス、接続、容量、geo レプリケーション、メモリ、トランザクションログの満杯、XTP ストレージ、デプロイメント、Entra Kerberos 認証) の診断と修正。
ベストプラクティス	L55-L76	Azure SQL Managed Instance のパフォーマンス、監視、信頼性に関するベストプラクティス: クエリ/アプリのチューニング、DMV/KQL による監視、アラート、HA/DR、フェールオーバー、読み取りスケールアウト、移行ガイダンス。
意思決定	L77-L90	Azure SQL Managed Instance と他の Azure SQL オプション、ティア、プール、ネットワーク、HA/DR オプション、ML の違い、Db2/Oracle 移行計画の選択に関するガイダンス。
アーキテクチャと設計パターン	L91-L95	Azure SQL Database の接続アーキテクチャ、ネットワークモデル、接続オプション (ゲートウェイ、エンドポイント、ファイアウォール、VNet とプライベートアクセスとの統合を含む)。
制限とクォータ	L96-L105	Azure SQL Managed Instance の制限、クォータ、容量: DTU、無料ティアの制限、メモリ/OLTP の制限、監視動作、リソース上限、クォータ増加の要求方法。
セキュリティ	L106-L160	Azure SQL Managed Instance および関連する Azure SQL リソースを保護するための認証、暗号化、ネットワーク、監査、ポリシーベースの保護の構成。
構成	L161-L211	SQL Managed Instance の構成と操作: デプロイメントとネットワーク、バックアップ/復元と保持、メンテナンスと更新、監視/アラート、監査、SQL Server との機能動作の違い。
統合とコーディングパターン	L212-L235	SQL Managed Instance へのアプリとツールの接続 (.NET、Java、Python など)、自動化、データインポート、DTC、XEvents、MI Link、バックアップ、トレース、Spark 統合。
デプロイメント	L236-L256	Azure SQL Managed Instance のデプロイ、スケーリング、移動、一時停止。ネットワーク設定、リージョン可用性、DR/レプリケーション、移行、BACPAC のインポート/エクスポート。

トラブルシューティング

トピック	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/database-import-export-hang?view=azuresql
Intelligent Insights を使用した Azure SQL パフォーマンスのトラブルシューティング	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?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 での geo レプリケーションと redo ラグのトラブルシューティング	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 Managed Instance の既知の問題の解決	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
XTP インメモリストレージの監視と容量エラー 41823 の修正	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-monitor-space?view=azuresql
Azure SQL Managed Instance リンクの問題のトラブルシューティング	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-troubleshoot-how-to?view=azuresql
Azure Resource Health を使用した SQL Managed Instance の問題の診断	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-health-to-troubleshoot-connectivity?view=azuresql
Azure SQL Managed Instance でのトランザクションログ満杯エラーの解決	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi
SQL Managed Instance の Entra Kerberos Windows 認証のトラブルシューティング	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql

ベストプラクティス

トピック	URL
KQL と T-SQL を使用した Azure SQL 監視データの分析	https://learn.microsoft.com/en-us

📜 原文 SKILL.md(Claudeが読む英語/中国語)を展開

Azure SQL Managed Instance Skill

This skill provides expert guidance for Azure SQL Managed Instance. 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.

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.

Category Index

Category	Lines	Description
Troubleshooting	L37-L54	Diagnosing and fixing Azure SQL Managed Instance issues: performance, connectivity, capacity, geo‑replication, memory, transaction log full, XTP storage, deployment, and Entra Kerberos auth.
Best Practices	L55-L76	Performance, monitoring, and reliability best practices for Azure SQL Managed Instance: tuning queries/apps, monitoring with DMVs/KQL, alerts, HA/DR, failover, read scale-out, and migration guidance.
Decision Making	L77-L90	Guidance for choosing Azure SQL Managed Instance vs other Azure SQL options, tiers, pools, networking, HA/DR options, ML differences, and planning Db2/Oracle migrations.
Architecture & Design Patterns	L91-L95	Connectivity architecture, networking models, and connection options for Azure SQL Database, including gateways, endpoints, firewalls, and integration with VNets and private access.
Limits & Quotas	L96-L105	Limits, quotas, and capacity for Azure SQL Managed Instance: DTUs, free-tier caps, memory/OLTP limits, monitoring behavior, resource ceilings, and how to request quota increases.
Security	L106-L160	Configuring authentication, encryption, network, auditing, and policy-based protections for securing Azure SQL Managed Instance and related Azure SQL resources.
Configuration	L161-L211	Configuring and operating SQL Managed Instance: deployment and networking, backup/restore and retention, maintenance and updates, monitoring/alerts, auditing, and feature behaviors vs SQL Server.
Integrations & Coding Patterns	L212-L235	Connecting apps and tools to SQL Managed Instance (.NET, Java, Python, etc.), automation, data import, DTC, XEvents, MI Link, backups, tracing, and Spark integration.
Deployment	L236-L256	Deploying, scaling, moving, and pausing Azure SQL Managed Instance; networking setup, regional availability, DR/replication, migrations, and BACPAC import/export.

Troubleshooting

Topic	URL
Resolve Azure SQL capacity deployment and scaling errors	https://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
Fix slow database import and export in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Troubleshoot Azure SQL performance using Intelligent Insights	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?view=azuresql
Troubleshoot transient connectivity errors for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
Troubleshoot Azure SQL and Fabric SQL connectivity errors	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
Troubleshoot geo-replication and redo lag in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
Investigate and fix memory issues in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
Resolve transaction log full errors in Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
Resolve known issues in Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
Monitor XTP in-memory storage and fix capacity error 41823	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-monitor-space?view=azuresql
Troubleshoot Azure SQL Managed Instance link issues	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-troubleshoot-how-to?view=azuresql
Use Azure Resource Health to diagnose SQL Managed Instance issues	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-health-to-troubleshoot-connectivity?view=azuresql
Resolve transaction log full errors in Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi
Troubleshoot Entra Kerberos Windows auth for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql

Best Practices

Topic	URL
Analyze Azure SQL monitoring data with KQL and T-SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Application development considerations for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/develop-overview?view=azuresql
Performance tuning guidance for Azure SQL applications	https://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?view=azuresql
Plan for Azure SQL planned maintenance events	https://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
Configure and use read scale-out replicas in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
Identify and resolve Azure SQL query performance issues	https://learn.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues?view=azuresql
Set up alerts and notifications for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?view=azuresql
Run disaster recovery drills for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-drills?view=azuresql
Design Azure SQL Managed Instance disaster recovery	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-guidance?view=azuresql
Use failover groups for geo-replication in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql
Manage database file space on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/file-space-manage?view=azuresql-mi
High availability and disaster recovery checklist for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/high-availability-disaster-recovery-checklist?view=azuresql
Identify and resolve query bottlenecks on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/identify-query-performance-issues?view=azuresql
Migrate to Azure SQL MI using Log Replay Service	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql
Apply best practices for Managed Instance link replication	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-best-practices?view=azuresql
Monitor Azure SQL Managed Instance performance using DMVs	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-with-dmvs?view=azuresql
Tune Azure SQL Managed Instance performance for applications	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/performance-guidance?view=azuresql
Use batching to improve Azure SQL application performance	https://learn.microsoft.com/en-us/azure/azure-sql/performance-improve-use-batching?view=azuresql

Decision Making

Topic	URL
Use Azure SQL decision tree to choose service	https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
Compare Azure SQL Database vs Managed Instance features	https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
Configure license-free standby replica for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-standby-replica-how-to-configure?view=azuresql
Choose between Log Replay Service and Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-compare-mi-link?view=azuresql
Compare ML Services in SQL Managed Instance vs SQL Server	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/machine-learning-services-differences?view=azuresql
Choose vCore service tiers for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-managed-instance-vcore?view=azuresql
Adopt Next-gen General Purpose tier for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-next-gen-general-purpose-use?view=azuresql
Determine subnet size and IP range for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-determine-size?view=azuresql
Plan and execute Db2 to SQL Managed Instance migration	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/db2-to-managed-instance-guide?view=azuresql
Plan Oracle to Azure SQL Managed Instance migration	https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/oracle-to-managed-instance-guide?view=azuresql

Architecture & Design Patterns

Topic	URL
Understand connectivity architecture for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql

Limits & Quotas

Topic	URL
Review database watcher FAQ for Azure SQL monitoring behavior	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
Understand DTU benchmark characteristics for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
Request quota increases for Azure SQL resources	https://learn.microsoft.com/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql
Understand free-tier limits for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/free-offer?view=azuresql
Adopt In-memory OLTP and understand memory limits in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-configure?view=azuresql
Review Azure SQL Managed Instance resource limits	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

Security

Topic	URL
Configure Microsoft Entra authentication for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
Assign Directory Readers role for Azure SQL identities	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role-tutorial?view=azuresql
Configure Directory Readers and permissions for Azure SQL identities	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
Create and use Microsoft Entra guest admins for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-guest-users?view=azuresql
Use Microsoft Entra authentication with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
Use Entra service principals with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal?view=azuresql
Create and use Microsoft Entra logins in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins-tutorial?view=azuresql
Use Microsoft Entra server principals in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-logins?view=azuresql
Create Azure SQL server with Entra-only authentication	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-create-server?view=azuresql
Use Azure Policy to require Entra-only auth for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy-how-to?view=azuresql
Enforce Entra-only authentication with Azure Policy for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-policy?view=azuresql
Enable Entra-only authentication on existing Azure SQL resources	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-tutorial?view=azuresql
Enable Microsoft Entra-only authentication for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication?view=azuresql
Configure managed identities for Azure SQL access	https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity?view=azuresql
Configure Microsoft Entra authentication for Azure SQL	https://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 in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql
Block T-SQL CRUD for Azure SQL resource protection	https://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
Configure Conditional Access policies for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/conditional-access-configure?view=azuresql
Classify and label sensitive data in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
Configure dynamic data masking in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
Configure logins and users for Azure SQL access control	https://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
Use built-in Azure Policy definitions for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
Apply Azure SQL security best practices for common requirements	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
Use Azure Policy regulatory compliance controls for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
Configure Advanced Threat Protection for Azure SQL workloads	https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql
Enable Azure SQL TDE with Key Vault BYOK	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-configure?view=azuresql
Configure cross-tenant customer-managed keys for Azure SQL TDE	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
Use user-assigned managed identities for TDE customer-managed keys	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
Configure customer-managed TDE with Azure Key Vault	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
Enable and manage transparent data encryption in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql
Secure SQL Managed Instance with Microsoft Entra logins	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial?view=azuresql
Configure SQL Server Audit on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing?view=azuresql
Create Azure SQL Managed Instance with user-assigned identity	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/authentication-azure-ad-user-assigned-managed-identity-create-managed-instance?view=azuresql
Migrate SQL Server Windows users to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/migrate-sql-server-users-to-instance-transact-sql-tsql-tutorial?view=azuresql
Configure minimum TLS version for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/minimal-tls-version-configure?view=azuresql
Use native Windows principals with SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql
Set up Private Link and private endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/private-endpoint-overview?view=azuresql
Secure public endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-overview?view=azuresql
Configure TDE with customer-managed keys using PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-powershell?view=azuresql
Enable TDE with customer-managed keys using CLI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-sql-managed-instance-cli?view=azuresql
Apply security best practices to Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/secure-managed-instance?view=azuresql
Configure server trust groups for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/server-trust-group-overview?view=azuresql
Configure Azure Storage service endpoint policies for Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-endpoint-policies-configure?view=azuresql
Migrate TDE certificates from SQL Server to Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tde-certificate-migrate?view=azuresql
Configure Advanced Threat Protection for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/threat-detection-configure?view=azuresql
Configure SQL Managed Instance for Entra Windows auth	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-instance?view=azuresql
Set up Entra ID Windows auth for Azure SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-incoming-trust-based-flow?view=azuresql
Configure modern interactive Windows auth flow for SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup-modern-interactive-flow?view=azuresql
Set up Windows Authentication for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql
Understand Kerberos-based Windows auth for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-implementation-aad-kerberos?view=azuresql
Prepare for Azure SQL TLS root certificate rotation	https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql

Configuration

Topic	URL
Configure alerts on Azure SQL monitoring data with database watcher	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
Understand database watcher datasets and collected metrics	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
Create and configure database watcher for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
Monitor Azure SQL workloads using database watcher	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-overview?view=azuresql
Create a database watcher with Entra auth and private connectivity	https://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-quickstart?view=azuresql
Configure Intelligent Insights performance monitoring for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
Use Intelligent Insights diagnostics logs for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log?view=azuresql
Configure long-term backup retention for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql
Configure metrics and diagnostic log streaming for Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql
Reference monitoring metrics and logs for Azure SQL Database	https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
Configure temporal table retention in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/temporal-tables-retention-policy?view=azuresql
Configure Azure SQL XEvent sessions with ring_buffer	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-ring-buffer?view=azuresql
Configure Extended Events differences in Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-db-diff-from-svr?view=azuresql
Configure advance maintenance notifications for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/advance-notifications?view=azuresql
API options to create and configure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance?view=azuresql
Deploy SQL Managed Instance with ARM templates	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/arm-templates-content-guide?view=azuresql
T-SQL configuration of auditing for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql
Change automated backup retention and redundancy for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-change-settings?view=azuresql
Understand automatic and geo-redundant backups in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql
Monitor Azure SQL Managed Instance backup activity using msdb and XEvents	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-activity-monitor?view=azuresql
View backup history with backup transparency in SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-transparency?view=azuresql
Configure Azure VM connectivity to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-vm-instance-configure?view=azuresql
Configure connection types for Azure SQL Managed Instance endpoints	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connection-types-overview?view=azuresql
Configure failover groups for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-configure-sql-mi?view=azuresql
Configure maintenance windows for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-configure?view=azuresql
Maintenance window FAQ for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-faq?view=azuresql
Understand maintenance window behavior in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window?view=azuresql
Prepare WSFC environment for Managed Instance link with Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation-wsfc?view=azuresql
Prepare environment for Managed Instance link replication	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation?view=azuresql
Monitor Azure SQL Managed Instance management operations	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-monitor?view=azuresql
Reference monitoring metrics and logs for SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql
Configure monitoring for Azure SQL Managed Instance with Azure Monitor	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor?view=azuresql
Perform point-in-time database restores on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql
Set up point-to-site connectivity to SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?view=azuresql
Configure public endpoints for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure?view=azuresql
Restore databases from backups on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql
Configure private domain name resolution for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resolve-private-domain-names?view=azuresql
Add SQL Managed Instance to failover group with PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/add-to-failover-group-powershell?view=azuresql
Create and network-configure SQL Managed Instance with CLI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-cli?view=azuresql
Create and network-configure SQL Managed Instance with PowerShell	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-powershell?view=azuresql
Restore Azure SQL Managed Instance database from geo-backup	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/restore-geo-backup?view=azuresql
Enable service-aided subnet configuration for Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/subnet-service-aided-configuration-enable?view=azuresql
Configure tempdb files and growth on Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tempdb-configure?view=azuresql
Configure time zone behavior for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/timezones-overview?view=azuresql
Handle T-SQL differences between SQL Server and SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
Configure update policy for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql
Restart Azure SQL Managed Instance using manual failover	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/user-initiated-failover?view=azuresql

Integrations & Coding Patterns

Topic	URL
Connect to Azure SQL from .NET on all OSes	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-core?view=azuresql
Use Visual Studio .NET to query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-visual-studio?view=azuresql
Connect to Azure SQL using Go and go-mssqldb	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-go?view=azuresql
Connect Java applications to Azure SQL with JDBC	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql
Use Node.js to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-nodejs?view=azuresql
Use PHP to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-php?view=azuresql
Connect and query Azure SQL using Python	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
Use Ruby to connect and query Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-ruby?view=azuresql
Configure and use Spark connector with Azure SQL	https://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
Create Azure SQL XEvent sessions with event_file	https://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file?view=azuresql
Import CSV data into Azure SQL using bcp	https://learn.microsoft.com/en-us/azure/azure-sql/load-from-csv-with-bcp?view=azuresql
Manage SQL Managed Instance at scale with Azure Automation	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automation-manage?view=azuresql
Connect applications to Azure SQL Managed Instance in various networks	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance?view=azuresql
Use Distributed Transaction Coordinator with SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/distributed-transaction-coordinator-dtc?view=azuresql
Use in-memory OLTP and columnstore samples on SQL MI	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-sample?view=azuresql
Automate jobs with SQL Server Agent on SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql
Configure Managed Instance link using T-SQL and Azure scripts	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql
Fail over databases using Managed Instance link between SQL Server and Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-failover-how-to?view=azuresql
Restore Azure SQL Managed Instance backups to SQL Server 2022 or 2025	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-database-to-sql-server?view=azuresql
Run traces on SQL Managed Instance using Windows auth	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-run-trace-managed-instance?view=azuresql

Deployment

Topic	URL
Export Azure SQL databases to BACPAC files	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql
Import BACPAC files to create Azure SQL databases	https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql
Check Azure SQL Database feature availability by region	https://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
Scale Azure SQL Database and Managed Instance resources	https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql
Deploy Azure SQL Managed Instance using Bicep	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-bicep-quickstart?view=azuresql
Deploy Azure SQL Managed Instance via ARM template	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?view=azuresql
Provision Azure SQL Managed Instance with Terraform	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-create-terraform?view=azuresql
Stop and start Azure SQL Managed Instance to control costs	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql
Configure disaster recovery to Azure SQL Managed Instance using Managed Instance link	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-disaster-recovery?view=azuresql
Cancel Azure SQL Managed Instance management operations	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-cancel?view=azuresql
Understand duration of management operations in SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-duration?view=azuresql
Move Azure SQL Managed Instance to another region	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/move-resources-across-regions?view=azuresql
Check Azure SQL Managed Instance feature availability by region	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql
Configure transactional replication between SQL Managed Instances	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-between-two-instances-configure-tutorial?view=azuresql
Set up replication between SQL Managed Instance and SQL Server	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql
Create a virtual network for Azure SQL Managed Instance deployment	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/virtual-network-subnet-create-arm-template?view=azuresql
Configure existing virtual networks for Azure SQL Managed Instance	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-existing-add-subnet?view=azuresql
Move Azure SQL Managed Instance to another subnet with minimal downtime	https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-move-instance?view=azuresql