This book aims to improve the performance of your SQL Servers, how does it fare? The book discusses methods and tools, that can be used to identify and fix common SQL Server problems, using a ...

Advanced options should be changed only by an experienced database professional. Reconfiguring certain options invalidates plans in the plan cache, causing new plans to be compiled. For more ...

The world of the data professionals and DBAs is swirling with threats and risks, and those dangers are on the rise. You’re probably accustomed to using longstanding database fea­tures to secure your ...

Displays or changes global configuration settings for the current server. The maximum value depends on the individual option. To see the maximum value for each option, see the maximum column of the ...