For SQLCLR in SQL Server 2017 and newer, when "CLR strict security" is enabled, does PERMISSION_SET matter, or are assemblies always UNSAFE?
Tag: Documentation
Official Microsoft documentation that is incorrect and/or incomplete and/or misleading. Identify and explain the issue(s), and then correct / improve the documentation on GitHub (link). Please see the “Documentation Corrections” page (under “Projects“) for the complete list of documentation updates, including updates that do not have a corresponding post.
Changing the Collation of the SQL Server Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Need to change the collation at ALL levels? Prefer to avoid reloading all objects and data? Learn what the "sqlservr -q" option does, and doesn't, do.
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)
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
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 2
The Uni-Code: The Search for the True List of Valid Characters for T-SQL Regular Identifiers, Part 1
SQLCLR vs. SQL Server 2012 & 2014 & 2016, Part 7: “CLR strict security” – The Problem Continues … in the Past (Wait, What?!?)
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) :-)