Across our suite, we have released all sorts of new capabilities that I cannot wait for you to try out (if you haven’t already). The best way to stay up to date is with the release notes. Not including all of them, but a few to get you started. Find us on GitHub, social media...
This option is intended for indexes that are prone to last-page insert contention, which is typically seen with indexes that have a sequential key, such as an identity column, sequence, or date/time column. See CREATE INDEX. Forcing fast forward and static cursors Provides Query Store plan ...
This option is intended for indexes that are prone to last-page insert contention, which is typically seen with indexes that have a sequential key, such as an identity column, sequence, or date/time column. See CREATE INDEX. Forcing fast forward and static cursors Provides Query Store plan ...
Managed identity support for SQL Server 2022 on Azure VMStarting with SQL Server 2022 Cumulative Update 17 (CU17), managed identities are supported for SQL Server on Azure VMs (Windows only). Users can nowback up to and restore SQL Server on Azure VM databases from Azure Blob sto...
What is a GUID in SQL Server Problem Unique identifiers are one of the fundamental blocks of data modeling and well as data consumption. Every table modeling starts with a unique business key / identity key / surrogate key, etc. The impact of a unique identifier becomes more evident when ...
Managed identity support for SQL Server 2022 on Azure VM Starting with SQL Server 2022 Cumulative Update 17 (CU17), managed identities are supported for SQL Server on Azure VMs (Windows only). Users can now back up to and restore SQL Server on Azure VM databases from Azure ...
ForAzure SQL Database, a couple things landed in the security space related to auditing and TDE. Auditing can be connected to a storage account using an access key, but now you can also use a managed identity! For more information, refer to theannouncement blog. For transparent data encrypti...
Identity is “opt-in,” so there are a few packages to add: Microsoft.AspNetCore.Identity.EntityFrameworkCore– the package that enables EF Core integration A package for the database you wish to use, such asMicrosoft.EntityFrameworkCore.SqlServer(we’ll use the in-memory database for this ...
that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, which is typically seen with indexes that have a sequential key, such as an identity column, sequence, or date/time column. SeeCREATE ...
Identity is “opt-in,” so there are a few packages to add: Microsoft.AspNetCore.Identity.EntityFrameworkCore– the package that enables EF Core integration A package for the database you wish to use, such asMicrosoft.EntityFrameworkCore.SqlServer(we’ll use the in-memory database for this ...