Write safe dynamic SQL with typed value parameters, validated object names, and allowed sort columns, then test hostile input.
Warning Before SQL Login Passwords Expire With DaysUntilExpiration
A Friday-night login failure is avoidable. One small query warns you weeks ahead, if somebody owns the warning.
Regaining sysadmin Access When Nobody Can Log In
Regaining sysadmin access starts with single-user SQL Server, a local sqlcmd connection, and a controlled Windows admin group.
Restoring a TDE Protected Database on Another Server
Restore a TDE protected database on another SQL Server by moving its certificate and private key, then verify encryption state.
Checking Certificates That Expire Soon in Every Database
Nobody remembers who created that certificate. Here is a short loop that lists every certificate expiring soon, and what to ask about each one.
A Multi-Tenant Schema With a TenantId Column: Keys, Indexes and Safety
Design a multi-tenant schema with composite keys, tenant-first indexes, trusted session context, and row-level security checks.
SQL SERVER – Importance of User Without Login – T-SQL Demo Script
A T-SQL demo script for a user without login: create the user, impersonate it, check its access, revert and then grant permissions, one step at a time.