A brief look into linking SQL Server to such systems as Oracle, DB2, Sybase, etc., through Open Database connectivity.
Author: SSWUG Research
Building a Data Warehouse to Handle Customer Relationship Management
(Vic Werner and Craig Abramson) The data collection and marketing techniques in today’s information economy have changed from the old days, but the basics remain very much the same. CRM initiatives are designed to strengthen and expand ties with customers by tapping the full potential of a company’s
Determining the hit ratio of Oracle databases
By Peter Choi – This script is useful for determining the hit ratio of your database. The hit ratio determines if Oracle is performing more physical reads to retrieve the data. If the data being queried is found in the buffer cache, the hit ratio will be higher than if the data is not cached a Oracl
Kicking back with RELAX NG, Part 1
RELAX NG schemas provide a more powerful, more concise, and semantically more straightforward means of describing classes of valid XML instances than do W3C XML Schemas. The virtue of RELAX NG is that it extends the well-proven semantics of DTDs while allowing orthogonally extensible datatypes and e
Generate XML Mapping Code with JAXB
If you write any DOM or SAX code, you need to learn Java Architecture for XML Binding (JAXB). It rapidly generates XML mapping code for you, saving time and effort, and reducing both costs and risks. JAXB is a specification for a set of APIs and tools that generate java classes based on the domain m
Antenna House XSL Formatter plug-in for XML Spy 5
XSL Formatter plug-in for xmlspy® 5 is available free of charge for all users of XSL Formatter V2.4. It’s an add-on connection module for xmlspy. It offers the combination of both the formatting function of XSL Formatter and the editor function of xmlspy to format XSL-FO document. The component is d
Oracle’s Souder Talks Distributed Databases
By Barbara Darrow – Some might say Benny Souder’s title, vice president of distributed database development at Oracle, is an oxymoron. After all, Oracle sure seems wants everything in the world to be in one huge (Oracle) database. At least that’s what Microsoft and IBM say. That’s even what O
Pipelined Table Function
by Claudiu Ariton – The purpose of this code is to provide an example of the new pipelined and parallel PL/SQL table functions available in Oracle9i Database.
Alternative Aggregations
By Russ Whitney – Analysis Services natively supports many aggregation types, but sometimes you need to perform an aggregation that native types can’t handle. Here are some ways you can use non-native aggregation types to solve real-life calculation problems.
Certification still pays, says study
By Lisa Kelly – Bonuses rise to eight per cent of base salary – if you have those letters after your name. Workers are more likely to receive bigger bonuses if they have technology certifications than if they rely on skills based on knowledge or experience, according to a new survey.