XTIVIA BLOG
Top 10 Things to Know Before Starting Statistical Analysis
1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential techniques allow us to estimate and draw conclusions about populations from samples 2. Data can be formally categorized in three categories...
Automatic Resizing InforCRM Detail Area for Small Screens
Wanted to share a small trick I used to make Infor CRM / Saleslogix more usable on laptops, especially if you have customized screens that are very tall. On devices with a low resolution height, tall screens can push the resize handle low enough that it can't be reached, and...
Renaming an Oracle Database when using ASM 12c
There might be better ways to do it, though this is how I renamed a database when asked to do so...Hope it helps someone out. Make sure Oracle env is set ORACLE_HOME ORACLE_SID sqlplus / as sysdba create pfile from spfile; exit Create a full database backup just in case you...
Adding Users in SQL Server after Moving a Database
When a database is moved to a new server, existing database users will not have access to the database on the new server. Attempting to add the users to the database on the new server results in an error message saying the user already exists in the database. To fix this you...
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...