by John E. Simpson – This month, I begin the fourth year of writing XML.com’s “XML Q&A” column. I’d like to thank my editors here for continued support and indulgence; at no time is that indulgence more evident than in August, when I tackle questions that no one has, to my knowledge, actually posed.
Other News
Stored Procedures Administration
By Alexander Chigrik – SQL Server ships with number of stored procedures, which can be used for managing the database and displaying information about databases and users. These stored procedures are called system stored procedures. The system stored procedure’s name started with the prefix sp_ to d
ISVs Courted for ‘Yukon’ Apps
By Lisa Vaas – Microsoft Corp. plans to whet the appetite of small and midsize businesses for a major update of its SQL Server database—code-named Yukon—with a liberal helping of Yukon-ready applications.
Database Servers Making Evolutionary Progress
By Timothy Dyck – Since we performed our comparative database server performance tests, there’s been incremental change in the products but no big shifts in any server’s design or market presence. IBM’s DB2 8.1 has superseded Version 7.2, and the 8.1 release supports many more online configur
Learning Guide: DB2 basics for Oracle and SQL Server DBAs
By Sara Cushman – DB2 took top honors in some DBMS market share reports this year, which means many companies may have already, or will soon be, switching over to IBM’s brand of data management.
Faster Federated Queries with MQTs
By Dan Gibson – Materialized query tables in DB2 UDB v.8.1 can cache remote data on your local DB2 instance.
Oracle PL/SQL Best Practices
Book By Steven Feuerstein – Oracle PL/SQL Best Practices is a concise, easy-to-use summary of best practices in the program development process. It covers coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in pack
Using the XSLT document() function in .NET 1.1
Version 1.1 of the .NET platform sports a slightly different XslTransform object with more secure Load() and Transform() methods. Many of the overloaded versions of the Transform() method from version 1.0 of .NET are now considered to be obsolete. If you take a closer look at the Transform() method
Delve Into Data With Business Intelligence
by Rob Ericsson – Don’t let valuable data languish in unaccessed databases. Use proper storage, business intelligence, and .NET technologies to give decision makers the information they need.
XML Security Library 1.1.1
Aleksey Sanin has released version 1.1.1 of the XML Security Library (xmlsec), an open-source implementation of the joint IETF/W3C XML Signature (dsig) and W3C XML Encryption (xenc) specifications. This release adds X509Data node templates support to the NSS implementation, includes new functions fo