SQL Server

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…

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,…

This might seem like an odd blog post to write. Why not simply search for all workstations with “Windows 7%” and “Windows 10%” in your query? Once you have this…

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…

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…

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…

While I was at the Midwest Management Summit at the Mall of America (MMSMOA) in May, the topic of supported SQL Server views came up. Someone mentioned an easy way…

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….

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…

After writing posts about, How to Install SQL Server 2017 and How to Install SQL Server Reporting Services 2017, I was surprised to learn that I hadn’t written one about…