SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

SQL Server 2005 Deployment Guidance for Web Hosting Environments

Updated: July 2007

Writer: Alex DeNeui

Technical Reviewers: Bala Neerumalla, Rusland Ovechkin, Faith Allington, Mark Lium

SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included.

This guidance should not be used in lieu of careful planning and provisioning of SQL Server 2005.

Included in this paper:

Introduction
Server Provisioning
User Provisioning
Summary
Appendix: Provisioning Scripts

Link to the complete whitepaper is here: SQL Server 2005 Deployment Guidance for Web Hosting Environments

Published Nov 21 2007, 01:34 PM by Lindsey.allen

Filed under: Capacity, Security, Web Hosting

Comments

No Comments

About Lindsey.allen

Lindsey Allen has been working with SQL Server and Business Intelligence for the past 15+ years. She joint Microsoft Consulting Services summer of 1995 and transitioned to SQL Server Product Group summer of 2005. Lindsey is currently managing SQLCAT Best Practice and Customer Lab team.