The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server

From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.

Finding a Database Master Key

SQL Server Certificates

Why Your SQL Permissions Disappeared

When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.

Changing the Schema

Secure Communications

Secure Cached Plans

Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation

A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly permissive permissions are combined.

Why disabling the SQL Server sa account still matters in 2026

Every few years, someone asks a familiar question: do we really still need to disable the sa account in SQL Server? After all, it’s 2026. SQL Server has better encryption, better auditing, better defaults, and more security features than ever before. Surely this old guidance belongs in the past?

Guarding Against SQL Injection at the Database Layer (SQL Server)

This article presents a way to check and validate input before using it in your dynamic SQL queries to prevent SQL Injection problems.