I'm trying to find some good references for best practices for planning and configuring an MS-SQL 2008 R2 server.
I'm thinking in the lines of storage configuration, file locations, recommended application or user separation, common pitfalls etc.
Sql-server – Generic best practices for SQL Server 2008 R2
sql serversql-server-2008
Related Topic
- Sql-server – SQL Server 2008 Express + Reporting Services on Windows 7
- Sql-server – Double hop problem with sql server 2008
- Sql-server – Configuring SQL Server 2008 log shipping
- Sql-server – SQL 2008 R2 automated install w/ configuration file – The credentials you provided for the SQL Server Agent service are invalid
Best Answer
http://msdn.microsoft.com/en-us/sqlserver/bb671432.aspx is worth a look.