By Brian Knight, 10/01/2003
Learn tips for figuring out a failure in SQL Server installation on a Windows Server 2003 cluster.
By Brian Knight, 10/01/2003
Learn about the three network setup options you can choose from when setting up clustering for SQL Server.
By Brian Knight, 09/18/2003
Many DBAs and systems administrators are intimidated by the idea of SQL Server clustering. But by breaking the process into these six manageable steps, you can set up a clustered ...
By Brian Knight, 03/21/2001
SQL Server 2000's Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.
By Brian Knight, 02/22/2001
By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.
By Brian Knight, 12/20/2000
Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems' security-scanning tool.
By Brian Knight, 10/19/2000
Red Matrix Technologies' auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.
By Brian Knight, 07/01/2000
SQL Server 7.0 Service Pack 2 (SP2) includes more than 170 known fixes to SQL Server 7.0 and 20 fixes to OLAP Services. Here's a guide to installing SP2.
By Brian Knight, 06/16/2000
Linked servers, the core technology in SQL Server 2000 distributed partitioned views, let you use distributed queries to query a SQL Server or non-SQL Server database as if it ...
By Brian Knight, 11/01/1999
Extended stored procedures are a useful way to display information about files or your system. Any noninteractive program you can write in C or C++, you can write as an extended ...
By Brian Knight, 11/01/1999
Creating a SQL Server Agent job
By Brian Knight, 10/29/1999
Auditing a table
By Brian Knight, 10/23/1999
In SQL Server 6.5 and 7.0, Microsoft ships a set of stored procedures that let you use a one-line cursor query for querying the master database for all tables or databases and ...