by XTIVIA | May 6, 2015 | Blog, Data Management, Databases
Tip # 6 – Change History, Top 10 Tips for SQL Server Performance and Resiliency This article is part 6 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 mistake...
by XTIVIA | Apr 28, 2015 | News
XTIVIA, Inc. Acquires HYDUS, Inc. Colorado Springs, CO, April 28, 2015 –(PR.com)– XTIVIA, Inc., a leader in professional information systems solutions announced today the acquisition of privately held HYDUS, Inc., an Enterprise Information Management...
by XTIVIA | Apr 2, 2015 | Blog, Customer Relationship Management
For Infor CRM / Saleslogix SData is the key technology on the server side that enables us to build rich client side applications. Single-page applications are all the rage now and with sdata they can communicate with the Saleslogix database without the need to build a...
by XTIVIA | Mar 4, 2015 | Blog, Data Management, Databases
This article is part 5 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 mistake #5: Not Setting a Maximum Memory Default configurations are not always the best...
by XTIVIA | Feb 26, 2015 | Blog, Data Management, Databases
This is a pretty common error and there are a few reasons you might be seeing this error. 1. The database could simply be down. If you’re on *nix platform you can simple check this by a simple ps -ef | grep pmon. If this returns ora_pmon_<instance_name>....
by XTIVIA | Feb 26, 2015 | Blog, Perspectives
This article is part of an ongoing series. See the blog entry Delivering Your Enterprise: The ilities for an overall discussion. Process. It’s wonderful for the people who define it and somewhere along the spectrum of obnoxious, confusing, and comforting for...
by XTIVIA | Feb 25, 2015 | Blog, Data Management, Databases
Problem Description A working federation environment – querying an 11gR2 Oracle database from a DB2 10.5 FP4 database – suddenly started returning error ORA-01013. Four minutes into each statement, the following error was returned: SQL1822N...
by XTIVIA | Feb 12, 2015 | Blog, Data Management, Databases
Click to download full Oracle Error eBook A very common Oracle database error that is basically telling you that you have run out of logical or physical space on the mount, disk, or your db_recovery_file_dest location that holds your archivelogs. When you get this...
by XTIVIA | Feb 11, 2015 | Blog, Data Management, Databases
MySQL creates a default configuration file named my.cnf (or my.ini in Windows), that can be edited to include and fine tune the startup options to meet the needs of your environment. This is often more convenient than entering these values every time you start the...
by XTIVIA | Feb 11, 2015 | Blog, Data Management, Databases
The sys.database_role_members view contains two columns one for the role id and one for the member id creating a relationship between the role and the user. When we join this data to the sys.database_principals view we can retrieve the friendly name of the role and...
by XTIVIA | Feb 10, 2015 | Blog, Data Management, Databases
ORA-01555 Snapshot Too Old The snapshot too old error is a very common error we get asked about on a regular basis. It’s also a pretty simple error to avoid if you know what to look for and how to configure your queries and the Oracle database. The error is basically...
by XTIVIA | Feb 5, 2015 | Blog, Data Management, Databases
DB2’s automated maintenance does not currently allow us to automate inplace reorgs. Inplace reorgs are more online than other reorgs, and in my experience are heavily used. This means that many DBAs wrap some sort of scripting around reorgs. Working in a variety...
by XTIVIA | Feb 4, 2015 | Blog, Data Management, Databases
This error comes up pretty often and can be caused by a lot of different things. Usually, this is a pretty easy one to solve. It’s mostly just a syntax error and you forgot part of your SQL statement. You need a select, a column, from clause, and optionally a...
by XTIVIA | Feb 3, 2015 | Blog, Data Management, Databases
Tip # 4 – Not having a Baseline Top 10 Tips for SQL Server Performance and Resiliency This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors...
