SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?

(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...

Enable Group Policy Editor (gpedit.msc) on Windows 10 Home Edition

Occassionally I want / need to change a Windows setting that is not configurable via Control Panel or Settings. For example:
Enabling...

What’s in a Name?: Inside the Wacky World of T-SQL Identifiers

(last updated: 2018-04-28)
Today we are going to take a look into an area that you probably are thinking has very...

The Uni-Code: The Search for the True List of Valid Characters for T-SQL Identifiers, Part 3 of 2 (Delimited Identifiers)

(last updated: 2018-04-18)
This is Part 3 of 2. Yes, you read that correctly. You see, way back at the very...

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

(last updated: 2018-04-28)

Recap
In Part 1 of this 2 part series, I started with the loose definition in Microsoft’s documentation for...

Why Doesn’t CONTEXT_INFO() Return the Exact Value Set by SET CONTEXT_INFO?

(last updated: 2019-01-05 @ 23:15 EST / 2019-01-06 @ 04:15 UTC )
Let’s say that you execute the following T-SQL:

SET CONTEXT_INFO 1234;
SELECT CONVERT(INT, CONTEXT_INFO());
The...

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,...

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,...