by XTIVIA | Sep 27, 2018 | Blog, SQL Server
AlwaysOn Availability Group (AG) is one of my favorite features in SQL Server and is worth considering when using SQL server 2012 or greater. One of the nicest features in AlwaysOn AG is that in a single subnet environment it can be totally transparent to your...
by XTIVIA | Jul 31, 2018 | Blog, SQL Server
What do you do when something that has been working for months suddenly stops working and gives you a SQL Error 8623? Worse yet, what do you do when that error message tells you to either rewrite your extremely complex query or spend some cash on a Microsoft customer...
by XTIVIA | Jul 26, 2018 | Blog, SQL Server
Many people have heard that the traditional DBA role is changing. This is one of the hottest topics out there right now. One way that Microsoft is moving forward with this way of thinking is SQL Operations Studio (SOS). When it was first released in preview mode, many...
by XTIVIA | Jun 7, 2018 | Blog, Db2
How Db2 Handles SQL SQL is a powerful language in the hands of the right RDBMS. One of SQL’s strengths is that you specify what data you want returned without specifying what file, disk, san, or sector that data is stored on. Because we describe the result set...
by XTIVIA | May 30, 2018 | Blog, SQL Server
Connection Error Details While attempting to make an RDP connection to another Windows client the following error may be encountered. Typically this error is encountered when attempting a connection to an Azure hosted client, it has also been encountered when...
by XTIVIA | May 10, 2018 | Blog, SQL Server
For some time now, SHA-1 has not been allowed to be issued from CA’s with few exceptions. This was due to a large catalog of evidence suggesting that SHA-1 was less secure than acceptable. Starting with SQL 2016 self-signed certificates are issued using SHA-2,...
