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

Honored to be a Microsoft MVP

Today is the renewal date for Microsoft MVPs. I received an email a short while ago informing me that I was being awarded again for the July 2019 –...

It’s an Honor: Microsoft MVP

I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:

How to be an MVP Book November 28, 2018...

It’s an Honor: Microsoft MVP

I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:

Data Platform MVP 2020 August 12, 2020

How to...

Public Role Permissions – Back to Basics

If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...