Brian Kelley explains how to build a technical reference library: your own notes, code, settings and bugs you have hit, so help is always close at hand.
SQL SERVER – A Practical Use of Backup Encryption
A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.
Reading Connection Details in Code: APP_NAME, HOST_NAME and Logins
An audit row blamed the wrong machine because a label was treated as proof. Here is which connection values you can trust, and which you cannot.
SQL SERVER – Finding Out What Changed in a Deleted Database – Notes from the Field #041
What changed in a database that no longer exists? Brian Kelley shares a real story on finding out what changed in a deleted database.
Finding Databases Owned by Personal Logins and Fixing Them
Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.
Block Predicates: Stopping Writes Into Another Tenant’s Rows
A filter predicate hides rows but does not stop a bad write. Here is how block predicates close that gap, with a demo you can run.
Login vs User in SQL Server: Who Gets In, Who Can Do What
Login vs user is a question of authentication and authorization in SQL Server. A login lets you into the instance, and a user gives you rights inside one database. This post builds both on a demo database, shows the errors that appear when one is missing, and explains how they map.







