SQL Server 2005

Technical Article

SQL Server 2005 Deployment Guidance for Web Hosting Environments

  • Article

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.

2008-01-11

1,576 reads

Technical Article

Predeployment I/O Best Practices

  • Article

The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system, it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server. This white paper discusses validating and determining the capacity of an I/O subsystem. A number of tools are available for performing this type of testing. This white paper focuses on the SQLIO.exe tool, but also compares all available tools. It also covers basic I/O configuration best practices for SQL Server 2005.

2008-01-04

3,111 reads

External Article

Introduction to SQL Server 2005 Database Backups

  • Article

Backing up a database is one of the most important things you need to do when having a database driven application. It 's only all of your data in there, right? But often developers and management don't realize the importance of backups and overall proper backup strategy for the most important side of the business – data and it's consistency.

2008-01-03

4,487 reads

Blogs

Grinding Away: Mary Spender

By

A few years ago I stumbled on this video and loved it. That led...

PASS Summit 2024 – A new experience

By

I attended the PASS Data Community Summit held in Seattle in person this year...

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

Read the latest Blogs

Forums

How do I fix the, "Unable to process the existing user settings" error message?

By Rod at work

I'm sure I've asked this question in either this forum, or another one, in...

Cannot restore new DB

By Edvard Korsbæk

I have made an empty DB called "HJEM_BB" I try to fill it from...

How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server

By Noman072

Comments posted to this topic are about the item How to Avoid Incorrect Results...

Visit the forum

Question of the Day

The AG Secondary Logs

What happens when an AG secondary receives a log record from the primary?

See possible answers