(Scott Robinson) How to design and implement efficient data cubes for OLAP use in a data warehouse using SQL Server 2000. (R)
Other News
Book review: A guide to SQL Server 2000 transactional and snapshot replication
(Narayana Vyas Kondreddi) As the title suggests, this is a book about SQL Server replication, and just about SQL Server replication. Yes, at last, there is a dedicated, comprehensive book, that covers all aspects of SQL Server 2000 transactional and snapshot replication. This book comes from Hil
Configuring Oracle9i RAC and Oracle RAC 10g on the Same Cluster Using CRS
(Ashok Singh) Oracle Database 10g contains many enhancements, but one of the most interesting is the introduction of Oracle Cluster Ready Services (CRS), Oracle’s full-stack clusterware.
XML Performance and Size (Sample Chapter)
(David Megginson) XML has a reputation for being big and unwieldy, but the reputation isn’t entirely deserved. Many of the size and processing requirements for XML files are the result of inefficient development tools. This chapter provides an explanation of the issues involved in file size and exec
TechTip: Access Packed Data in
(Kevin Forsythe) Awhile back, I wrote a TechTip on accessing packed data from flat files. Perhaps that’s not something you do every day, but it’s definitely something that is difficult for SQL to do. That TechTip outlined the basic method for extracting the packed data. But it stopped at that point.
Meet the Future of Data Head-on with Comega
(Laurence Moroney) I first saw Comega about a year an a half ago when the lab that was developing it gave me a sneak preview and asked me for some feedback. The only feedback I could give at the time was “Wow!” Now, everybody can get access to this add-on to C# as Microsoft Research has released the
FIX: Duplicate import schema may cause the XML schema compilation to fail
When a duplicate import schema is encountered during compilation, System.xml may throw the following error message: Item has already been added. Key in dictionary:”file:///C:/C.xsd” Key being added: “file:///C:/C.xsd”
Calculating Entropy for Data Miners
(Paul Meagher) Calculating Entropy for Datamining discussed the Entropy.php class, which provides web database programmers with quick access to an entropic analysis of a single database column. This article discusses the concepts of joint and conditional entropy through developing the corresponding
Oracle’s lineup of Online Seminars for April 2005
OracleDirect’s online seminars scheduled for April cover such topics as Oracle Enterprise Manager Grid Control, Oracle, MySQL & Open Source…and more.
Improving Developer Productivity with Visual Studio .NET Macros
(Scott Mitchell) Most developers I’ve met and talked to throughout my career have shared one thing in common: their interest in solving problems and their disdain of the mundane. Boring, repetitive tasks are the bane of the development world, so much so that oftentimes programmers will spend countle
