A New Way to View and Analyze Your Data

• by Additional Articles

• Microsoft SQL Home

• News
• Uncategorized

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

• by Kunal Das

• SQLServerCentral.com

• Basics

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

• by Additional Articles

• Microsoft MSDN

• T-SQL

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

• by Alexander Chigrik

• SQLServerCentral.com

• Administration

Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.

The Geek Test

• by Steve Jones

• SQLServerCentral.com

• The Lighter Side

Are you a geek? Take this quiz.

Where should I save my DTS packages?

• by Brian Knight

• SQLServerCentral.com

• DTS

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

• by Additional Articles

• PASS

• Service Packs

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.

• by Leon Platt

• SQLServerCentral.com

• ADO

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.

• by Steve Jones

• SQLServerCentral.com

• Miscellaneous

In this view, Steve thinks that certifications are invaluable (especially in this economy).

Point-Counterpoint - Why You Should NOT Certity.

• by Andy Warren

• SQLServerCentral.com

• Certifications

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.