by Kathleen Long | Jun 11, 2019 | Blog, Cloud, Data Management, Databases
SQL Server 2008\2008 R2’s retirement is inching closer; now is the best time to weigh your options and decide on the next course of action. Do you migrate your SQL Server database to an Azure environment or do you keep an on-premise system and upgrade to SQL...
by Brad Patterson | Nov 8, 2017 | Blog, Data Management
I often use the Informix Developer Edition for ARM on my Raspberry Pi for quick prototyping and proof-of-concept (POC) experiments as the Informix Developer Edition has all of the features of the full Enterprise Edition, including native JSON and Time Series...
by XTIVIA | Apr 13, 2016 | Blog, Data Management, Databases
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine...
by XTIVIA | Jan 27, 2016 | Blog, Data Management, Databases
Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total...
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 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 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 | Oct 28, 2015 | Blog, Data Management, Databases
To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is...
by XTIVIA | Oct 22, 2015 | Blog, Data Management, Databases
In order to connect to a DB2 database that is not on the server or workstation you’re connecting from, you’ll need to make DB2 aware of that database by cataloging it, unless you’re using JDBC type 4 drivers. JDBC type 4 drivers do not require that a...
