Tips & Tricks
How to Customize SSRS Line Chart Markers
Hi All! This is what I call an interesting blog post. All report developers, at one time or another, wish they could customize reports to their own liking. It could be as simple as adding a department name, a project name or a company name to a SQL Server Reporting...
What Are the Differences Between a Power BI Slicer and a Filter?
Hi Everyone! In this blog post, I am going to talk more about the differences between a Power BI slicer and a filter. Before reading what I have to say in this post, I hope you had a chance to see the other posts on Enhansoft’s blog site about the different types of...
How to Install the SQL Server WMI Provider
I wanted to install Ola Hallengren’s SQL Server Maintenance Solution on my lab’s Windows Server Update Services (WSUS). When I tried to install Ola’s script, unfortunately, I received an error message saying that the SQL Server Agent service wasn’t running. I thought...
Adding an All Option to Your Prompt
In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...
Enhancing GetColor to add Defined Colors
While creating the videos for the GetColor updates. It dawned on me that I should show you how to Enhancing GetColor to add Defined Colors. To do this, I will show you how to define colors for a particular string value using the GetColor function. DEFINE COLORS Before...
How to Create a Visual Filter in Power BI
Hi Everyone! Today I am talking about How to create a visual filter in Power BI and how to set them up. This post is part of a series of blog posts that we’ve done at Enhansoft about the different types of Power BI filters. Visual filter are useful for refining...
How to Create RDP Certificate Enrollment GPO?
Wow, I found a second blog and video that I didn’t publish from 2022. So here is it. Now that that you have created the Remote Desktop (RDP) Certificate template. How do you enroll ensure that computer will use it? Group Policy Object (GPO) is the easiest way. This...
How to Create RDP Certificate Enrollment GPO?
Wow, I found a second blog and video that I didn’t publish from 2022. So here is it. Now that that you have created the Remote Desktop (RDP) Certificate template. How do you enroll ensure that computer will use it? Group Policy Object (GPO) is the easiest way. This...
What is a 4-part version numbers?
The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...
What is RDCM?
As a Microsoft Configuration Manager (SCCM / ConfigMgr / MCM) admin, I spend my time switching between differ servers. Over the years, I have come to LOVE Remote Desktop Connection Manager (RDCM), which is one of the Sysinternals tools! Recently I was showing a team...