by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 9 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #9: Automatically Shrinking Your Database This is a topic that has been written...
by XTIVIA | Jan 7, 2016 | Blog, Customer Relationship Management
When you need to include a custom JavaScript in the InforCRM web client, the quickest way is to simply add the <script> tag to the base.master file. However this complicates upgrades because the base.master file is often modified in Infor’s web...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
by XTIVIA | Jan 7, 2016 | Blog, Databases
DB2’s Self-Tuning Memory Manager (STMM) was introduced in DB2 9.1. The default for new, single-partition databases was ON from the beginning. What is STMM? DB2’s Self-Tuning Memory Manager can allocate and change the size of specific memory areas including...
by XTIVIA | Jan 6, 2016 | Blog, Data Management, Databases
Ran into an issue today while installing a multi-user EBS Suite install using the latest startCD50. Thought I would share this to help some others if they run into the same problem. The error: Applying one-off patches Using...
by XTIVIA | Jan 5, 2016 | Blog, Data Management, Databases
Tip # 8 – Default TempDB Settings Top 10 Tips for SQL Server Performance and Resiliency This article is part 8 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is not all inclusive. Most common...
by XTIVIA | Dec 17, 2015 | Blog, Databases
Memory usage can be an issue for DB2 whether a server has 2 GB or 2 TB of memory. There can be issues with making DB2 use all of the memory, and there can be issues with DB2 causing paging or even kernel panics. Because of this, it is important to understand how much...
by XTIVIA | Dec 10, 2015 | Blog, Databases
Statistics are the most basic element of DB2 performance. One of the first questions any consultant or support person will (should!) ask you when you come to them with a query performance problem is when the last runstats was run for the tables involved. What are...
by XTIVIA | Dec 9, 2015 | Blog, Business Intelligence, Data Warehousing, Perspectives
What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it. Imagine business teams...
by XTIVIA | Dec 9, 2015 | Blog, Customer Relationship Management
The address control in InforCRM 8.2 (and other versions) is implemented as a semi-dynamic Javascript widget. I say semi-dynamic because while the widget is driven by configuration, the configuration is very much hard-coded. In this post I will examine how to do common...
by XTIVIA | Dec 9, 2015 | Blog, Data Management, Databases
Symptom: Very recently, using SqlDeveloper 4 Data Modeler I tried to pull and import schema object data (i.e tables) to create an Entity Relationship Diagram ERD from an Oracle database. After carefully going through the required steps, I kicked off the import...
by XTIVIA | Dec 2, 2015 | Blog, Customer Relationship Management
There are 3 main ways to include a custom stylesheet in your InforCRM client: Add it to SageStyles.jsb so that it gets compiled into sage-styles.css – this is the best performance approach. It is relatively upgrade safe but not completely Create a custom module...
