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.
Worst Practices - Depending on the GUI
One of the strengths of SQL Server is its ease of management and administration over other systems. Oracle, DB2, even early versions of SQL Server required command line mastery to make many types of changes. But should you really be using the GUI for most of your tasks?
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.
A New Way to View and Analyze Your Data
With Data Analyzer—the brand-new Office data analysis solution—you can quickly and easily view, analyze, and share business data, giving you the power to make better business decisions.
Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server
This article describes how to monitor Microsoft SMTP usage using SQL Server 2000 and XML.
HOWTO: Run Singleton SELECT Queries in a Visual Basic Client
This article demonstrates how to retrieve a single record from SQL Server by using the IRow interface with a singleton SELECT. The main purpose for this technique is to avoid the overhead of creating a recordset when you are fetching a single record. Because no recordset is actually created, only one read-only ADODB.Record is returned. This is true even if the specified SELECT results in multiple records being returned if a normal ADODB.Recordset is used.
SQL Server 2000 Undocumented System Tables
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
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.
SQL Server 2000 Replication Chat Hosted by PASS Today
SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers