Execute on DMVs without user having View Server State

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

The Last Compile Time

Finding Perfmon Data

Correcting Server Memory

SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos

Learn how to correct an error that is overloading SCOM by fixing an SPN.

Moving on from syslanguages

Using Recommendations for MAXDOP and Max Memory During Installation

Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation. MaxDOP When an instance of SQL […]

Setting Server Memory

Getting File System Volume Info

Replacing sysconfigures