Get a first look at major feature enhancements currently in development for the next version of SQL Server, code-named “Yukon.”
Other News
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.
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.
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
Leverage XSLT to build applications
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
OLAP Distinct Counts and Performance Analysis
See cube design techniques used to solve useful business questions and a performance study of Distinct Counts using Microsoft Analysis Services 2000 and a Unisys ES7000 server.
Finding the Nth maximal value: An extension of the MAX T-SQL function
(Eli Leiba) The following procedure gets a tablename, column and integer (N) as parameters and finds the Nth largest value of a column in a specific table. For example, running it with “products,” “UnitPrice,” and “13,” retrieves the 13th largest value of the UnitPrice column from the products table
Using XSLT and .NET to Manipulate XML Files
By Cynthia Carolina – XML Stylesheet Transformations (XSLT) is defined as a language for transforming source XML documents into another document formats using XML Path Language (XPath) as a query language. This is particularly useful when incoming or outgoing XML documents do not match the document
Oracle cuts 11i E-business Suite prices
By Gareth Morgan – Oracle has cut the price of its e-business software suite as it tries to drum up business, but analysts warn that deployment and ongoing costs are more important than upfront bargains.
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
