Azure SQL AI Features icon

Azure SQL AI Features

Azure SQL Database provides AI-powered features for performance optimization and development assistance.

Visit Website Database Platform
Azure SQL AI Copilot Azure SQL intelligent database Azure automatic tuning Query Performance Insight

Azure SQL Database provides AI-powered features for performance optimization and development assistance. Copilot in Azure SQL Database (preview) offers natural language to T-SQL conversion, performance insights in plain English, and troubleshooting assistance—currently at no additional cost during preview. Automatic Tuning uses ML to identify and apply query performance improvements: automatic plan correction (reverting regression), automatic index management (create/drop recommendations), and automatic statistics updates. Query Performance Insight surfaces top resource-consuming queries with recommendations. Intelligent Query Processing (IQP) includes adaptive query processing, memory grant feedback, batch/row mode optimizations, and table variable deferred compilation. GitHub Copilot integration (MSSQL Extension v1.37+ for VS Code) provides schema-aware AI assistance with /connect, /runQuery, and /showSchema commands. Page should cover: Copilot preview enrollment and capabilities, Automatic Tuning configuration, Query Performance Insight interpretation, Intelligent Query Processing features by SQL Server version, GitHub Copilot MSSQL setup, comparison with SQL Server on-premises, and Azure-specific AI features roadmap.