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.
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...
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 (12.1.0.2.0) for...
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...
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,...
The Oracle ORA-01017: Invalid Username/Password; Logon Denied is an error that comes up pretty frequently it can be caused by several things, though most of the time it's simply just the wrong password being used. One thing that we should check if we're pretty sure we...
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...