This is a dedicated watch page for a single video.
SQL Server has always had configuration options that were set at the database level. For example, the recovery model has always been a database setting, but as more complex features have been introduced to the database, more options have been added. Many of these options are tied to the compatibility level of the database, which is itself a database level configuration option. Database configuration options break down into two groups, with a minor difference: Options configured by the ALTER DATABASE SCOPED CONFIGURATION syntax in T-SQL Options configured by the ALTER DATABASE syntax in T-SQL Which options are set using ALTER DATABASE ? (Select five)