If you want to apply a hot fix...

Twiddling the knobs: The Default Backup directory

What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.

What is the timestamp datatype used for?

SQL Server 2005 Security Best Practices - Operational and Administrati

his white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.

You want to ensure that your junior DBA...

You have just upgraded your server from a...

Black Belt Administration: Performance Dashboard for Microsoft SQL Ser

Diagnose performance problems in MSSQL Server 2005 with a powerful new administration tool. BI Architect Bill Pearson provides hands-on guidance in installing and using this powerful new dashboard / report pack, freely available to MSSQL Server 2005 users everywhere.

How To Video: Creating a Proxy Account

In this session by Brian Knight, he shows you how to create a proxy account for SQL Server Agent to use. Proxy accounts and SQL Server 2005 credentials help you impersonate another Windows account in Agent.

Which index rebuild operation in SQL Server 2005...

What is the maximum number of instances of...