by XTIVIA | Aug 27, 2024 | Blog, Database
Organizations must prioritize safeguarding personal information in an era marked by increasing data privacy regulations and a growing public consciousness about data protection. The Privacy Impact Assessment (PIA) is a crucial tool in this endeavor. This blog post...
by XTIVIA | Aug 22, 2024 | Blog, SQL Server
The Role of the Persistent Version Store (PVS) The PVS is the heart of ADR. It acts as a dedicated storage area for data versions used for faster recovery. Imagine a timeline for your data – ADR captures snapshots at specific points in this timeline, allowing you to...
by XTIVIA | Aug 21, 2024 | Blog, Database
Our previous post discussed the critical importance of conducting a comprehensive risk assessment for your database management system (DBMS). A vital component of this process is selecting the appropriate risk assessment methodology. This blog post will delve into...
by XTIVIA | Aug 20, 2024 | Blog, SQL Server
Ad Hoc Distributed Queries (Ad Hoc Queries) are SQL queries that use the OPENROWSET or OPENDATASOURCE functions to connect to remote data sources, which use OLE DB. This allows you to query data from multiple data sources in a single query. For example, you could use...
by XTIVIA | Aug 15, 2024 | Blog, SQL Server
What is the ADR Cleaner Retry Timeout (min)? In SQL Server 2019 and later versions, Accelerated Database Recovery (ADR) employs an asynchronous cleaner process. This process runs periodically to remove unnecessary page versions, streamlining database recovery....
by XTIVIA | Aug 14, 2024 | Blog, Cloud
Understanding their security posture is paramount when entrusting sensitive data to a cloud provider. This blog post will delve into the various cloud provider security controls and certifications offerings, helping you make informed decisions. Understanding Cloud...
