Category: Query

February 5, 2020
Why Am I Getting Incorrect Results in Visual Studio?

When I first encountered this issue, some time ago, I checked all of my queries in SQL Server Management Studio (SSMS) and guess what? As I suspected, the queries were…

September 18, 2019
How to Create a Collection for Workstations

This might seem like an odd blog post to write. Why not simply search for all workstations with “Windows 7%” and “Windows 10%” in your query? Once you have this…

August 21, 2019
No Rows – What It Is and Why You Should Use It

Instead of showing empty report sections because a query produced no results, I wanted to add some text to explain the outcome. I turned to an option called, No Rows,…

July 30, 2019
Visual Studio Code

You know how life gets busy and you never seem to have any time for smaller projects? Well, am I ever grateful to Julie Andreacola who reminded me about Visual…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

What do I mean by, “Setting up security for SCCM Power BI reports?” First, in order to create and run Power BI reports, you need to access the SQL Server…