XTIVIA BLOG
Building a Better-Looking User Action Menu in Liferay 6.1
The Dockbar provides one-stop shopping for your Portal administration needs; but sometimes you either don't like the default look of it (if you're building from _styled) or you don't feel like styling it from scratch (if you're building from _unstyled). You can provide links...
Scrum Thought: Focus on activities not roles.
This is the first in a series of small posts aimed at new Scrum teams or those who have been doing Scrum for a while but are struggling to net the positive results they've heard about when going Agile. I'd like to start with a handful of highlights from the Scrum...
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....