Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization.
Other News
Database coding conventions, best practices, programming guidelines
Databases are the heart and soul of many of the recent enterprise applications and it is very essential to pay special attention to database programming. I've seen in many occasions where database programming is overlooked, thinking that it's something easy and can be done by anyone. This is
SQL Data Compare Keeps Data in Different Databases Synchronized
by Brad M. McGehee – In this article, I want to review another product from Red-Gate Software called SQL Data Compare. The names of these two products is very similar, so don’t get them confused. What SQL Data Compare does is to compare the data between two like databases, and if desired, it allows
Namespace Reference
At ZVON.ORG you might want to check out the namespace reference. Namespaces are described in W3C document Namespaces in XML. You may find their Namespace tutorial useful.
XML Content Management for Digital News
Fisher Communications has selected the Ingeniux XPower Publishing System, a provider of XML content management and deployment systems for the wired and wireless web, to support an innovative news and entertainment portal for their 12 television stations and 26 radio stations. By using Ing
Displaying XML Data Islands with JavaScript
This tutorial shows how to take advantage of Internet Explorer 5's ability to embed XML data islands in HTML to produce an XML view of data.
Inline or Embedded SQL vs. Stored Procedures
Why does my inline or embedded SQL run faster than my stored procedures? Check it out for the answer.
SQL Server Passes Sun/Oracle
Read how a 32-processor Unisys ES7000 running SQL Server 2000 surpassed the best performance of a 64-processor Sun/Oracle system.
Selecting Based on a Version Field
From SQLTeam, Sherry writes "I have a table with form_id, lta_id, type, version and other stuff. My users are allowed to fill out a form multiple times. I need to keep the old versions, but for computations, I only want to add up the newest version. The rest of Sherry's question is in the bo
XMLZip
XMLZip is a unique XML file compression tool that compresses XML documents based on node levels within the document object model (DOM). Large XML files consume bandwidth on the Internet and large amounts of storage on both the client and server machines. A product catalog represented in XML c