by Ken Haff | Dec 10, 2024 | Blog, SQL Server
EagerZero vs. Quick Format: A Comparison When it comes to formatting drives, there are different methods available, each with its own set of advantages and disadvantages. Two common methods are EagerZero and Quick Format. Here’s how they compare: EagerZero...
by XTIVIA | Sep 25, 2024 | Blog, SQL Server
Are you tired of the headaches of managing your SQL Server database on-premises? It’s time to consider the benefits of a cloud-managed solution. While both options have advantages, significant differences can impact a DBA’s day-to-day responsibilities....
by Ken Haff | Sep 24, 2024 | Blog, SQL Server
In SQL Server, the network packet size setting plays a crucial role in determining the data transfer efficiency between the server and clients. This deep dive explores the technical aspects of configuring the network packet size, including how TDS packets are wrapped...
by XTIVIA | Sep 19, 2024 | Blog, SQL Server
Encountering the “Login failed for user” error (SQL Server Error 18456) can be frustrating, especially when you are in the middle of a critical task. This error typically indicates an authentication issue that can stem from various causes. 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 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....
