You have accidently configured your SQL Server 2005...

Get And Set SQL Server 2005 Instance Registry Values

Most SQL Server DBAs will never need to read the registry for their instances, however in case you do find yourself needing to read or write something in SQL Server 2005, Vince Iacoboni brings us a technique for performing both of these actions.

A Junior DBA tells you that creating some...

You install a brand new SQL Server 2005...

Which operating modes in database mirroring provide automatic...

Let X be a node in a nested...

Don't Upgrade to SQL Server 2005

It's been almost three years since SQL Server 2005 was released and Steve Jones current recommendation is that you don't upgrade right now. Read on to see why he's giving this advice.

Pop Rivett and the Expanding Log

When your database transaction log is out of control, there is only one man who can tame it.

How do you convert a floating-point value from...

Monitoring Changes to your Database Schema

With the introduction of SQL Server 2005, Microsoft now allows you to write Data Definition Language (DDL) triggers to perform actions when events occur on your server. In this article, Greg Larsen discusses (examples included) some of the things that DDL triggers can be use for.