Database project is very good tool for supporting Agile development. More benefits of using this project are listed here and here.
When we create a new database using SSMS, by default Page Verify Option for database is set to CHECKSUM, which is a recommended option and it helps detecting corruption. This setting is used to discover and report incomplete I/O transactions caused by disk I/O errors. You can find more details on page verify option here. Using below query we can find this setting for all the databases.
select page_verify_option,page_verify_option_desc,* from sys.databases
But, when you create new database project, by default Page Verify option is selected to None. This can be easily carried forward to Test and Production environment if this has not been taken care of. There are other options which can be set also. It is recommended that, we create a custom SQLSettings file for each environment. In that setting we need to change this option to CHECKSUM.
Also, these settings are not getting changed even after importing a database from current online database.
Tags: #DBA, BRH, Database Project, Database Project Settings, SQLServer, DBA,