The Dedicated Administrator Connection

New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.

Your SQL Server 2005 Express Edition locks up...

SQL Server 2005 Command Line Tool "SQLCMD" – Part I

This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.

In SQL Server 2005, what does the CREATE...

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.

What does the PAD_INDEX parameter do when you...

You are examining a SQL Server 2005 system...

Overview and Installing SQL Server 2005 SP2

In this presentation Brian shows you some of the new features in SQL Server 2005 SP2. Then, he demos briefly how to install SP2 and some of the small quirks around the installation.

SQL Server 2005 Backups

If business today is data, then the entire enterprise is in the capable hands of you, the SQL Server DBA. Before you panic, check out Grant's detailed dissection of SQL 2005 backup and recovery regimes.

Which database holds the tables that Database Mail...