Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Welcome to my blog. I work as Database lead at Synaptic Digital. Hope you find some interesting stuff here.
Browse by Tags · View All
BRH 17
SQL Server 15
#SQL Server 11
#BI 10
BI 7
#SQLServer 6
SSRS 2008R2 5

Archive · View All
January 2011 6
December 2010 5
September 2012 4
May 2012 4
March 2011 4
November 2012 2
October 2012 2
January 2012 2
February 2011 2
November 2010 2

VS 2010 Database Project and Page Verify SQL setting

Aug 12 2010 4:19PM by Chintak Chhapia   

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,

Chintak Chhapia
40 · 5% · 1477


Your Comment

Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]