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).
Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173
Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.