XTIVIA BLOG
SQL Server Buffer
Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it? There is a reason for this and most likely it is caused by your buffer. When your SQL Server starts...
Versioning for Talend Open Studio
Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you have it...
Salesforce Advanced Developer Certification
Having set out on the path to the Salesforce Advanced Developer Certification about 2 1/2 years ago, it was a huge relief when I finally got the "Success" result today! This certification is not an easy one (which is good since that makes it all the more meaningful). It is in 2...
Working with SQL Server Error Log
Often when I am requested to look at an issue with SQL Server I have to spend some time in the error log. On a side note, I think the log itself is a commonly overlooked tool for troubleshooting. Often it can be a bit cumbersome to work with if the default settings are used....
Informix Listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process
Environment: Informix 11.50 FC3 / AIX 6.1 Genero BDL 2.11.03 / Genero GDC 2.02 / License Manager 5.15. Error: Listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. One of our Virtual-DBA clients called to...
Detachable Sessions For Oracle expdp/impdp
So I wanted to throw a quick reminder out there of a nice feature that came along with Oracle 10g and datapump exports and imports. The feature I’m referring to is the ability to detach and reattach to export and import jobs. To detach from an export or import you simply hit...
Query your SQL Server Error Log
Often the things I post about are the items that I am using that day, or recently. Many of the topics, are simply based on how I may have made using SQL Server a bit easier for me to use one way or another. In another SQL Server Error Log post I had mentioned a few of the basic...
Test That Database Backup
Are you testing your database backups, If so how? Sure there are a couple options that you can use to help validate backups but does this mean you are 100% sure, without a doubt, that it can be restored? Have you ever seen a backup file not restore? Recently I was working with...
How to Create OCM Response File for Oracle Grid Infrastructure Patching
So tonight we were helping a Virtual-DBA client apply an PSU patch for an ASM/GI Oracle home. It's a bit different in the fact that you use opatch auto instead of opatch apply or napply. You also need an OCM response file before you can run opatch auto. First you need to export...
Troubleshooting Liferay EhCache clustering setup on WAS 8.x
We recently came across an interesting issue in Liferay. One of our clients was trying to cluster Liferay instances using the ehcache-cluster-web (Ehcache Cluster EE.lpkg) application downloaded from Liferay Marketplace. Liferay instances were running fine with no issues....