(Paul Zikopoulos) At the IBM Information Management Information on Demand (IOD) conference in Las Vegas in October 2007, IBM made a number of major announcements, which included the christening of the DB2 Viper 2 beta as DB2 Version 9.5 (DB2 9.5), and the introduction of a new toolset for IBM data s
Other News
Controlling the Content Evolution
(Alan Joch) For Emerson Process Management, getting a handle on content isn’t just about keeping multiple gigabytes’ worth of important data organized and accessible. Thanks to workflow engines and other sophisticated tools, the company is using the power of information to create new processes and k
Oracle 11g: Cross-tab report using PIVOT and UNPIVOT operator
Microsoft introduced the PIVOT and UNPIVOT operator in SQL Server 2005 to generate cross tab reports i.e. to convert rows into columns and columns into rows. You can read more on that in our whitepaper. We have also covered the traditional way of pivoting the data for prior version of SQL Server and
Conditional Column Formatting in APEX
(Tyler Muth) I wanted to share a little trick I’ve used in APEX for a while now to conditionally format report columns based on their values. I’m sure there are plenty of alternatives to this trick, including the 4 built-in conditional alternatives for a row when using a named column template.
Oracle BI EE 10.1.3.3/2 – Saved Selections and Collapsible Sections
(Venkatakrishnan J) I thought i would blog today about a simple feature called Saved Selections as it pertains to user customizations. In a multi user environment one of the most important things that any end-user would need is the ability to customize the dashboards according to his own taste/needs
Generate date dimension that support working days calculation
(Marco Russo) I just wrote a T-SQL query based on CTE that generates support information to calculate working days in a period. Simply look at the WorkingDaySequential measure, which difference between two dates is the number of elapsed working days.
Database mirroring factors to consider before setup
(Hilary Cotter) Properly configured database mirroring will provide high availability, however there are many factors you must consider before deploying a database mirroring solution. These factors range from the service pack and edition of SQL Server 2005, to environmental factors, like your networ
Advanced Matrix Reporting Techniques
(David Leibowitz) I remember the first time I used a Matrix component in SQL Server Reporting Services (SSRS). I right-clicked the detail row, selected Subtotal and was amazed that RS “knew” that I wanted to sum the values of the rows. Without any need to specify a formula, I had aggregates with a s
Feedback on 1.000 Versions
Featured Article(s) Troubleshooting SQL Server 2005 Database Mail Problems In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 Database Mail. He also tells you how you can resolve these problems. Thanks To Our Sponsors We’ve worked with some great companies this year! We really appreciate their support and help in […]
SQLonCall: Interviews; MaximumASP (can even get a free SQL Server 2008 database), BinaryTree, and more.
Pro-Center Video Programming for IT Professionals