(Venkatakrishnan J) I saw another question in one of the forums today wherein the user basically wanted to change the Column Indent Color in a Pivot table. As you might know, all the attributes of a pivot table are exposed to end users and can be customized using Section, Page and Column properties.
Other News
Data Mining in the Future – Combining Online and Offline?
New SQL Server Show Now Available Our new weekly show for SQL Server is now online and ready to go. Check out SelectViews – here’s an overview of the show: SharePoint Feedback Results, Discussion Watch, Information Overload and Gaming – What It Could Mean For DBAs. Also – Newsletter Feedback, Upcoming SQL Server Events, Baselines and SQL Server Instances And […]
Implementing a transaction hub MDM pattern using IBM InfoSphere Master Data Management Server
(Eberhard Hechler, Martin Oberhofer and Paul van Run) Learn to use the transaction hub Master Data Management (MDM) pattern to implement your MDM systems. This typical architectural pattern is described in terms of capabilities of the MDM Reference Architecture. Get an introduction to the IBM InfoSp
Free DB2 for z/OS Web Services Development Tool with pureQuery
(Troy Coleman) Last week I noted that IBM is aggressively trying to make DB2 for z/OS the database platform of choice for businesses. To help remove the roadblock of high cost traditionally associated with z/OS, IBM is providing lower-cost hardware, a one-time charge for DB2 and, now, free developme
Build a mobile RSS reader
(Frank Ableson) What good is a mobile computing environment if you can’t keep track of your favorite news feeds on the go? Sure, you can use Android’s browser to read your favorite Web sites, but it’s unlikely the sites are optimized for a screen two inches high. And besides, then you’ll miss the op
V6R1 DB2 for i5/OS Highlights
(Jim Flanagan) Because DB2 for i5/OS is embedded within i5/OS, application designers and programmers likely expected that with the V6R1 release of i5/OS there would be plenty of database enhancements included. They weren’t disappointed, because the developers of DB2 for i5/OS have been busy developi
Development Governance for Mashups
(David Norfolk) “Mashups” (and all the rest of the “Web 2.0” buzzwords) make up one of the more exciting trends to emerge recently. They promise to give the Enterprise a different view of its data assets, treating both structured relational database data and less-formally-structured operational busi
Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth (Karma Police)
(Richard Foote) One of the great myths surrounding the use of differing block sizes is that storing indexes in larger block sizes somehow dramatically improves the performance of index related multiblock reads.
Trigger Efficiency in Oracle
(Alexander Ocher) The documentation for Oracle 9.2 and previous versions contains the following paragraph: “AFTER row triggers are slightly more efficient than BEFORE row triggers. With BEFORE row triggers, affected data blocks must be read (logical read, not physical read) once for the trigger
.NET Debugging Demos Lab 6:_Memory Leak
(Tess Fernandez) It’s been about a week since I posted the debugging challenge for this lab, things have been a bit busy lately so sorry about the tardiness on posting the lab.