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!
ASP - Reaping the benefits of SQL 2000's FOR XML clause.
In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.
Point-Counterpoint - Why you Should be Certified.
In this view, Steve thinks that certifications are invaluable (especially in this economy).
Point-Counterpoint - Why You Should NOT Certity.
Andy Warren thinks certifications are worthless. That's opinion came after he obtained his MCDBA and MCSE certification. Find out why he thinks you should not be certified in this debate with Steve Jones.
Point-Counterpoint - Certification Debate
A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers