Category: SQL Server

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

September 18, 2019
How to Create a Collection for Workstations

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…

August 14, 2019
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…

July 30, 2019
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…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

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…

July 17, 2019
Why Is It Important to Use Supported SQL Server Views with SCCM Reporting?

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…

June 19, 2019
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….

June 5, 2019
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…

April 3, 2019
How to Install a SCCM Reporting Services Point

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…