Brian Knight


Brian Knight is a SQL Server MVP and is the founder and owner of Pragmatic Works. He's a contributing columnist for several technical magazines and has written more than 15 SQL Server books.

Troubleshooting a Failed Installation
Learn tips for figuring out a failure in SQL Server installation on a Windows Server 2003 cluster.
Network Setup Options
Learn about the three network setup options you can choose from when setting up clustering for SQL Server.
Clustering SQL Server 3
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.
DTS Grows Up 3
SQL Server 2000's Data Transformation Services is full of new and improved tasks that make transforming your data faster and easier than ever.
Configuring SQL Server 2000 Options 5
By eliminating some options and revamping others, Microsoft helps you to better configure SQL Server.
Database Scanner 4.0.1
Lock down your SQL Server 7.0 and 6.x systems with Internet Security Systems' security-scanning tool.
SQLAudit 1.7 1
Red Matrix Technologies' auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.
SQL Server 7.0 Service Pack 2 1
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.
Linked Servers 9
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.
Reader to Reader: Undocumented Stored Procedures
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.
Exercise - 01 Nov 1999
Creating a SQL Server Agent job
Exercise - 29 Oct 1999
Auditing a table
Reader to Reader: Undocumented Power
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.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.


From the Blogs
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×