Tips & Tricks
How to Create Power BI Parameters
Hi everyone! This blog post is for anyone who wants to learn more about Power BI parameters. This is my first blog post for Enhansoft, so let me give you a bit of background about myself. In the past, I worked with Tableau and IBM Cognos Report Studio and I’d say that...
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 Studio Code (VSC) while we were at the Midwest Management Summit (MMSMOA) in Minnesota earlier this year....
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 turned my attention to one of Enhansoft’s Software Update (SU) reports....
Why Did My Column Headers Stop Working in SSRS 2016?
What happened to my column headers in SQL Server Reporting Services (SSRS) 2016?! This was the question I kept asking myself over and over again. It took some time, but eventually I figured it out, so in this blog post, I explain the problem and how I successfully...
How to Deploy SSRS Reports from Visual Studio to the SSRS Server
Normally, I work on SQL Server Reporting Services (SSRS) reports in Visual Studio until they are done, so I don’t need to deploy SSRS reports directly to the SSRS server. I say, “normally,” because recently I ran into an issue which meant enabling the publishing...
Using a SQL Server Query to Create a PowerShell Script
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 asked myself, “Why not use a SQL Server query to create a PowerShell script?” I did exactly that and this...

How Does ConfigMgr Product Lifecycle get Updated?
The other day I was asked how does ConfigMgr product lifecycle details get updated? You know the details from the Product Lifecycle dashboard in the console. I have to admit that I don’t know that off the top of my head. But I knew that I saw it within the logs. I...
How Does ConfigMgr Product Lifecycle get Updated?
The other day I was asked how does ConfigMgr product lifecycle details get updated? You know the details from the Product Lifecycle dashboard in the console. I have to admit that I don’t know that off the top of my head. But I knew that I saw it within the logs. I...
Fun Links
This blog is a collection of Fun Links, that I saved from the Blog Clean Up! All of the fun links are not serious, So enjoy. Fun links Canadian, Please The video got striped out of the blog post. Here is the link to the video....
I want to Learn SQL Querying!
As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) administrator, you will be asked to create reports. MECM Reporting really really SQL Server Reporting Services (SSRS) reporting. In some case it is Power BI Desktop or Power BI Report...