Page splits are an often-overlooked performance killer in SQL Server. In this article, we take a forensic look at how serial inserts differ from mid-table inserts, revealing why inserting rows out of order causes hidden page splits, increased IO, and fragmentation. Using a wide-column table, we demonstrate both scenarios and decode their impact with page-level analysis.
2025-09-02 (first published: 2025-08-05)
2,848 reads
When you run a CI/CD pipeline, you often need confidential values like passwords, authentication tokens, service principal secrets etc. when you want to deploy a certain artefact. You don’t want to store those secrets directly in your pipelines as this might pose a considerable security leak. Instead, you either store them as secret variables, or […]
2025-09-02 (first published: 2025-08-04)
1,530 reads
Power BI has the versatility that you can publish ...
2025-09-02 (first published: 2025-08-04)
1,114 reads
Large Language Models (LLMs) like Anthropic’s Cl...
2025-09-02 (first published: 2025-08-01)
2,270 reads
Most DBAs are familiar with full and differential ...
2025-09-02 (first published: 2025-08-01)
1,147 reads
