Tag Archives: T-SQL

Finding the First Day of the Year–#SQLNewBlogger

Posted on January 5, 2022 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. While working on the question from Monday, I had to do a bit of date math. I remember this … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

2021 Advent of Code–#SQLNewBlogger

Posted on December 10, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ll do a post on how to easily get started here as a new blogger, but following the Advent … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on 2021 Advent of Code–#SQLNewBlogger

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

Posted on November 29, 2021 by way0utwest

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 , , | Comments Off on Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

STRING_SPLIT Has Ordinals

Posted on November 17, 2021 by way0utwest

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