Category: SQL

July 2, 2020
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…

June 24, 2020
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…

June 17, 2020
Where to Find User Name Data Within Configuration Manager – Part 2

In my last blog post, I talked about the four places to find user name data details and how they are collected/inventoried: Hardware Inventory, Heartbeat Discovery, Asset Intelligence and BGB….

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…

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…