What kind of structures are supported for an Azure SQL DB?

What is not supported in Azure SQL Database?

SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Polybase are not supported by both Azure SQL Database and SQL MI.

Which features does the Azure SQL Database Service Support?

Azure SQL Database service provides a built-in intelligence which learns database patterns. Such telemetry information informs business management of adaptation options of database resources for constant performance tuning coupled with best business decisions.

Which of the following T SQL features is supported in SQL Azure?

Yes. You can export data from external storage (Azure data lake, Dataverse, Cosmos DB) into Azure data lake using CETAS. Yes, all Transact-SQL types are supported, except cursor, hierarchyid, ntext, text, and image, rowversion, Spatial Types, sql_variant, xml, and Table type.

Does SQL Azure support all features in SQL Server?

SQL Server on Azure VM: It supports all the SQL Server on-premises capabilities. Azure SQL Database: Database size is always depends on the underlying service tiers (e.g. Basic, Business Critical, Hyperscale). It supports databases of up to 100 TB with Hyperscale service tier model.