by Marc Petros | Feb 27, 2024 | Blog, Databases
Setting up a lab environment on your local machine to run CockroachDB is very helpful for learning about this exciting database platform and testing applications locally. This article outlines the procedure for setting up a local installation of CockroachDB on a...
by XTIVIA | Jun 21, 2023 | Blog, Cyber Security, Databases
Zero Trust Network Access (ZTNA) is a security framework designed to protect modern networks from security threats by adopting a model that treats every user, device, and application as untrusted. In a traditional security model, the perimeter of the network is...
by XTIVIA | May 25, 2023 | Azure, Blog, Cloud, Microsoft
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...
by XTIVIA | Feb 17, 2016 | Blog, Databases
Abstract Upgrading or migrating your SQL Server can seem like a very daunting task. And it certainly can be especially when we start to look at hardware requirements, size and space needs, time constraints, and the numerous impacts to the the users and applications...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
