Category: SQL Server

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…

March 27, 2019
How to Install SQL Server Reporting Services 2017

The installation process for SQL Server Reporting Services 2017 (SSRS) is a bit different than it was in previous versions of SSRS. One of the main differences is that the…

March 21, 2019
How to Install SQL Server 2017

I was surprised to discover that with all of my blog posts about reporting in System Center Configuration Manager (SCCM) current branch, I don’t actually have one on how to…