XTIVIA BLOG
Add a Layer of Informix Security
I have been working with Informix for just over 15 years. This has caused me to stop, pause and think about all the changes in the industry that have happened in that time. Back when I started, databases were still small. Databases were maintained to aid users...
Oracle Linux Graphical Installation XenServer VM
If you have ever tried to install a Linux distro on XenServer you have probably run into the installation showing the non-GUI version. Which is perfectly useable, but sometimes it’s just faster and easier to click through the install. So how I get around this issue is during...
Creating an Oracle database using DBCA with the -silent switch
So at one time or another most of us have run into an issue where no matter what we install or try we just can't get a unix system to throw an x window for anything. Well I personally have run into this issue often enough that I thought I would throw together a quick blog about...
Large SQL Server Transaction Log While in Simple Recovery
Bloated Transaction log in Simple recovery mode will not shrink Received a request today from a Virtual-DBA customer asking XTIVIA to help troubleshoot why a database which is only 50MBs in size would have a transaction log of 181GB. My first thought fell to an open transaction...
Custom Buttons in an Editable Grid Quickform – InforCRM 8.x
Today we wanted to add several custom buttons (schedule activity and complete unscheduled activity buttons) in an editable grid. At first we thought about doing the usual convert to custom smart part, however that would have made simpler customizations down the road a little...
SQL Server Disaster Recovery Considerations
What you need to know about Database Mirroring In recent months I have set up database mirroring for a number of clients. Why you may ask? It is a great option for disaster recovery and even gives the organization additional options when it comes to maintenance times when...
Configure Multiple SlxJobService Instances on the Same Machine
In Infor CRM / Saleslogix 8.1 a lot of the operations are now performed in an out of process service called "Job Service" for improved performance. This is great because no longer does the web server need to be bogged down with bulk activity operations, report generation, etc....
Implementing A Drools Portlet
Overview Recently we put together a demo site for a prospective customer, and I was asked to create a couple of portlets using the Drools rules engine for personalization. Implementation The requirements called for one portlet to display the user's training level and a second...
Economic Principles for BI Programs
Economic considerations are at the heart of any business decision. They not only affect how we implement business intelligence (BI) solutions but also what we can do—and we give up other opportunities in the process of doing so. Here are three principles I have discovered...