While restoring your SQL Server 2005 database's transaction...

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.

Upgrading to SQL Server 2005: A dozen must-have tips

We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.

You have just purchased a brand new 64-bit...

Setting Up Delegation for Linked Servers

Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.

Finding Column Dependencies

Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.

Getting SQLAgent to Respond Faster

One limitation of SQLAgent is that granularity to which you can schedule jobs: every minute. Sometimes there are things that you would like to happen more frequently, like alerting. Johan Bijnens brings us a technique for getting your SQL Agent to respond to alerts in as little as every 10 seconds.

You have just purchased a brand new 32-bit...

Avoiding Microsoft SQL Server 2005 deployment pitfalls

This tutorial shows you how to properly install Microsoft's SQL Server 2005, avoiding the pitfalls of an unsuccessful deployment.

Where can you see the actual SQL code...