Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
SUMMARY: When configuring an SSIS OLE DB connection in Microsoft Visual Studio 2015 fails to correctly register the 'Connect Timeout' setting of 0 (unlimited), administrators must utilize specific workarounds—either within the Connection Manager or through an XML...
There are situations where you would want to change the Windows cluster configuration so a failover does NOT occur. Failovers can occur due to quorum (error: The Cluster service is shutting down because quorum was lost) can't be reached for a short period of time when...
Ahhhhhh—the fresh smell of a brand new laptop, being pulled out of its box for the first time. Breathe it in. Your tax return really paid off this year, but your shopping doesn’t end with this new device. On the contrary, you’ve got a spree ahead of you. This laptop...
SQL Server Statistics are small, lightweight objects that describe the distribution of data in a SQL Server table or column. The SQL Server query optimizer uses statistics to estimate how many rows will be returned by parts of your query. This heavily influences the...
When you see this ORA-12560 error on Windows, you need to check these two things before anything else. Make sure the windows service is up and running Make sure your ORACLE_SID is set to the instance name you're trying to connect to If either one or two are not...
Have you ever run into an SSPI error in SQL Server Management Studio (SSMS)? In this blog entry, we will show you 2 ways you can fix your SSPI error in SQL Server. SSPI Error: Cannot connect. The target principal name is incorrect. Cannot generate SSPI context Details...
Most Db2 DBAs administer Db2 at the command line. The command line provides a rich and powerful interface with Db2, and has a lot of options. Many other users may wish to access Db2 at the command line as well. Developers and system administrators are just a few of...
This error is rather common; however, the following error is the error that needs to be resolved. Below you can see several of these errors and their associated error that needs to be resolved. Each of the following errors has their own resolutions. Here the variable...
When changes are made to InnoDB tables in MySQL, the changes are first stored in memory in the InnoDB log buffer, then written to the InnoDB log files which are often referred to as the redo logs. The innodb_log_buffer_size variable may be adjusted to optimize...
Learn with XTIVIA how to address the common MySQL Error, "Too many open files." If you encounter the error where MySQL reports "Can't open file: (errno: 24)", analyze a few variables. The error usually occurs when the maximum number of files that may be open...