by XTIVIA | May 30, 2017 | Blog, MongoDB
MongoDB ServerStatus is the main command used to produce a huge document containing important metrics and information about your database. When performing a health check, there are several important keys that you’ll want to be aware of inside serverStatus. The...
by XTIVIA | May 18, 2017 | Blog, MySQL
At XTIVIA, we have encountered the MySQL Error 1114, “table is full” on quite a few occasions. The description for the error is usually misleading as it implies that a table has reached or exceeded a maximum set limitation. Tables utilizing the InnoDB...
by XTIVIA | May 16, 2017 | Blog, SQL Server
SQL Error 18456 is likely the most common error one will encounter using SQL Server. Error 18546 isn’t only commonplace, but also ambiguous. Generally, Error: 18456 is a result of a login failure. Follow the steps below to try and resolve the issue. Are you connecting...
by XTIVIA | May 11, 2017 | Blog, SQL Server
Obtain the Oracle client binaries from Oracles site http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-win64-download-2297732.html Click on “Accept License Agreement” For 32 bit: Look for “Oracle Database Client...
by XTIVIA | Apr 4, 2017 | Blog, SQL Server
I was recently given a task to move a few multi-terabyte databases inside of an availability group from SAN A to SAN B within a 10-minute window. The good news was there was plenty of time to plan and prepare. For the purpose of this example, I will be using a very...
by XTIVIA | Mar 30, 2017 | Blog, SQL Server
Replicating Indexed Views as tables, instead of replicating all base tables and then creating an indexed view against those base tables, allows for a smaller subset of data to be replicated over. If you replicate base tables and then create an indexed view,...
