Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2009-11-19 : 20:36:19
|
| Hello All,I want to create a database standards, policies and procedures for my environment and don’t know where to start… I want to know if anyone have created or modified one and don’t mind sharing or pointing me to the right direction. Please advice. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-19 : 21:29:19
|
| It might help if you give us some background on your current environment. For example, is there any particular policy (or lack thereof) that's causing you problems? If you're starting from scratch, are you trying to avoid potential problems you've heard of or experienced elsewhere?It's difficult to advise on such things without that information. Other than really generic things like:-Establish naming conventions for objects-Establish separate environments for production, QA, development (and user testing, and pre-release flight testing, and failover, and reporting, and...)-Code deployment-Software and hardware change control-Source control-Backup schedule-Data refresh of environments (what data and how often)...any of which may not apply to your situation. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-11-19 : 22:03:49
|
| Funny that you posted thisI'm in the middle of crafting something that would outline the required steps to build a db and app in outr environment...As to what Rob mentioned, but additional things, like best practices and would like see employeedOf course, nothing is cookie cutter, but most of it is...Things get "different" when you need to worry about scale and volume of transactions, up time, maint schedules, ect...If you're not building Google, Ebay, Amazon, etc, I don't think you have to worryBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-11-19 : 23:42:39
|
| I forgot to add another generic:-Figure out security access to your production environment, limit the list to the absolute minimum number of people. Then halve it. Then eliminate any remaining management level people. |
|
|
|
|
|
|
|
|
Where to find database standards, policies and pro