Kathi Kellenberger explains Table Valued Constructors, a relatively unknown topic, in the 52nd episode of my Notes from the Field series.
Audit Triggers That Record the Real User Behind EXECUTE AS
Your audit table says dbo for every change, and nobody can tell who really did it. Here is how to capture the person behind EXECUTE AS.
Extended Security Updates Explained
Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.
SQL SERVER – Tuning Queries is Sometimes Waste of Time – Notes from the Field #049
Brian Moran explains why tuning queries is sometimes a waste of time when you are trying to fix performance and scalability problems in SQL Server.
SQL SERVER – Building Technical Reference Library – Notes from the Field #048
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.