扩展事件 (XEvent)部分,请参阅Azure SQL 数据库和 Azure SQL 托管实例中的扩展事件是,请参阅扩展事件的差异。 扩展的存储过程否否 文件和文件组仅限主文件组是的。 文件路径是自动分配的,不能在ALTER DATABASE ADD FILE中指定文件位置。 文件流否否,请参阅SQL 托管实例功能。
Feature comparison Multi-model features Temporal tables Scale up / down Read Scale-Out Distributed transactions Scheduled maintenance Security Business continuity Monitor and tune Shared how-to's Azure SQL Database (SQL DB) Azure SQL Managed Instance (SQL MI) ...
Expand table FeatureDescription Azure portal management Yes SQL Server version/build The latest stable SQL Server database engine 1 Managed automated backups Yes Automatic software patching Yes The latest database engine features Yes Built-in instance and database monitoring and metrics Yes SQL ...
1.Azure SQL Database:This is a fully managed relational database service built on Microsoft SQL Server. It offers high availability, scalability, and security features. With Azure SQL Database, you can focus on building your applications without worrying about managing the underlying infrastructure.B...
For more information, see Azure SQL Database Business Continuity. Auditing: With Basic, Standard, and Premium service tiers, you can track logs and events that occur in a database. For more information, see Azure SQL Database Performance Guidance. Expand table Service Tier Common App Pattern ...
In-Memory OLTP in Azure SQL Database improves performance and introduces cost savings for transaction processing, data ingestion, and transient data scenarios.
Applies to:Azure SQL Database In-memory technologies in Azure SQL Database enable you to improve performance of your application, and potentially reduce cost of your database. By using in-memory technologies in Azure SQL Database, you can achieve performance improvements with various workloads. ...
Expand table New ItemDetails Accessibility Improved screen reader prompts for SQL Database Projects extension, Database Migration Assessment for Oracle extension, SQL Agent extension, and when installing a new extension Accessibility Addressed issues with install button tool tip, new connection button, ...
Here is a comparison table with a few features offered by Azure, an available GitHub demo sample and this repo, that can provide guidance when you need to decide which one to use: NameFeature or Sample?What is it?When to use? "Chat with your data" Solution Accelerator- (This repo)Azure...
Figure 4 Comparing Eager Loading to a Filtered Projection from SQL AzureIt may seem obvious that the filtered query would be faster than the eager-loaded query that returns more data. The more interesting comparison is the fact that the SQL Azure database processes the filtered projection about ...