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.
Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
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.
Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
Let us see a quick workaround in this blog post about an error related to Database Giving Error While Setting Single_User Mode.