Tips & Tricks
Clean and Build – How It Saves Me Money
In my original draft of another blog post, How to Add the Total Number of Rows in a SSRS Table, I wrote an entire section on the Clean and Build feature within Visual Studio. In it, I explained why I thought it was important to perform this extra step. Well, the blog...
Tips for Perfectly Matching Colors in Your RDL Chart and Table
This is final blog post in set for GetColor and Color Palettes. This set shows you how to create a color palette code. How to add it your RDL then how to use it in a chart. This post will show you how to perfectly matching colors in your report chart and...
Unleashing the Power of GetColor Advanced Techniques for PBRS Chart Customization
This blog is the continuation of “How to Utilize Color Palette Function in PBRS for Stunning Visualization”. I will show you how to unleashing the power of GetColor advanced techniques for PBRS chart customization. Thereby allowing your report to be on brand. If you...
How to Utilize Color Palette Function in PBRS for Stunning Visualization
I’m updating my blog post to create a color palette for Ask Garth logo. So, I thought that I would show you the Power BI Report Server (PBRS/PBIRS) or SQL Server Reporting Services (SSRS) function that I use. This function will allow me to apply a defined color...
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 Report Server 2019. Power BI Report Server is a pseudo-replacement for SQL...
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. The question was asked, “Why are the drillthrough filters italicized?” It may not seem like it, but this is an...

How to Create RDP Certificates?
Don’t you love it when you find that you never publish an old blog! This was originally created in 2022 but I have published. My question is why didn’t I shave before doing the video. Anyways here it is now. As you might have known I recently being working on a set or...
How to Create RDP Certificates?
Don’t you love it when you find that you never publish an old blog! This was originally created in 2022 but I have published. My question is why didn’t I shave before doing the video. Anyways here it is now. As you might have known I recently being working on a set or...
How to Code Sign PowerShell
There is a very long story about PowerShell, ConfigMgr, Jeffrey Snover, and me. The short version is that story is that I’m getting to use PowerShell to its fullest now. In today world, a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) administrator must...
How to Create a Code Signing Certificate
Where to start with this article. As a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) administrator we wear many hats. Working with Certificates is just one of the hats! We all know that we can make our environment more secure by leveraging Certs for things...