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.
Author: SSWUG Research
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
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
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.
Why does my SQLXML 3.0 setup fail when I have MDAC 2.7?
Answer provided by Amar Nalla – The SQLXML 3.0 install may fail on machines that have MDAC 2.7 installed on them. If this happens you can check the value for the following registry key:
Top Six FAQs on Windows 2000 Disk Performance
by Mark Friedman – In this article I’ve provided answers to the most frequently asked questions I’ve received from experienced computer performance professionals. What I’ve found is when these professionals first start to look seriously at the data available on disk performance on a Windows NT/2000/
Squeeze the size of files in a tablespace
By Sergey Solodilov – This tip decreases the size of files of a tablespace to the bare minimum. It’s useful when you have many files in a tablespace and you’ve moved some tables or indexes into another tablespace, and then you want to decrease the size of the first tablespace.
Design XML schemas using UML
By Ayesha Malik – Unified Modeling Language (UML) is an industry standard that is used in modeling business concepts when building software systems in an object-oriented manner. Recently, XML has gained ground in becoming a key enabler of these systems in terms of transport of information and comman
JAX Pack! – Bridging The Gap Between Java and XML Technologies
by Hitesh Seth – Sun has launched a set of technologies collectively known as the JAX Pack. JAX Pack – essentially a bundled set of Java technologies for XML – consists of JAXP (XML Processing), JAXB (XML Binding), JAXM (XML Messaging), JAX-RPC (XML-based RPC), and JAXR (XML Registries).
Mapping XML to Relational Databases
In addition to XSLT, there are several other XML document parsing and database specific techniques that can be used to migrate XML data into a database. Rather than focusing on these solutions, this example demonstrates how native ADO.NET classes such as SqlDataAdapter and DataSet can be used along