ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.
SQL SERVER – What is Instance Hiding? How to do it?
In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.
SQL SERVER – Monitoring Database Autogrowth Settings
Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;
SQL SERVER – Setting up a Robust Password Policy
Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.
SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
SQL SERVER 2022 and Instant File Initialization for Log File
This blog post will explore how Instant File Initialization for Log File growth events in SQL Server 2022.
CLR Integration in SQL Server: When It Still Makes Sense
Review CLR integration uses, inventory existing assemblies, preserve strict security, and compare SQL Server 2025 built-in alternatives.