by XTIVIA | May 25, 2023 | Azure, Blog
As businesses increasingly move to the cloud, many are looking to migrate their on-premises databases to Azure. There are a number of reasons for this, including: Cost savings: Azure offers a pay-as-you-go pricing model, which can save businesses money on their...
by XTIVIA | Jun 20, 2019 | Blog, Cloud, Data Management, Databases
In the face of SQL Server 2008’s end of life, there’s been a lot of buzz around utilizing SQL Server on Azure Virtual Machine (VM). As one of the many ways of continuing support for your SQL Server Database, we’d like to elaborate on what exactly...
by Kathleen Long | May 1, 2019 | Blog, Databases
Security and compliance are two major issues facing users with service for SQL Server 2008\2008 R2 coming to an end. Once support ends, users will no longer have access to security updates to keep their system safe and maintain compliance for data protection...
by Kathleen Long | Mar 19, 2019 | Blog, Databases
The end is near for Microsoft’s servicing of SQL Server 20082008 R2; by July 9, 2019 Microsoft will have ended all support for 20082008 R2. It may seem unsettling, but there’s a lot you can do to prepare for the end of service (and increase your database...
by XTIVIA | Apr 21, 2016 | Blog, Databases
What is Lock Escalation? When LOCKLIST and MAXLOCKS are not set to AUTOMATIC, or total system memory is constrained, lock escalation can occur. When there is not enough room in the lock list to store additional locks that an application needs to continue processing,...
by XTIVIA | Apr 7, 2016 | Blog, Databases
It may be something that’s not terribly common to have to do, but that makes it all the more important that we document how to do it. Dropping a schema and all of the objects in that schema used to be tedious and time-consuming. We used to have to look for a...