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.
Personally, I am biased. As the team lead for Db2 services here at XTIVIA, I think Db2 and other enterprise database software have significant advantages over some of the open source or free options out there. Decades of time invested and spent solving the problems of...
The most concerning issue with SQL Server merge replication is that it is not adequately designed to scale past a very small amount of subscribed instances. From a DBA's perspective, we find merge replication the least desirable of the Microsoft replication...
Sometimes when you're looking at Db2 Queries, you may notice question marks in your queries, like this: SELECT partnum, sum(quantity) as QUANTITY FROM orderitems oi INNER JOIN orders o ON oi.orders_id = o.orders_id where o.field3 is null and o.timeplaced is not null...
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....
What are Statistics? Statistics are exactly what the name implies. They are statistical information about the distribution and/or correlation of data in the first specified column of indexes or tables in the form of a histogram. Histograms measure the frequency of...
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum telling them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for AlwaysOn...
There may be a time where you install security patch MS15-058, and it shows that it was successfully installed, but the version does not change in SQL. The patch actually failed to install. Follow these instructions get to MS15-058 installed successfully and have the...
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...
This is a high-level description of the different High Availability Offerings in SQL Server 2016, meant to give a general idea of what is offered and the limitations for each offering. AlwaysOn High Availability Groups When most people use the terms AlwaysOn they are...
While there are many configuration options in SQL Server that can help tweak the performance when RAM or CPU is causing a slowdown, when the disk is the culprit, your options are much more limited. Assuming that best practices are followed in regards to file locations...