How can you get the number of columns...

Upgrading a Database SQL 2000 to SQL 2005

Performing an upgrade to the next version of SQL Server is something more and more of us will be doing as the support for SQL Server 2000 wanes. New author Sachin Samuel brings us an overview of the process and options that you have for performing an upgrade.

The Differences Between SQL Server 2000 and 2005

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.

Starting SQL Server in Minimal Configuration

Have you ever misconfigured your SQL Server's memory and been unable to start it? That happened to new author Jay Dave, who has the Data Center edition of SQL Server 2000 with a whopping 36GB of RAM. Here's how to get your instance back up and running.

You restart your SQL Server on a Sunday...

How can you get SQL Server 2005 to...

Which query will return a list of the...

Scripting the Installation of SQL Server 2005

Having a consistent SQL Server environment is important. Gregory Larsen discusses one method of scripting your installation to ensure all of your SQL Server 2005 machines are set up the same.

Microsoft SQL 2005 Maintenance Wizard Part 3

The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.

Dynamic Management Views and Functions in SQL Server 2005

DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.