skills/ MicrosoftDocs/Agent-Skills

azure-sql-managed-instance

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 configuring MI networking, backups/restore, geo-r

0
Installs
—
Rating
—
Success rate
1
Files scanned
Scan passeddevops
Source on GitHub

Security scan

Scan passed

No risky patterns were found in the scanned files.

1 files scannedscanner v1.2.0Oct 10, 2026

Content sha256 322fe8054bcd0a48… — run codexguild_scan_skills after installing to verify your local copy.

Static analysis is a first line of defense, not a guarantee. Read the source

SKILL.md

exact scanned copy

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

CategoryLinesDescription
TroubleshootingL37-L58Diagnosing and fixing Azure SQL Managed Instance issues: deployment/scale errors, performance, connectivity, backups, logs, memory, geo-replication, Kerberos auth, and known failures.
Best PracticesL59-L80Performance, HA/DR, and security best practices for Azure SQL Managed Instance, including monitoring, query tuning, maintenance, failover/geo-replication, migration, and app performance optimization.
Decision MakingL81-L96Guidance for choosing Azure SQL Managed Instance vs other Azure SQL options, selecting tiers and networking, and planning/migrating from SQL Server, Oracle, and Db2 with appropriate tools.
Architecture & Design PatternsL97-L101Connectivity architecture for Azure SQL DB and HA design for Managed Instance, including network topology, routing, failover behavior, and resilience patterns.
Limits & QuotasL102-L112Backup immutability, DTU benchmarks, free-tier caps, memory/OLTP limits, maintenance windows, operation durations, and all key resource/scale limits for Azure SQL Managed Instance.
SecurityL113-L167Configuring Azure SQL Managed Instance security: Entra auth and logins, Windows/Kerberos, managed identities, TDE and customer-managed keys, auditing, threat protection, TLS, networking, and Azure Policy.
ConfigurationL168-L217Configuring and managing Azure SQL Managed Instance: deployment, networking, backups/restore, maintenance windows, monitoring, alerts, auditing, failover, and performance/diagnostics settings.
Integrations & Coding PatternsL218-L242Client connectivity, data import, telemetry, automation, and HA patterns for Azure SQL Managed Instance across languages, tools, networks, DTC, MI link, backups, and tracing.
DeploymentL243-L258Deploying and managing Azure SQL Managed Instance and databases: scaling, start/stop for cost control, DR/replication, region/subnet moves, and required virtual network setup.

Troubleshooting

TopicURL
Resolve 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
Fix slow database import and export in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Troubleshoot Azure SQL performance using Intelligent Insightshttps://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?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
Monitor Azure SQL Managed Instance backup activityhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-activity-monitor?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
Monitor XTP in-memory storage and fix capacity error 41823https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-monitor-space?view=azuresql
Diagnose and fix Managed Instance link issueshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-troubleshoot-how-to?view=azuresql
Cancel Azure SQL Managed Instance operations safelyhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-cancel?view=azuresql
Diagnose Azure SQL Managed Instance performance with DMVshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-with-dmvs?view=azuresql
Use Azure Resource Health to diagnose SQL Managed Instance issueshttps://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 Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-troubleshoot?view=azuresql

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
Performance tuning guidance for Azure SQL applicationshttps://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?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 for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
Identify and resolve Azure SQL query performance issueshttps://learn.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues?view=azuresql
Set up alerts and notifications for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?view=azuresql
Run disaster recovery drills for SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-drills?view=azuresql
Implement disaster recovery for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/disaster-recovery-guidance?view=azuresql
Use failover groups for geo-replication in SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-sql-mi?view=azuresql
Manage database file space on Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/file-space-manage?view=azuresql-mi
Apply HA and DR best practices for Azure SQL Managed Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/identify-query-performance-issues?view=azuresql
Migrate to Azure SQL MI using Log Replay Servicehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate?view=azuresql
Apply best practices for Managed Instance link replicationhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-best-practices?view=azuresql
Tune Azure SQL Managed Instance performance for applicationshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/performance-guidance?view=azuresql
Apply T-SQL differences for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/transact-sql-tsql-differences-sql-server?view=azuresql
Use batching to improve Azure SQL application performancehttps://learn.microsoft.com/en-us/azure/azure-sql/performance-improve-use-batching?view=azuresql

Decision Making

