XTIVIA BLOG
The Power of Set Operations in SQL Server
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 at once....
Liferay, LDAP, Groups and empty AttributeDescription
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, implemented at...
Calling Methods in the Internal Liferay API
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 class. Caveat: Use of...
Using Pentaho Data Integration for migrating data from DB2 to SQL Server
This is a short video on how you can use an open source tool called Pentaho Data Integration to migrate data between tables in DB2 and SQL Server. This video is on youtube and walks through downloading the open source code, setting up database connectivity, building the...
DBA Insurance?
Insurance: what you need is generally a balance between type, amount, cost, and where you can find it. Everyone of course has different advice on what is optimal. Best bet is to always get that which will keep you safe, you can afford, and from someone you can...
Challenges of Deploying WARs on Liferay Running on Amazon’s AWS
So you have Liferay running merrily up on Amazon's AWS, things are going well, and you decide you wish to add a new feature, such as perhaps the WSRP portlet. (Because this is a Liferay supported portlet, available from the trusted repository, is known to deploy successfully,...
Jack Bauer, DB2 DBA
Well, I'm in the final 4 and I made my last presentation on the DB2Night Show's "DB2's Got Talent Contest 2012" last week. I wanted to make it a fun and 'edutaining' presentation so I chose to do a parody of the American TV show "24". In the show Jack Bauer is a...
Configuring Liferay 6.1 EE as SAML Identity Provider and Service Provider
We are seeing significant interest from our Portal clients in enabling Single Sign-On (SSO) not only within their enterprise, but also with their customers and partners. In some cases, this need is becoming an expectation of our clients' customers - in other cases, when our...
Today is the last chance to vote for me in Round 2.
Hello everyone, Today is the last chance to vote me into the top 3 of this DB2 presentation contest. If you could take 10 seconds and go to this link and vote, I'd really appreciate it. It has to happen today!! You don't need to watch the presentation,...
The Woes of Deploying a Portlet on Liferay 6.1/JBoss 7.0.2 With Slf4j Dependencies.
So you've developed a portlet, perhaps using the latest displaytags taglib, version 1.2. You have your portlet project being built via Maven, and you are deploying locally on the Liferay EE 6.1 Tomcat bundle. Life is good, all goes smoothly, and you are excited to now demo your...