http://www.sqlmag.com/authors/author/author/5777528/rss/5777528en-USFri, 25 May 2012 08:44:33 GMTFri, 25 May 2012 08:44:33 GMThttp://www.sqlmag.com/article/configuration/troubleshooting-a-failed-installationLearn tips for figuring out a failure in SQL Server installation on a Windows Server 2003 cluster.]]>Brian KnightWed, 01 Oct 2003 00:00:00 GMThttp://www.sqlmag.com/article/configuration/troubleshooting-a-failed-installationhttp://www.sqlmag.com/article/configuration/network-setup-optionsLearn about the three network setup options you can choose from when setting up clustering for SQL Server.]]>Brian KnightWed, 01 Oct 2003 00:00:00 GMThttp://www.sqlmag.com/article/configuration/network-setup-optionshttp://www.sqlmag.com/article/clustering/clustering-sql-serverMany 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.]]>Brian KnightThu, 18 Sep 2003 00:00:00 GMThttp://www.sqlmag.com/article/clustering/clustering-sql-serverhttp://www.sqlmag.com/article/ftp/dts-grows-upSQL Server 2000’s Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.]]>Brian KnightWed, 21 Mar 2001 00:00:00 GMThttp://www.sqlmag.com/article/ftp/dts-grows-uphttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-optionsBy eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.]]>Brian KnightThu, 22 Feb 2001 00:00:00 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-optionshttp://www.sqlmag.com/article/sql-server-70/database-scanner-4-0-1Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems’ security-scanning tool.]]>Brian KnightWed, 20 Dec 2000 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-70/database-scanner-4-0-1http://www.sqlmag.com/article/auditing/sqlaudit-1-7Red Matrix Technologies’ auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.]]>Brian KnightThu, 19 Oct 2000 00:00:00 GMThttp://www.sqlmag.com/article/auditing/sqlaudit-1-7http://www.sqlmag.com/article/sql-server-70/sql-server-7-0-service-pack-2SQL 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.]]>Brian KnightSat, 01 Jul 2000 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-70/sql-server-7-0-service-pack-2http://www.sqlmag.com/article/enterprise-manager/linked-serversLinked 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.]]>Brian KnightFri, 16 Jun 2000 10:10:02 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servershttp://www.sqlmag.com/article/stored-procedures/reader-to-reader-undocumented-stored-proceduresExtended 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.]]>Brian KnightMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/stored-procedures/reader-to-reader-undocumented-stored-procedureshttp://www.sqlmag.com/article/scalability/exerciseCreating a SQL Server Agent job]]>Brian KnightMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/scalability/exercisehttp://www.sqlmag.com/article/quering/exercise7514Auditing a table]]>Brian KnightFri, 29 Oct 1999 16:48:22 GMThttp://www.sqlmag.com/article/quering/exercise7514http://www.sqlmag.com/article/stored-procedures/reader-to-reader-undocumented-powerIn 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. ]]>Brian KnightSat, 23 Oct 1999 13:58:42 GMThttp://www.sqlmag.com/article/stored-procedures/reader-to-reader-undocumented-power