by XTIVIA | Dec 12, 2017 | Blog, SQL Server
The SSIS subsystem failed to load When this error is received the initial response is to look into SQL Server Integration Services, however this error can occur on systems even when no SSIS is installed. The subsystems are actually related to the SQL Server Agent....
by XTIVIA | Aug 3, 2017 | Blog, SQL Server
Have you ever applied a patch to find that the server or service does not start after it was applied? There is nothing worse than working in a maintenance window trying to get services back up as quickly as possible when suddenly SQL will not start. Knowing that your...
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 Tori Aubé | Mar 23, 2017 | Blog, SQL Server
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...
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 Kathleen Long | Dec 2, 2016 | Blog, SQL Server
A Foreign Key is a constraint. Due to this definition, it only places a limitation on what data can be inserted into a column(s) and does not address the indexes needed to help performance when joining tables Take the following design. If you wanted to join the 2...
