Free SQL Server 2000 Certifications
Certy.com has just released SQL Server 2000 certifications. These certifications are 100% free and a must for any DB developer & DBA.
2002-07-30
75 reads
Articles
Relational Database Without Relations
The strength and holy grail of relational databases lies in the very name: relations. Microsoft has put a good deal of intelligence and cunning into query optimizations, caching, indexing and execution plans to make the process of finding related records even smoother and faster. This small article, however, will try to shatter the very sacred notion of relational databases.
2002-07-29
8,359 reads
Unauthenticated System Compromise of SQL Server 2000
Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.
2002-07-29
3,960 reads
Understanding Execution Plans Part 1
The purpose of this article is to give you a working knowledge of how to view and understand query execution plans for SQL Server. This is part 1 in a series of articles that will walk you through understanding execution plans to help you improve your queries.
2002-07-26
24,294 reads
SQLClean 2.0 Released
SQLClean is a SQL Tool that automatically creates a dependancy analysis of your SQL Server Database including tables, views, triggers, defaults, procedures etc. SQLClean will also analyze a client application for depenandies on SQL Objects allowing you to detect and eliminate unused SQL objects that are unreferenced by either the client app. or database itself.
2002-07-26
3,537 reads
The Vision Series
From News.com, this series contains a bunch of interviews and surveys of a number of CTOs from large US corporations. Worth a read to see what the heavy spenders think.
2002-07-25
2,550 reads
Security Update for SQL Server SP2
Microsoft has release a cumulative security update for SQL Server with SP2. Read , download and update your SQL Server!
2002-07-25
3,912 reads
Documented and Undocumented Trace Flags for SQL Server 2000 and 7.0
This article contains descriptions of 65 documented and undocumented trace flags currently available in SQL Server 7.0 and 2000.
2002-07-24
14,910 reads
Review: Recover from Almost Anything with Log Explorer 3.0
Oops, a developer just forgot a WHERE clause when he ran his delete statement. Lumigent Log Explorer 3.0 can peer into the transaction log and find the culprit and roll it back. Read the review here of Lumigent's latest version.
2002-07-23
4,013 reads
Designing a Database with Microsoft Visio 2000
An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.
2002-07-22
9,147 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers