Advanced options should be changed only by an experienced database professional. Reconfiguring certain options invalidates plans in the plan cache, causing new plans to be compiled. For more ...
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. For high availability ...
[!INCLUDE [sqlserver2016-asdb-asdbmi-asa-fabricsqldb](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa-fabricsqldb.md)] Use the `ALTER DATABASE SCOPED ...
You can manage and optimize [!INCLUDEssNoVersion] resources through configuration options by using [!INCLUDEssManStudioFull] or the sp_configure system stored procedure. The most commonly used server ...
SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...
If you're considering moving your on-premises SQL Server databases to the Microsoft Azure cloud, you need to decide which of the different cloud options works best for you. You might not realize it to ...