by XTIVIA | Mar 29, 2017 | Blog, Oracle
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...
by XTIVIA | Mar 14, 2017 | Blog, SQL Server
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...
by XTIVIA | Mar 14, 2017 | Blog, Db2, Informix, MongoDB, MySQL, Oracle, SQL Server
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...
by XTIVIA | Mar 14, 2017 | Blog, SQL Server
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...
by XTIVIA | Mar 11, 2017 | Blog, Oracle
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...
by XTIVIA | Mar 9, 2017 | Blog, SQL Server
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...
