SQL Server 2005

By Walter Oliver

January 28, 2008

Introduction

SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. Of the various SQL Server editions, only SQL Server Express should never be used in Shared Hosting scenarios, this edition was meant for application development environments only; see SQL Server Express and Hosting for details.

The SQL Server 2005 Deployment Guidance for Web Hosting Environments 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.

Subjects

The document covers:

  • Server Provisioning
    • Configuring Windows for Large Amounts of Memory
    • Provisioning Multiple Instances of SQL Server
    • Using the AWE API for Servers with Large Amounts of Memory
    • CLR Integration with SQL Server
    • Query Cost Governor Limits
    • Security Provisioning
    • Disabling or Renaming the Built-in sa Account
    • Server-Level Dynamic Management Views
    • Thwarting Luring Attacks
    • Deploying SQL Server Directly on the Internet
    • SQL Server Surface Area Configuration
  • User Provisioning
    • User and database provisioning (logins, users, and databases)
    • Stored procedure for creating assemblies