Deployment Guidance for SQL Server in Web Hosting now live

Today we published guidance for how to configure SQL Server 2005 in web hosting environments, focusing on shared hosting.

 

Published: April 2007

Applies To: SQL Server 2005 SP2

Summary: 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.

Introduction

This document provides best practices and considerations for hosting services providers who are interested in deploying Microsoft® SQL Server™ 2005 in multi-tenant environments. Although designed primarily for Web hosting, it is suitable for other forms of hosting as well.
This guidance should not be used in lieu of careful planning and provisioning of SQL Server 2005.

 You can find full documentation at here. https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/SQL2005DGWHE.mspx

 Thanks.