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 Kathleen Long | Jun 21, 2018 | Azure, Blog, SQL Server
Azure SQL has introduced the ability to set firewall rules at the database level. A database firewall is different than the server firewall which can be configured via the Azure Portal. The database firewall gives you the ability to not only limit connections at the...
by XTIVIA | Mar 19, 2018 | Azure, Blog, SQL Server
1. Sign Up for Azure Visit https://signup.azure.com and follow the steps to sign up for Azure. Requirements Microsoft Account Mobile Phone Credit Card 2. Visit the Microsoft Azure Portal Once completed with signing up head on over to the portal Visit:...
by XTIVIA | Aug 11, 2017 | Blog, SQL Server
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...
by XTIVIA | Feb 14, 2017 | Blog, MySQL
When a MySQL replica instance is no longer to be associated with a primary database instance in a replication design, the replica not only needs to be stopped, but the connection information pointing to the primary must be cleared as well. In older versions of MySQL...
