By Randy Dyess – Learn the basics of how to create and manage SQL Server stored procedures.
Other News
XML Matters: Enforcing validity with the gnosis.xml.validity library
By David Mertz – Most hitherto existing XML APIs have enforced well-formedness at a programmatic level, but hardly any can guarantee validity. This is a serious weakness in the whole field of XML processing. This installment discusses the author’s gnosis.xml.validity library for enforcing validity i
Java and XML in OLAP Systems
by Manoj Sharma – Most OLAP systems are modeled after relational databases, but sometimes object-oriented databases work. Apply XML data modeling and JAXB to a retail-chain OLAP example.
Relax NG schemas for XML Encryption and XML Signature
Two new Relax NG schemas for XML Encryption and XML Signature have been published by Joseph Reagle as public resources available for XML Encryption and XML Signature.
XML in Mozilla 1.0
The long-awaited release of Mozilla 1.0 finally arrived this month, after a staggering three year development process. Standards compliance has always been an important goal in Mozilla, and manyfold XML standards have found their way into the product.
W3C Makes XML Signatures More Portable
By Thor Olavsrud – The World Wide Web Consortium (W3C) advanced a recommendation critical to the XML family of technologies; a recommendation which is especially important to Web services. Exclusive XML Canonicalization builds on the previous Canonical XML recommendation, enabling the portabi
Processing SOAP Headers
Rich Salz explains how to process SOAP headers and why you’d want to. Along the way he predicts the demise of SAX-based SOAP processors.
Oracle U. defends OCP title
By Sara Cushman – Defending their new DBA certification requirement against critics who say it’s costly and unnecessary, Oracle described the move as part of a new strategy to ensure that only top-shelf candidates receive the company’s stamp of approval.
Database Link ‘Panic’ Backup Script
by Galina Petrenko – This script produces readable output (backup) for database links in the database. It can be used in the restore/recovery process. Note that passwords for database links are also spooled in a readable format.
Create and Manage SQL Server Stored Procedures using Transact-SQL
As we learn more about SQL Server and Transact-SQL it is easy to become overwhelmed with the amount of information out there. I can recall hundreds of times when I have said, “I know there is a (stored proc, DBCC command, SQL statement, ect) out there that does that, I just can’t remember its name.”