SQL Server Administration

The following articles are designed to help you administer SQL Server:

Understanding SQL Server backup types

Database backups are at the core of any SQL Server disaster recovery planning for any production system. Microsoft® SQL Server® provides several kinds of backups that may be combined to formulate a customized disaster recovery plan depending on the nature of the data and the recovery requirements. Read more…

Microsoft released SQL Server 2005 SP2 CTP

Microsoft released SQL Server SP2 Community Technology Preview (CTP) this month to address a number of known issues and provide some enhancements to the database engine. Remember that this service pack is still a CTP and is not intended for use in production. Read more…

Longhorn, Vista to drop SQL Server 2000 and MSDE support

In a surprise move, Microsoft announced that the soon-to-be released Microsoft Windows Vista operating system and Microsoft Windows Server “Longhorn” will not support earlier versions of SQL Server, including SQL Server 2000 (all editions including MSDE), SQL Server 7.0, and SQL Server 6.5. Read more…

More Articles

How many rows does your largest SQL Server table contain?

How big is your database log file?

Compare SQL Server 2005 Editions

Verify foreign key integrity

Reclaim space for dropped columns

Monitor SQL Server disk space usage

Limit SQL Server memory usage

List available SQL Server instances on the network

Determine SQL Server table size

View SQL Server Agent job history

Automate archival of daily SQL Server backups

Resolve error “SQL Server does not exist or access denied”

Resolve error “Specified SQL Server not found”

What is SQL Server Utility?

SQL query analyzer tool

Resolve error “Not associated with a trusted SQL Server connection”

SQL Server Client Network Utility

MDAC explained (ADO version 2.5, 2.6, 2.7, and 2.8)