This site is going to be dedicated to remotely monitoring and automating administrative tasks in MSSQL 7 & SQL2000. You will find different scipting technologies incorporated through out these links.

Learn to administer SQL Server programmatically using Distributed Management Objects (DMO).

From SQLTeam – Lately a few questions have come up in the forums along the lines of "How do I update a table with the values of another table?". Graz wrote an Ask SQLTeam article last year on Inserting from another table, this article is going to cover Updates.

(Dan Wahlin) Accessing data from a database has always been a fairly straightforward process when using an object model such as ActiveX Data Objects (ADO). However, accessing data from a database in the form of XML has usually involved resorting to custom programming routines or modifications to exi

By Brian Moran – Microsoft recently released SQL Server 2000 Windows CE Edition. Although SQL Server CE is an important product, I don't know when companies will start clamoring for CE-savvy SQL Server professionals. You might not have to worry about wireless for another 5 years, or this winter

Read Brian Moran's SQL Perspectives to find out all about Microsoft's new benchmark record for the world's largest MOLAP-based data warehouse.

Slerp.com has found an issue when upgrading the Peoplesoft Financials or the HR schema from SQL Server 7.0 to SQL Server 2000. A hot fix for SQL 2000 is now available, and the article also offers several workaround methods if you don’t have the fix from Microsoft.

By Paul Yao and David Durant – Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed a

Data mining is a term for the computer implementation of a timeless human activity: It is the process of using automated methods to uncover trends, patterns, and relationships from accumulated electronic traces of data. Data mining—or knowledge discovery, as it is sometimes called—lets you exploit a

From SQL Team – Roger writes "Is there a way to retrive a field value from the previously read row in order to use it to calculate a field in the current row . . ." Check out the answer.