TopicURL
Use Azure SQL decision tree to choose servicehttps://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
Compare Azure SQL Database and Managed Instance featureshttps://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
Configure license-free standby replica for SQL Managed Instancehttps://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 linkhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-compare-mi-link?view=azuresql
Choose between Azure SQL and SQL Server ML Serviceshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/machine-learning-services-differences?view=azuresql
Migrate SQL Server to Managed Instance using linkhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-migrate?view=azuresql
Choose vCore service tiers for SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/service-tiers-managed-instance-vcore?view=azuresql
Choose and use Next-gen General Purpose tier for Azure SQL MIhttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-determine-size?view=azuresql
Plan and execute Db2 to SQL Managed Instance migrationhttps://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 migrationhttps://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/oracle-to-managed-instance-guide?view=azuresql
Plan and decide SQL Server to Azure SQL migrationshttps://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/modernization?view=azuresql

Architecture & Design Patterns

TopicURL
Understand connectivity architecture for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?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
Understand DTU benchmark characteristics for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
Understand free-tier limits for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/free-offer?view=azuresql
Adopt In-memory OLTP and understand memory limits in SQL MIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-configure?view=azuresql
Configure and understand Azure SQL MI maintenance windowshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-faq?view=azuresql
Understand Azure SQL Managed Instance operation durationshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-duration?view=azuresql
Review Azure SQL Managed Instance resource limitshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql

Security

TopicURL
Configure Microsoft Entra authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?view=azuresql
Assign Directory Readers role for Azure SQL identitieshttps://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 identitieshttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
Configure Microsoft Entra guest access for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-guest-users?view=azuresql
Configure Microsoft Entra authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?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
Use Azure Policy to require Entra-only auth for Azure SQLhttps://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 SQLhttps://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 resourceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication-tutorial?view=azuresql
Configure Microsoft Entra-only authentication for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-only-authentication?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 in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?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
Configure Conditional Access policies for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/conditional-access-configure?view=azuresql
Configure dynamic data masking in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
Use built-in Azure Policy definitions for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
Apply security best practices to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database?view=azuresql
Use Azure Policy regulatory compliance controls for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
Configure Advanced Threat Protection for Azure SQL workloadshttps://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 customer-managed keys for Azure SQL TDEhttps://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 keyshttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
Configure customer-managed TDE with Azure Key Vaulthttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
Secure SQL Managed Instance with Microsoft Entra loginshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial?view=azuresql
Configure SQL Server Audit on Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing?view=azuresql
Create Azure SQL Managed Instance with user-assigned identityhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/authentication-azure-ad-user-assigned-managed-identity-create-managed-instance?view=azuresql
Understand internal connectivity tests for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-testing-overview?view=azuresql
Configure logins and user permissions for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/logins-create-manage?view=azuresql
Migrate SQL Server Windows users to SQL Managed Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/minimal-tls-version-configure?view=azuresql
Use native Windows principals with SQL Managed Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/private-endpoint-overview?view=azuresql
Secure public endpoints for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-overview?view=azuresql
Configure TDE with customer-managed keys using PowerShellhttps://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 CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/transparent-data-encryption-byok-sql-managed-instance-cli?view=azuresql
Secure Azure SQL Managed Instance configuration guidancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/secure-managed-instance?view=azuresql
Configure server trust groups for SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/server-trust-group-overview?view=azuresql
Configure Azure Storage service endpoint policies for Managed Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tde-certificate-migrate?view=azuresql
Configure Advanced Threat Protection for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/threat-detection-configure?view=azuresql
Configure SQL Managed Instance for Entra Windows authhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-kerberos-managed-instance?view=azuresql
Configure Windows Authentication for Entra on SQL MIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-overview?view=azuresql
Set up Entra ID Windows auth for Azure SQL MIhttps://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 MIhttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-setup?view=azuresql
Understand Kerberos-based Windows auth for SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-implementation-aad-kerberos?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

Configuration

