December 4, 2015 at 5:36 am
We currently have a small SQL Server environment that consists of 6 servers running 12 instances of SQL Server 2008 & 2005. Each servers has an instance of SQL Server 2008 and 2005 installed on them. We also have three servers for BI that run SQL Server 2012. We have no development environment, we just create development databases on production SQL Servers. When it comes to administration and maintenance of our SQL environment it has been a DBA by committee approach but now we have decided assign someone that task (me!).
We are wanting to a create new SQL Server environment that will be more robust and stable. Is there any documentation that outlines best practices for creating a SQL Server environment? Anything that outlines how you should setup development, staging, and production SQL Server environment and how to move changes from development to production?
December 4, 2015 at 8:53 am
This is a little more BI-centric but The Microsoft Data Warehouse Toolkit, 2nd Edition[/url] had a few good chapters to help get you started. There's a good amount in there about choosing the right hardware, setting up your environments (Dev, Test, Stage, Prod, etc..), disk configuration, partitioning, etc... It's geared towards SQL 2008R2 but is relevant where 2012 is concerned.
-- Itzik Ben-Gan 2001
December 7, 2015 at 3:57 am
I'm helping to write a book on data lifecycle management. You can check it out at thedlmbook.com. We're covering everything you need to set up proper processes to ensure a safe, automated, development and deployment process.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 8, 2015 at 6:47 am
Thank you...looking forward to the completion of the book.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply