The investigation into valid T-SQL identifier characters continues. Apparently I was not done.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
Tag: T-SQL
Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?
If you have ever used SET CONTEXT_INFO to store a simple value, you probably ran into this frustrating behavior 🙀
What’s in a Name?: Inside the Wacky World of T-SQL Identifiers
Come see the complete set of rules governing how you name things in SQL Server
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
A captivating journey of twists and turns, searching for the mythical list of valid T-SQL identifier characters.
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level
Come see how easy it truly is to "grant" high-level permissions in the safest, most granular, most controllable way.
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Come see how easy it truly is to "grant" high-level permissions in the safest, most granular, most controllable way.
Server Audit Mystery 2: Filtering action_id gets Error Msg 25713
Server Audits allow filtering on certain fields. Two fields claim to be strings, yet don't accept strings for filters. Here's how I figured out filtering on action_id (i.e. the event) :-)
Server Audit Mystery 1: Filtering class_type gets Error Msg 25713
Server Audits allow filtering on certain fields. Two fields claim to be strings, yet don't accept strings for filters. Here's how I figured out filtering on class_type (i.e. object type) :-)
Stored Procedure / Function / View / Trigger Definitions Can Be Wrong, Even If sp_rename Was Never Used
Some object definitions will be wrong after using sp_rename. But there's another way to have an out-of-sync definition that most are unaware of.
