SQL Server Properties to Avoid

Most of don't create databases all that often, and it's easy to forget that we usually want to override (or verify) a few of the default settings like auto close. SQL MVP Brian Knight discusses what he considers are the most important properties to review and why they matter.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

David Branscome on 10/31/2008

1st simester but nice review. Pointing out the scripting button was nice. Thanks

Steve Duck on 1/23/2009

Keep up the great work!!!

Joe Pattison on 1/23/2009

Thanks!

James Young on 1/23/2009

I am new to sql server and your tuitorials are very helpful to me, thank you. Regards James Young

Glenn Thompson on 1/23/2009

Made me remember things I've forgot. Good job.

Leo Njampa on 1/26/2009

Good simple demo.

James Lim on 1/26/2009

I enjoyed this video and thought that the information about the auo close and shrink option being turned off was good.

meyaki on 1/30/2009

so fast to understand

Gary Wong on 2/7/2009

It was educational and nicely presented. Keep up the good work. Thanks.

Travis on 5/29/2009

Again, Brian goes the long way around the barn creating db option property policies that he does not have too.. Almost all of these policies he discussed in the video are already predefined in SQL Server. All you have you have to do is import the XML files into your SQL server from the Tools\Policies\Database Engine\1033 folder and you have them ready to go. No wasted time creating new policies that are already there.....