Tag Archives: T-SQL

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Dynamic Data Masking is a feature that provides some pseudo-security features. This lets you return a portion of data … Continue reading

Posted in Blog | Tagged , , | Leave a comment

STRING_SPLIT Has Ordinals

I noticed the docs for STRING_SPLIT now show that there is a third parameter. This brings us an ordinal for the positioning of the data. The format is now: STRING_SPLIT( string, separator [, enable_ordinal]) This is a bit or int … Continue reading

Posted in Blog | Tagged , | 1 Comment

STRING_SPLIT Basics–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post on using STRING_SPLIT() with cross apply recently, and as I was reading, I realized that … Continue reading

Posted in Blog | Tagged , , | 1 Comment

T-SQL Tuesday #143 – Short Code

I’m late, but I wanted to get this out. I started the post, then got distracted with travel to Europe late last week. In any case, this month the host for T-SQL Tuesday is John McCormack, with his invite to … Continue reading

Posted in Blog | Tagged , , | Leave a comment