mahmadiworks

Hi there,

That’s a great question, and one that comes up quite often as organizations continue moving workloads to the cloud. While SQL Azure (Azure SQL Database) already supports a wide range of SQL Server features, not every on-prem capability is available yet. Microsoft continuously updates the service, and new features are rolled out regularly based on customer demand and compatibility testing.

If you’re looking for a roadmap, the best place to track upcoming and recently added features is the official Azure SQL Database updates page. It provides detailed notes on what’s in preview, what’s generally available, and which SQL Server functionalities are planned for future integration.

From an architectural point of view, it’s worth noting that Azure SQL is designed as a PaaS (Platform as a Service) offering, so certain features that rely on OS-level access or server configuration may never be implemented exactly as they exist on traditional SQL Server. However, Microsoft often introduces cloud-native alternatives that provide similar or even improved capabilities.

I’ve been studying for the AZ-305 exam (Microsoft Certified: Azure Solutions Architect Expert), and this topic is actually part of the exam’s focus, understanding how to design data solutions that take advantage of Azure services while adapting to differences between PaaS and on-prem environments. Preparing for it really helped me understand when to use Azure SQL Database, SQL Managed Instance, or SQL Server on an Azure VM, depending on compatibility and scalability needs.

So, while there isn’t always a fixed public roadmap for every feature, staying tuned to Microsoft’s official documentation and Azure updates is the best way to know when new SQL Azure support is added.