XTIVIA BLOG
Business Intelligence is not an Oxymoron
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two de-normalized...
Operational Considerations for a Business Intelligence Initiative
As professionals working in the business intelligence (BI) and data warehousing field, if we’re not posing questions of our data warehouse, we’re asking ourselves questions--especially about how to do our job better or maximize the value of our warehouse. Here are three common...
SSRS Combining Different Chart Types & Adding a Secondary Vertical Axis to a Chart
Combining different chart types and adding a secondary vertical axis in SSRS can enhance data visualization significantly. This guide explains how to achieve these features, focusing on the steps to implement a client-side solution for creating complex charts. By following...
Dynamically Hiding Columns in Jaspersoft iReport
Columns can be hidden dynamically by using Jaspersoft iReport’s Table Component (Note: Styling & Group/Sub Group Totals will have to be manually added). To use the Table Component, first add a dataset to the report (select the report in the ‘Report Inspector’ and right...
Informix SE And The 32-bit File System
XTIVIA has a client who runs an old Informix database product, Standard Engine (SE) version 5.01.UD3, on SCO UNIX version 5.0.5. Both have been running well for at least twenty years without much in the way of outages. Over the years XTIVIA has assisted the client...
Database Migration Doesn’t have to be a Nightmare
In recent times, database migrations have become a way of life for most database administrators. Whether moving to new hardware or into the world of virtual machines, what once was a rare project is becoming an almost everyday concern for database environments everywhere. At...
Best Practice: Liferay Transaction Isolation Level for MS SQL Server
Set the transaction isolation level to READ_COMMITTED with READ_COMMITTED_SNAPSHOT turned ON. Yay! When I mention the words "transaction isolation level" to SQL Server DBAs, the first words out of their mouths are almost always "READ COMMTTED" or "2". This...
Dataguard Reset Logs
Ran into an interesting situation recently with a managed services client running Oracle 11.1.0.7.0 Enterprise Edition on Linux in a two node RAC environment with Dataguard. The client asked to have the dataguard instance changed over to read/write to do some testing....
IBM Informix Trusted Client Connections
In the past, using a client-server architecture with IBM Informix database software required adding an entry on the database server with the client details, either in a .rhosts file in a specific user directory or the/etc/hosts.equiv file. If one of these was not present the...
Google Analytics Event Tracking with Liferay
Google Analytics gives you insights into how visitors use your site, how they arrived on your site, and how you can keep them coming back. Liferay includes built-in support for Google Analytics out of the box, allowing administrators to make use of Google’s tool set for...