Service Pack 2 for SQL Server 2000 Released
Here we go again! Microsoft has released service pack 2 this week, which is much more tame than service pack 1. Read the summary of this service pack here.
2001-12-05
11,340 reads
Brian Knight
Security Alert : SQL Server Worm Virus Attacking Systems
This past week, a worm virus began to attack SQL Servers on the internet that hold a blank password. Read some of the details about what this virus can do here.
2001-12-03
13,227 reads
Where should I save my DTS packages?
One of the common questions you see in the newsgroups is where should you save your DTS packages. This article covers the most optimal way to save your packages as well as version controlling DTS.
2001-11-15
9,781 reads
DBA Job Description: What type of DBA are you?
One of the common questions that Brian Knight sees in the newsgroups is what is a DBA officially supposed to be doing? In this article, Brian covers the many hats a DBA can and does wear.
2001-11-05
19,681 reads
Easily Create Insert Scripts with AutoInserts
One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!
2001-10-26
5,844 reads
Scrubbing Data With DTS : Part 2
Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.
2001-10-25
5,000 reads
Service Pack 2 Beta Program for SQL Server 2000 Announced
Microsoft has announced that it is now accepting applications for beta testers for the latest service pack.
2001-10-22
5,779 reads
Common SQL Server and Windows Clustering Questions and Problems
This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.
2001-10-11
13,658 reads
Update: Guide to Clustering Windows 2000 and SQL Server 2000
This is an update to a recent article that provides a step-by-step guide to clustering SQL Server 2000 and Windows 2000.
2001-10-02
513 reads
Review : Rent A Geek Book with IQReference
If your bookshelf looks like most in the technology field, you tons of tech books. This new product by IQ Destination allows you to virtually rent books.
2001-09-26
2,544 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers