DBA Scrolls - SQL Stories from the Trenches

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…

Not sure what to type here. I will introduce my self 😀. 8+ years of experience as MS SQL SERVER Database Administrator both Premise and Azure cloud (IaaS & PaaS). Certification nerd 🤓 4x azure and 1x GCP. Planning …