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,...
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...
