Adjusting Model

In July the T-SQL Tuesday theme was defaults. There were lots of posts about various items, but I found one by Kevin Kline interesting. Kevin noted that the settings for model are not necessarily what many of us would want in production.

Is that really the case? This week I wanted to take a poll and see if many of you actually do create defaults for your new databases by changing model that are different than what Microsoft has done.

Do you change the model database?

Certainly there are some people that have create scripts with various settings for their databases. Some people prefer to customize the setup each time, based on the purpose of the database. Still others have scripts that alter the database to change settings after a someone has installed the instance.

There are any number of ways to ensure you have good settings for your production (or other) databases. Let us know this week if you have a step to change the model database when a new instance is installed.

Steve Jones

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 1.7MB) podcast or subscribe to the feed at iTunes and LibSyn.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Editorial and tagged , . Bookmark the permalink.

2 Responses to Adjusting Model

  1. I change some settings in model, and include various things like stock permissions, deleting the schemas for the in built database roles, and creating custom roles.

    However, something that I find annoying is not being able to create filegroups in model. I like to create a secondary filegroup immediately in order to segregate user data from the system tables in a db, but unfortunately you can’t do this in model.

    To get around this, I usually just create new databases using a power shell cmdlet I wrote a while back; the code for that is on my blog at http://naturalselectiondba.WordPress.com

    • way0utwest says:

      Interesting. I’ve heard the filegroup request before, and I’m not sure why MS doesn’t allow that. Lots of people want that separation. I’ve never worried about it, but I do understand why some like it.

      Thanks for the code link.

Comments are closed.