SUMMARY: XTIVIA’s expert database administrators (DBAs) prevent massive cloud SQL Server budget overruns by deploying optimization techniques like query rewriting and configuration tuning, moving beyond the costly and temporary fix of blindly provisioning more...
SUMMARY: Since its debut in 2016, SQL Server Query Store has gained critical features such as wait statistics and automatic plan correction, evolving from a simple logging tool into an adaptive performance tuning partner that minimizes rogue query performance issues...
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 Format...
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. Let's dive into...
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...
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 will explore...
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...
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...
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....
SQL Server Ledger is a powerful feature that provides tamper-evident capabilities for your database. It addresses the critical need for data integrity and trust, especially when financial, medical, or other sensitive information is at stake. Here are some key points...