I am reviewing freshly generated scripts out of SSDT publish tools. These projects were built from a default template, as were the publication profiles. They set
page_verify none for the database.
I was under some hazy impression that the best practice would be to have it set to
The only thing I can think of is that the SSDT target platform is Azure. Can someone clear this up with something authoritative?