The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1

(last updated: 2018-04-09)
In answering a recent question on DBA.StackExchange related to why some characters work for parameter names and others...

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)

If the new “CLR strict security” Server-level configuration option in SQL Server 2017 hasn’t caused enough confusion and pain, then,...

Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level

Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...

SQL# Version 4.1 is released!!

Version 4.1 of SQL# has just been released!

New functionality available only in Full version
Sys_LockResourceReturns the name of the specified Lock...

Server Audit Mystery 2: Filtering action_id gets Error Msg 25713

(last updated: 2018-06-05)
This post is, for the most part, a continuation of Server Audit Mystery 1: Filtering class_type gets Error...

Will GDPR cause a “Database Run”?

What is GDPR, everyone’s (current) favorite acronym? It stands for “General Data Protection Regulation” and is an act / law / set...

Server Audit Mystery 1: Filtering class_type gets Error Msg 25713

The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...

Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used

SQL Server stores the full definition of certain T-SQL objects — Stored Procedures, Functions, Views, and Triggers — in their original form,...

PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining

(last updated: 2018-03-27)
Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security,...