Category: How-To

March 25, 2020
How to Match the Colors in a SSRS Chart and Table

This is the third and final blog post of a three post set that shows you how to create a color palette code, how to use it in a chart…

March 19, 2020
How to Use GetColor in a SSRS Chart

This is the second blog post of a three-part set that shows you how to create a color palette code, how to use it and then how to match the…

March 11, 2020
Color Palette Codes in SSRS Defined and Explained

This blog post is the first in a three-part set on how to create, use and synchronize color palette codes when using a chart, a table or a matrix in…

February 26, 2020
How to Install Power BI Report Server 2019

In order to keep my Microsoft Endpoint Manager Configuration Manager (MEMCM/SCCM) reporting guides current, I decided to write blog posts about how to install SQL Server 2019 and Power BI…

February 19, 2020
How to Install SQL Server 2019

With the release of SQL Server 2019, I thought that I would create a blog post on how to install it. This way my blog posts about reporting in System…

February 12, 2020
Unexpected Power BI Results? Turn Off the Keep All Filters Option

Let me begin by telling you how I ended up writing this blog post. It all started when one of my first Power BI report sets was still in development….

January 29, 2020
How to Hide Unused Rows in a Tablix

Hi All! I’m sure that each and every one of you have used a Tablix at one point or another when creating SQL Server Reporting Services (SSRS) reports. All rows,…

January 15, 2020
Add Tables to the ConfigMgr Data Warehouse

Back in October, I was asked via Twitter, what tables (apart from the default ones) do I add to my Configuration Manager (ConfigMgr/SCCM/MEMCM) data warehouse? That was a great question…

January 8, 2020
Configuration Manager Maintenance Tasks

The beginning of the year is a great time to check your Configuration Manager (ConfigMgr/SCCM/MEMCM) environment to ensure that everything is working smoothly. We all know that we should be…

December 24, 2019
Top 10 Configuration Manager Posts in 2019

With the end of 2019 in sight, I thought it would be useful to look back and see what posts were the most popular this year. After reviewing the posts,…