TopicURL
Configure alerts on Azure SQL monitoring data with database watcherhttps://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
Configure Intelligent Insights performance monitoring for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
Use Intelligent Insights diagnostics logs for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log?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 metrics and diagnostic log streaming for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql
Modify Azure SQL Database configuration settings safelyhttps://learn.microsoft.com/en-us/azure/azure-sql/database/modifiable-configuration-reference?view=azuresql
Reference monitoring metrics and logs for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
Configure Azure SQL XEvent sessions with ring_bufferhttps://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-ring-buffer?view=azuresql
Configure Extended Events differences in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-db-diff-from-svr?view=azuresql
Configure maintenance windows for Azure SQL workloadshttps://learn.microsoft.com/en-us/azure/azure-sql/maintenance-window-azure-sql?view=azuresql
Configure advance maintenance notifications for SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/advance-notifications?view=azuresql
API options to create and configure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance?view=azuresql
Deploy SQL Managed Instance with ARM templateshttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/auditing-configure?view=azuresql
Change automated backup retention and redundancy for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-change-settings?view=azuresql
Understand automatic and geo-redundant backups in SQL MIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql
View backup history with backup transparency in SQL MIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/backup-transparency?view=azuresql
Configure Azure VM connectivity to SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-vm-instance-configure?view=azuresql
Configure connection types for Azure SQL Managed Instance endpointshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connection-types-overview?view=azuresql
Configure failover groups for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-configure-sql-mi?view=azuresql
Configure Azure SQL Managed Instance poolshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-pools-configure?view=azuresql
Configure zone redundancy for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-zone-redundancy-configure?view=azuresql
Configure maintenance windows for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window-configure?view=azuresql
Understand maintenance window behavior in SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/maintenance-window?view=azuresql
Prepare environment for Azure SQL Managed Instance linkhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation?view=azuresql
Monitor Azure SQL Managed Instance management operationshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/management-operations-monitor?view=azuresql
Reference modifiable settings for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/modifiable-configuration-reference?view=azuresql
Reference Azure Monitor metrics for SQL Managed Instancehttps://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 Monitorhttps://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 Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-to-site-p2s-configure?view=azuresql
Configure public endpoints for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/public-endpoint-configure?view=azuresql
Restore databases from backups on Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/recovery-using-backups?view=azuresql
Configure private domain name resolution for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resolve-private-domain-names?view=azuresql
Add SQL Managed Instance to failover group with PowerShellhttps://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 CLIhttps://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 PowerShellhttps://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-backuphttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/restore-geo-backup?view=azuresql
Enable service-aided subnet configuration for Managed Instancehttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/tempdb-configure?view=azuresql
Configure time zone behavior in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/timezones-overview?view=azuresql
Configure update policy for Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/update-policy?view=azuresql
Restart Azure SQL Managed Instance using manual failoverhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/user-initiated-failover?view=azuresql
Configure WSFC and Always On for Managed Instance linkhttps://learn.microsoft.com/en-us/previous-versions/azure/azure-sql/managed-instance/managed-instance-link-preparation-wsfc?view=azuresql

Integrations & Coding Patterns

TopicURL
Connect to Azure SQL from .NET on all OSeshttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-core?view=azuresql
Use Visual Studio .NET to query Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-dotnet-visual-studio?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 Java applications to Azure SQL with JDBChttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-java?view=azuresql
Use Node.js to connect and query Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-nodejs?view=azuresql
Use PHP to connect and query Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-php?view=azuresql
Connect and query Azure SQL using Pythonhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-query-python?view=azuresql
Query Azure SQL performance telemetry with KQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-monitoring-telemetry?view=azuresql
Configure and use Spark connector with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
Create Azure SQL XEvent sessions with event_filehttps://learn.microsoft.com/en-us/azure/azure-sql/database/xevent-code-event-file?view=azuresql
Import CSV data into Azure SQL using bcphttps://learn.microsoft.com/en-us/azure/azure-sql/load-from-csv-with-bcp?view=azuresql
Manage SQL Managed Instance at scale with Azure Automationhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automation-manage?view=azuresql
Connect applications to Azure SQL Managed Instance in various networkshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance?view=azuresql
Use Distributed Transaction Coordinator with SQL Managed Instancehttps://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 MIhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/in-memory-oltp-sample?view=azuresql
Configure Managed Instance link with scriptshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-scripts?view=azuresql
Configure Managed Instance link with SSMShttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-configure-how-to-ssms?view=azuresql
Extend Always On availability group with Managed Instance linkhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-extend-availability-group?view=azuresql
Fail over databases using Managed Instance link between SQL Server and Azure SQL Managed Instancehttps://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 2025https://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 authhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/winauth-azuread-run-trace-managed-instance?view=azuresql

Deployment

