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

A New Word: Skidding

By

skidding – v. intr. the practice of making offhand comments that sound sarcastic but...

Day 2 at PASS Data Community Summit 2024

By

I missed blogging yesterday as I was on stage/backstage for quite a bit of...

PASS Summit 2024 – Wednesday

By

A common theme in the PASS Summits I've attended is community and that's definitely...

Read the latest Blogs

Forums

Step by step guide to setup PostgreSQL on Docker

By Arvind Toorpu

Comments posted to this topic are about the item Step by step guide to...

Backing up the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing up the Database Encryption...

Technology Fears

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Technology Fears

Visit the forum

Question of the Day

Backing up the Database Encryption Key

In my SQL Server 2022 database, I run this:

USE Sales;  
GO  
CREATE DATABASE ENCRYPTION KEY  
WITH ALGORITHM = AES_256  
ENCRYPTION BY SERVER CERTIFICATE MyServerCert;  
GO
This works, but I want to prepare for the future and potential issues. How do I back up my DEK?

See possible answers