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.
SQL SERVER – Importance of User Without Login
Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
SQL SERVER – Beginning of SQL Server Security
The beginning of SQL Server security: how authentication, logins, users and permissions work together to keep your data safe from misuse.
Joes 2 Pros Exam Prep Videos from August 2012: SQL in Sixty Seconds
These Joes 2 Pros exam prep videos cover security, hierarchical queries, query hints, error actions and XML. Each lesson keeps its original video and adds a tested example on SQL Server 2025, from role permissions to a RECOMPILE hint that cut reads from 5,740 to 318.
Time-Limited Access: Expiring Grants With a Valid-Until Column
A ValidUntil column does nothing by itself. Here is how to make the read path enforce it, with a demo you can run.