TopicURL
Export Azure SQL databases to BACPAC fileshttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql
Import BACPAC files to create Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?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
Stop and start Azure SQL Managed Instance to control costshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql
Set up disaster recovery with Managed Instance linkhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-disaster-recovery?view=azuresql
Move Azure SQL Managed Instance to another regionhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/move-resources-across-regions?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
Configure transactional replication between SQL Managed Instanceshttps://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 Serverhttps://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 deploymenthttps://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 Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-existing-add-subnet?view=azuresql
Move Azure SQL Managed Instance between subnets with minimal downtimehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/vnet-subnet-move-instance?view=azuresql

Files

1
36.1 KB

Agent reviews

0

No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.

More from MicrosoftDocs/Agent-Skills8

azure-active-directory-b2c

Expert knowledge for Azure Active Directory B2C development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building B2C user flows/custom policies, configur

Scan passed 0
azure-advisor

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when configuring Advisor alerts/digests, managing rec states, using workbooks, Resource Graph, or RBAC for access, and other Azu

Scan passed 0
azure-ai-vision

Expert knowledge for Azure AI Vision development including decision making, limits & quotas, configuration, integrations & coding patterns, and deployment. Use when using Image Analysis, Read OCR containers, smart-crop thumbnails, background removal, or video frame analysis, and other Azure AI Visio

Scan passed 0
azure-aks-edge-essentials

Expert knowledge for Azure Kubernetes Service Edge Essentials development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when managing AKS Edge/Hybrid with Arc,

Scan passed 0
azure-analysis-services

Expert knowledge for Azure Analysis Services development including troubleshooting. Use when resolving server connectivity, firewall/VNet, DNS, client connection, or network error issues, and other Azure Analysis Services related development tasks. Not for Azure Synapse Analytics (use azure-synapse-

Scan passed 0
azure-anomaly-detector

Expert knowledge for Azure AI Anomaly Detector development including troubleshooting, best practices, limits & quotas, configuration, and deployment. Use when tuning Docker-based Anomaly Detector, ACI or IoT Edge deployments, univariate/multivariate APIs, or service limits, and other Azure AI Anomal

Scan passed 0
azure-anyscale-on-azure

Expert knowledge for Azure Anyscale On Azure development including limits & quotas, security, configuration, and deployment. Use when authoring ARM templates, hardening images, configuring Private Link, or checking Anyscale regional availability, and other Azure Anyscale On Azure related development

Scan passed 0
azure-api-center

Expert knowledge for Azure Api Center development including best practices, security, configuration, integrations & coding patterns, and deployment. Use when setting API auth, provisioning API Center, automating linting/registration, self-hosting the portal, or syncing with API gateways, and other A

Scan passed 0

Related devops skillsscan passed

adapter-aws-lambda

Deploy tRPC on AWS Lambda with awsLambdaRequestHandler() from @trpc/server/adapters/aws-lambda for API Gateway v1 (REST, APIGatewayProxyEvent) and v2 (HTTP, APIGatewayProxyEventV2), and Lambda Function URLs. Enable response streaming with awsLambdaStreamingRequestHandler() wrapped in awslambda.strea

Scan passed 0
observability-and-instrumentation

Instruments code so production behavior is visible and diagnosable. Use when adding logging, metrics, tracing, or alerting. Use when shipping any feature that runs in production and you need evidence it works. Use when production issues are reported but you can't tell what happened from the availabl

Scan passed 0
deployment-patterns

Deployment workflows, CI/CD pipeline patterns, Docker containerization, health checks, rollback strategies, and production readiness checklists for web applications. Use when setting up CI/CD, containerizing an app, or checking production readiness before a release.

Scan passed 0
firebase-hosting-basics

Deploys and configures classic Firebase Hosting for static websites, single-page apps (SPAs), and microservices. Use when deploying static sites/SPAs, setting up custom domains, configuring firebase.json hosting settings (redirects, rewrites, headers, multi-site), or managing preview channels. Don't

Scan passed 0
writing-skills

Use when creating new skills, editing existing skills, or verifying skills work before deployment

Scan passed 0
waf

Configures AWS WAF to filter web traffic: creating web access control lists (web ACLs) on CloudFront, Application Load Balancers, API Gateway, and AppSync; AWS Managed Rules tuned in Count mode; rate-based rules for HTTP floods; IP set and geographic match rules; Bot Control (Common and Targeted); t

Scan passed 0