OLEDBTemplate.exe demonstrates how to extract an XML stream from a SQL Server 2000 database using an XML template file.
Other News
Random number between two integers
By Siva Val – Though Oracle provides an internal function to generate random numbers, there is no function that gives a random number between any two given integers. Sometimes this is needed to pull random data for test cases. The following function generates a random number between any given two in
Ready for Prime Time
Three and a half years of development work by some 5,000 Microsoft Corp. staff will culminate this Thursday in the launch of the Windows Server 2003 family of products at an event in San Francisco. Amid the flurry of final engineering work, Bill Veghte, corporate vice president of Microsoft’s Window
The Soul of the Data Warehouse, Part One: Drilling Down
by Ralph Kimball – Drilling down, drilling across, and handling time are so important that I’ll devote a separate column in this Fundamentals series to each. In this column, I drill down into drilling down, starting with a precise operational definition. Then, as a good engineer should, I lay out pr
MDX Essentials: Member Functions: More “Family” Functions
By William Pearson – Author Bill Pearson continues his MDX Essentials Series with an introduction to more Member “Family” Functions. In this lesson, we will continue our exploration of the “Family” functions with the .FirstChild, .LastChild, .FirstSibling and .LastSibling functions.
Grouping Time Intervals
SQL Server Magazine columnist Itzik Ben-Gan shows you an elegant solution for selecting groups of data based on overlapping time intervals.
Best Databases for Small Businesses
By Vincent Ryan – Oracle 9i Standard Edition carries a base list price of US$300 per user. SQL Server, by contrast, sells for $2,249 for 10 clients, or about $225 per client. On the high end of the spectrum, IBM’s DB2 Workgroup Server sells for about $870 per user.
Microsoft, Oracle tout OLAP successes
(Ellen O’Brien) Oracle and Microsoft this week both announced victories in the world of online analytical processing (OLAP), one boasting the results of benchmark tests and the other heralding the results of an annual market share report. (R)
Altova Software Offers XML Solution for Unstructured Data
Altova’s XML IDE, xmlspy, is leading an important niche that will put billions of documents back into the corporate knowledge base. Find out how the company is one-upping Microsoft in its quest to deliver unsurpassed data flexibility.
Adapt Web Content to Any Device
by Jeff Jurvis – Use ASP.NET Mobile Controls to generate properly formatted content for any XML language on any device.