This article describes a methodology for building an XML-based, end-to-end, multi-tiered solution by leveraging XSLT technology. The authors introduce this methodology through an example application in which XSLT is not only used in the transformation at the presentation layer, but also in retrievin
Author: SSWUG Research
HOW TO: Use the ExecuteXmlReader Method of the SqlCommand Class in Visual Basic .NET
You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can only use this method to run server-side for XML queries and to run queries t
Validate Data with XML Schemas
by Claude Duguay – Learn an approach that uses the Multi-Schema XML Validator Java library to parse XML Schema for simple, but powerful, data types.
Oracle Bets $150M on Unbreakable Linux
By Peter Galli – Oracle Corp. plans to spend some $150 million this year on a new initiative designed to greatly increase the number of applications available to customers on the Unbreakable Linux platform.
Introducing Microsoft SQL Server “Yukon”
Get a first look at major feature enhancements currently in development for the next version of SQL Server, code-named “Yukon.”
EXECUTE IMMEDIATE option for Dynamic SQL and PL/SQL
Amar Kumar Padhi shares usage tips and examples of EXECUTE IMMEDIATE, which replaced DBMS_SQL package in Oracle 8i and above.
Upgrade to Books Online SP3
Many people don’t realize that a new version of SQL Server 2000 Books Online (BOL) ships with SP3. Here Brian Moran talks about some of the crucial changes that the updates in BOL include.
XML Standards for Financial Services
by Ayesha Malik – The financial services industry spends billions of dollars on IT development to maintain its competitive edge. Most recently, banks, risk management firms, and insurance companies have been focusing on automating business processes and building systems that reduce the time from neg
Track SP Changes by Automatically Saving Your SQL Server SP Text
by Randy Dyess – Tracking stored procedure versions is not easy with SQL Server. In this article, learn how the author wrote his own SP versioning system.
Information Modeling with XML
When XML first came into use, it was seen primarily as a data interchange standard. Since then it has come to be used for more and more things — even serving as the core for development and deployment platforms such as Microsoft’s .NET. Increasingly, XML has become the means to model components of i
