Nice simple and basic question and a good reminder to boot, thanks Kendra.

My understanding is that Power BI Desktop is a free application that can be installed locally for use. However this cannot be used collaboratively, for that you need the Power...

Good question, nice reminder, thanks Steve.

Joining FK to FK directly will give you unexpected results, a many to many relationship would normally require an intermediate table, nobody knows what you are modelling, I suggest you do...

Think about relationships, Primary to Foreign is one to many, Primary to Primary is one to one, so think about what you need to join Foreign to Foreign?

Was he CURSing as...

Good question to end the week, thanks Steve.

Microsoft have, or at least had, a discovery tool which was designed to evaluate a network for licence true up purposes, it is (was?) a free tool, haven't used it...

Screen

Good question, thanks Steve.

+1

The answer is in the error message, your subquery needs to return only ONE value, ooops didn't see Johns response!