Category: Queries

December 12, 2017
Getting Started with Power BI Desktop and SCCM

In this blog post I will show you how to connect Power BI Desktop to your System Center Configuration Manager (SCCM) SQL Server database. During the connection process I will…

November 15, 2017
How Can I Hide an SSRS Gauge in a Dashboard?

A super-cool feature with SQL Server Reporting Services (SSRS) is all of the available options for creating dashboards and reports! For example, did you know that you can hide an…

October 26, 2017
What Happened to the Tools Gauge in My SSRS Dashboard?

In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing…

October 11, 2017
Does SQL Server Database Compatibility Level Matter?

Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over…

October 5, 2017
Why is Using a SQL Server Alias for Column Names Important?

Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your…

August 16, 2017
What Are the Four-Part Names of a SQL Server Object?

By Garth Jones The purpose of this blog post is to help you identify the four possible parts of a SQL Server object. System Center Configuration Manager (SCCM) reports are…

July 19, 2017
Determine Who Is within the Domain Admins Group Using ConfigMgr

By Garth Jones During my presentation at the Midwest Management Summit in the Mall of America (MMSMOA for short) I demonstrated how to determine who is within the Active Directory…

July 13, 2017
Combining Two WQL Queries in One Collection

Garth Jones In a recent forum post someone asked for help with combining two WQL queries (see below WQL Query 1 and WQL Query 2) into one query. It is…

June 20, 2017
How to Add a User’s Office Location Details to a Report

By Garth Jones Fairly often I get asked, “How can I add a user’s office location details into a report?” The first question I always ask is, “Are you populating…

June 14, 2017
Five Tips for Query Designer

By Garth Jones In my previous blog post, Query Designer in SQL Server Management Studio (SSMS), I showed you how to access Query Designer (also known as Design Query in…