There are many times I wished SQL Server had native T-SQL support for regular expressions.

Without it, I often resort to writing queries that work just good enough for the dataset.

Bullet-proof is almost impossible.

(And, yeah...I'd probably end up pulling my hair out trying to find the magic RegEx pattern matching string. But still.)

#SQLServer
#TSQL
#RegEx

Things I Learned: clustered columnstore indexes are not supported on tables with triggers. ☹
#SQLServer

https://stackoverflow.com/questions/61901482/create-trigger-on-a-table-with-clustered-columnstore-index-error

I made this with #PowerBI today.
It shows the inter-database relationships between three different #SQLServer hosts.