(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DRILLDOWNMEMBER() Function. We discussed the nature of drilldown, in our last article, stating that it comprises an analytical technique through which means an in
Other News
How to Set Up a SQL Server Stress Test Environment in 8 Steps: Lessons from the Field
(Geert Vanhove) This article is the third in a series of four where I share my findings on baselining, monitoring, stress testing and performance tuning. It builds on the foundations of my previous articles on baselining and monitoring.
Secure programmer: countering buffer overflows
(David Wheeler) This article discusses the top vulnerability in Linux/UNIX systems: buffer overflows. This article first explains what buffer overflows are and why they’re both so common and so dangerous. It then discusses the new Linux and UNIX methods for broadly countering them—and why these
High-Performance ETL
(Roger Deng) DB2 Universal Database Enterprise Server Edition (ESE) with the Database Partitioning Feature uses an architecture that’s optimized for scalability and high performance in a partitioned environment — in other words, one that’s perfect for extract, transform, and load (ETL) projects. ETL
Tools for Your .NET Space
(Christian Shay) You’re working on some C# or VB.NET routines that manipulate data you’re retrieving from Oracle Database. You need to access the database to edit and test some stored procedures, modify some data in a table, change the structure of a table or view, or perform one of countless other
What’s Happening with Databases
Pro-Center Video Programming for IT Professionals
Find the Hard Parse Rate
(Vishwamithran S) The following script is designed to find the hard parse rate of programs.
IBM Jumps On Open Document Bandwagon
(Barbara Darrow) IBM said the next release of its Workplace Managed Client 2.6, due early next year, will support ODF version 1.0. ODF is an XML standard blessed by the Organization for the Advancement of Structured Information Standards (OASIS).
Microsoft’s strong midmarket channel thwarts Oracle, SAP
(Robert Westervelt) As SAP and Oracle Corp. move into the midmarket to build a larger customer base, they are struggling to untangle Microsoft’s web of channel partners and build a strong network of their own. (R)
Event Notifications – an interesting example – Handle backup/restore audit events
(Darshan Singh) You may know that Service Broker gets disabled when a database is restored or when a database is attached. What if you need to enable it whenever a database is restored? This is just one example, but what if you want to perform some similar post-restore actions?