Category: SSMS

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…

July 10, 2019
RBA and Non-RBA Queries: When is Slower Actually Faster?

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently…

June 12, 2019
MP Function Error After Re-Attaching the SCCM Database

As I write this blog post, I am sitting in my hotel room after a long day of Midwest Management Summit at the Mall of America (MMSMOA) sessions. Here I…

March 13, 2019
How to Add a Dynamic Image into a SSRS Report for SCCM

How many times have you wanted to make your System Center Configuration Manager (SCCM) SSRS reports quickly convey a small piece of information? Adding a dynamic image might be exactly…

February 20, 2019
Step by Step Guide on How to Setup the SCCM Data Warehouse Feature

This blog post is a step-by-step guide to help you with the setup of the new data warehouse service point feature in System Center Configuration Manager (SCCM). What is the…

July 11, 2018
Seven Tips for Writing SCCM Dashboards

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…

June 27, 2018
How to Start Editing SCCM Reports with Report Builder

Did you know that you need a Role-Based Administration (RBA) security role when you want to edit System Center Configuration Manager (SCCM) Current Branch or 2012 R2 reports with Report…

June 6, 2018
Updated-How to Create a SQL Server Computer Account Login

This blog post was originally published in early 2017, but since then newer versions of SQL Server were released, so I thought that it was time for an update. Here…

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…