Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
Migrating Your AlwaysOn DR Node to a Different Location
There may be a situation when you need to move one of your servers that is part of an Availability Group to a different data center and the IP address for that server will change. In this example, we will be moving a DR node from one data center to another and change...
read more
The Pros and Cons of MongoDB
MongoDB is one of the world's most popular object-oriented NoSQL databases. But like any other database, MongoDB has specific places where it flourishes and areas where it falters. The Question: To Use Or Not To Use Some of the best ways to utilize MongoDB is when...
read more
Explaining the IBM-HCL Partnership
It's been a little more than two years since IBM and HCL Technologies entered into their 15-year partnership, but there's still a lot of confusion around their collaborative motives. Putting their efforts toward marginal software hasn't been a primary concern; rather,...
read more
Informix Error -908: Attempt to connect to database server (<dbservername>) failed
The Informix -908 error is returned when an attempted connection to an Informix server is unsuccessful. The vagueness of the message can be frustrating, but knowing what to look for can help to pinpoint the problem and resolve the connection issues. When setting up an...
read more
MySQL Error 1227 “Access denied; you need (at least one of) the SUPER privilege(s) for this operation”
Here at XTIVIA we have provided professional services many times to clients running into errors while restoring a MySQL database from a backup created with mysqldump. One specific error on import of a backup, Error 1227, reports "Access denied; you need (at least one...
read more
WSFC Fixing Errors for AlwaysOn Availability Group or AlwaysOn Failover Cluster Instances (SQL Clustering)
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum explaining them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for...
read more
Reducing the Use of TempDB to Keep Costs Down
There comes a time in everyone's life that they need to be concerned about tempdb. I know… we all have configured it correctly and it's running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing. Right?...
read more
Key Differences Between SQL, NoSQL, and NewSQL
Whether you pronounce it "S-Q-L" or "sequel," we interact with SQL, NoSQL, or NewSQL in one way or another everyday, but what exactly is the difference between them? The fact of the matter is that, although they're all types of databases, each one is very different...
read more