Let an LLM query SQL Server through a restricted login, approved views, enforced row filtering, execution limits, and query auditing.
SQL SERVER – Login Experience with DEFAULT_DATABASE and MUST_CHANGE
DEFAULT_DATABASE and MUST_CHANGE shape the login experience. Tested on SQL Server 2025: the syntax that fails, and how the two lock a user out.
SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist
One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal.
Logon Storms: Protecting SQL Server From Connection Floods
Diagnose SQL Server logon storms, control connection growth, test a limited logon trigger, and preserve administrator recovery access.
SQL SERVER – Change Password at the First Login
Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.
CHECK_POLICY and CHECK_EXPIRATION for SQL Logins
Audit CHECK_POLICY and password expiration for SQL logins, inspect LOGINPROPERTY evidence, and plan safe service-account exceptions.
SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.