DBA Scrolls - SQL Stories from the Trenches

Parallelism is a key feature of SQL Server that enables multiple processors to work on a single query simultaneously. By utilizing parallelism, you can significantly improve query performance and reduce query execution …

Certificates are an essential component of SQL Server's security infrastructure. They are used to protect sensitive data, secure connections, backups and authenticate users. In this article, we will explore how to b…

Transparent Data Encryption (TDE) is a feature of SQL Server that provides encryption at the database level. TDE encrypts the data and log files of a database so that sensitive information is protected from unauthorized…

Have you ever wondered why SQL Server generates new execution plans for queries even if there is no change in the SQL code? This phenomenon can cause performance degradation and impact database performance if not manage…

SQL Server is a powerful relational database management system used by businesses of all sizes. However, as your database grows, it is not uncommon to experience SQL blocking, which can significantly impact your databas…

As a database administrator, you know how important it is to have a streamlined process for backing up and restoring databases, table refreshing. This is especially true when restoring a production database to a lower e…