by XTIVIA | Aug 21, 2012 | Blog, Business Intelligence, Data Warehousing, Portals
A requirement that is often found in enterprise IT environments is the need for “dashboards” that provide integrated, highly visual (e.g., chart-driven) representations of key data to executives, analysts and key decision makers. In addition to the data...
by XTIVIA | Aug 6, 2012 | Blog, Databases
While creating a linked server from SQL Server 2005 to SQL Server 2000, I got the following error when I tried to query the remote server. OLE DB provider “SQLNCLI10” for linked server “XXXXXX” returned message “The stored procedure...
by XTIVIA | Aug 2, 2012 | Blog, Databases
Hello again, I wanted to follow up on my last blog entry about speeding up the DB2 database restore on an AIX machine. We did some more testing last night by enabling the jfs2 logging back to how it should be. The restore took only 5 minutes when it used...
by XTIVIA | Jul 31, 2012 | Blog, Databases
Hello, I wanted to share some lessons learned with AIX kernel parameters and DB2 database restore performance. We have a client with a 21 GB database on AIX version 6.1 and DB2 9.7 fixpack 6. The server has 8 quad-core CPU and 32 GB of memory. This is a...
by XTIVIA | Jul 30, 2012 | Blog, Business Intelligence, Data Warehousing
We get quite a few questions around Dashboards and Scorecards. I think it is good to enumerate the differences between the two so that when you are ready to implement you don’t lose sight of the differences. So, without further ado, here are the differences that...
by Tony Salerno | Jul 25, 2012 | Blog, Databases, Perspectives
How do you know if you have the right number of database administrators (DBAs) on staff to properly take care of your environment? All your organization’s databases need to be kept operational and properly tuned, which probably requires around the clock...
by XTIVIA | Jun 28, 2012 | Blog, Data Warehousing
Changing business condiitions drive changes in business requirements (sometimes like wildfire, utterly unpredicatable) I have been through this situation numerous times, as I am sure you have been as well. So how to respond to these changing conditions? What if we...
by XTIVIA | Jun 28, 2012 | Blog, Business Intelligence, Data Warehousing
Several weeks ago USAToday actually published an article about business intelligence on the front page. The story started with a discussion of a solar panel manufacturer so you had to read a little more to find out that the story really was about BI. I was...
by Michael Hahn | Jun 27, 2012 | Blog, Portals
Adding custom mobile device rule handlers in Liferay 6.1 enhances mobile support and customization. This guide walks you through creating a custom rule handler, starting with setting up a liferay-hook.xml file and configuring the portal properties. By following these...
by XTIVIA | Jun 1, 2012 | Blog, Databases
I was presented a problem which entailed removing 100s of millions of records from several tables in order to recover disk space and improve query performance. There were several options to choose from of which I explored: I could do the most basic “DELETE FROM…” all...
by XTIVIA | May 23, 2012 | Blog, Portals
I have been using Liferay EE 6.1 with OpenLDAP the past few days, using different testing scenarios for functionality and determining pitfalls. The goal was to test complete functionality, such as authentication, importing, exporting, and password policies,...
by XTIVIA | May 3, 2012 | Blog, Portals
Liferay has a robust service-layer API for developers to use. However, sometimes there are cases when you need to use methods in the internal Liferay API. You can’t use the internal API directly, but you can invoke it indirectly with the PortalClassInvoker...
