Here is a useful list of tips for SQL Server 2000 optimization.
Author: SSWUG Research
Billions lost to poor data quality
By Sara Cushman – Good, clean data is sort of like good taste. Many people believe they have it. Plenty don’t. It’s also wildly subjective; the definition of quality data varies from business to business.Data quality problems, though, have far more dangerous and costly consequences than serv
The Book of SAX
The Book of SAX: The Simple API for XML by W. Scott Means and Michael A. Bodie (ISBN 1-886411-77-8) is a comprehensive tutorial and reference for SAX 2.0 using numerous examples.
SQL Server 2000 – Programming
This course provides delegates with the technical skills required to program a database solution by using Microsoft SQL Server 2000.
Log File Growth and DBCC DBREINDEX
Q. I have a 30 gigabyte (GB) database, and I use the Full recovery model. Whenever I use the database consistency checker (DBCC) statement DBCC DBREINDEX to reindex certain large tables periodically, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete.
Tracking Time
By Russ Whitney – Track the time employees spend working on projects.
Add XSLT Document Intellisense to VS.NET
Ever wish you had Intellisense when creating XSLT documents in VS.NET? Joe Feser (http://www.fesersoft.com) has published an excellent XML schema for XSLT that can be used to provide Intellisense for XSLT documents in VS.NET.
Web-Enabling Personal Oracle Using Apache and MOD_OWA
According to Doug McMahon, the creator of the current version of MOD_OWA, “mod_owa is an open-source implementation of the PL/SQL gateway available in Oracle’s OAS/OWS product. The gateway is able to call PL/SQL procedures in a manner similar to the way Java servlets are supported, with the Oracle d
Secrets of the XML developer elite: Janet Sullivan
Janet Sullivan knows that the successful use of XML depends on how clean developers can keep their XML data trees. Make sure bad data does not corrupt your XML data tree, insists Sullivan. In this piece, Sullivan gives tips and tricks for XML developers to keep the introduction of dynamic data safe.
Upgraded Onyx CRM adds Web services, Oracle ties
By Matt Hines – CRM veteran Onyx Software Corp. is betting on new functionality around emerging Web services and links to Oracle Corp. database technology to help drive its fourth generation of enterprise applications deeper into the middle market.