The LPIM memory model tells you whether SQL Server runs with locked pages. This post reads it from sys.dm_os_sys_info in one query, confirms it with the process memory view and the error log, and explains what each value means.
User Statistics Report in SSMS: Who Is Connected
The User Statistics report in SSMS shows the users who are connected to a database. This post opens the report, answers the same question with a query over sys.dm_exec_sessions, and finds the one application that holds many sessions.
Restore From LDF File Only: Why It Fails and What Works
A restore from LDF file only is not possible, because a log holds changes and not the database. This post answers five common questions, shows the error SQL Server gives, and restores a database from a full backup, a log backup and a tail-log backup.
HAS_DBACCESS Function: List the Databases You Can Open
The HAS_DBACCESS function tells you whether the current login can open a database. One query over sys.databases turns it into a list, and this post tests six databases to show what each zero means: no user, offline, restricted or a busy single user slot.
Activity Monitor Keeps Freezing: Fix WMI and Permissions
When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.
Authentication Mode Greyed Out in SSMS: Read the Real Value
An authentication mode greyed out in SSMS means the Security page can’t show the value it reads. This post reads the real mode with SERVERPROPERTY, with the registry value SSMS uses and with the error log. It also explains what the two valid values mean and how a bad value is repaired.
SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326
In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.