Pop Rivett and the Suspect Database

Pop Rivett tackles a torn page in a suspect database.

In SQL Server 2005, what is the maximum...

SQL 2005 Maintenance Wizard Part 1

The SQL Server 2005 Maintenance Plan Wizard offers many core tasks and options for database housekeeping. In addition, the wizard will roll all of your selected tasks into a reusable and customizable package. Read on to learn more.

Can a contained in SQL Server 2005 Integration...

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...