Queries

This blog post is really meant for those who are better at writing SQL Server queries than at writing PowerShell scripts. I am one of those people, so recently I…

Have you ever watched someone use one of your reports/dashboards? I have and it is always fascinating to see how someone will review the data. If they have prior experience…

Little things do make a difference and this is especially true when it comes to SCCM reports. Oftentimes in my report writing sessions I don’t have time to show folks…

At the last Midwest Management Summit which was held at the Mall of America, I was stopped in the hallway after one of my SCCM reporting presentations. I was asked…

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…

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…

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…

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…

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…

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…