Brian Knight
   

Brian Knight is a senior SQL Server DBA at Alltel and runs http://www.swynk.com/friends/knight. He is an MCSE and is the coauthor of Professional SQL Server 2000 DTS (WROX Press).
Email address: bknight@swynk.com
Web site: http://www.swynk.com/friends/knight

13 results found for Brian Knight, displaying items 1 - 13
October 1, 2003

Troubleshooting a Failed Installation This article is only available to subscribers. Sign up now and get instant access!

Learn tips for figuring out a failure in SQL Server installation on a Windows Server 2003 cluster.

SQL Server Magazine

October 1, 2003

Network Setup Options This article is only available to subscribers. Sign up now and get instant access!

Learn about the three network setup options you can choose from when setting up clustering for SQL Server.

SQL Server Magazine

October 2003

Clustering SQL Server This article is only available to subscribers. Sign up now and get instant access!

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 environment to provide high availability for SQL Server.

SQL Server Magazine

April 2001

DTS Grows Up This article is only available to subscribers. Sign up now and get instant access!

SQL Server 2000's Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.

SQL Server Magazine

March 2001

Configuring SQL Server 2000 Options This article is only available to subscribers. Sign up now and get instant access!

By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.

SQL Server Magazine

January 2001

Database Scanner 4.0.1 This article is only available to subscribers. Sign up now and get instant access!

Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems' security-scanning tool.

SQL Server Magazine

November 2000

SQLAudit 1.7 This article is only available to subscribers. Sign up now and get instant access!

Red Matrix Technologies' auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.

SQL Server Magazine

July 1, 2000

SQL Server 7.0 Service Pack 2 This article is only available to subscribers. Sign up now and get instant access!

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.

SQL Server Magazine

August 2000

Linked Servers This article is only available to subscribers. Sign up now and get instant access!

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 were on the local server.

SQL Server Magazine

November 1999

Reader to Reader: Undocumented Stored Procedures This article is only available to subscribers. Sign up now and get instant access!

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 stored procedure as long as it's compiled as a DLL file.

SQL Server Magazine

November 1999

Exercise This article is only available to subscribers. Sign up now and get instant access!

Creating a SQL Server Agent job

SQL Server Magazine

December 1999

Exercise This article is only available to subscribers. Sign up now and get instant access!

Auditing a table

SQL Server Magazine

December 1999

Reader to Reader: Undocumented Power This article is only available to subscribers. Sign up now and get instant access!

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 performing an action on the results.

SQL Server Magazine

Add these Headlines to your Website