Trailing Spaces in SQL Server

Watch this week’s episode on YouTube. A long time ago I built an application that captured user input. One feature of the application was to compare the user’s input...

Behind the Scenes: How I Create Weekly Technical Videos

Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...

Behind the Scenes: How I Create Weekly Technical Videos

Watch this week's video on YouTube
Today I want to share my process for blogging and making weekly YouTube videos.
I've been hesitant to write this post because of how much...

Cool Stuff in Snowflake – Part 9: ILIKE

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...

Join a List of Values

There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:

Finding Data...

Power BI Interview Questions – Volume 02 – Data Shaping

Welcome to a brand new series that I have started with with Erin Ostrowsky [Blog | Twitter] that will focus on interviewing for a Power

T-SQL Tuesday #116 Invitation – SQL on Linux

Ever since Microsoft said SQL would run on Linux, I was excited.  Finally, all the Linux administrators I had worked with could be quiet and the Oracle DBAs that...

T-SQL Tuesday #116 Invitation – SQL on Linux

T-SQL Tuesday #116 Invitation – SQL on Linux

Continuous Learning

In case you can’t tell from some of my blog posts, I’m a bit of an advocate for DevOps. I’m extremely fortunate in my employer, Redgate Software, that they...