Category: SQL Server

April 14, 2021
How to Get the Most Accurate Results from ConfigMgr

In order to get the most accurate results out of Microsoft Endpoint Manager Configuration Manager (MEMCM / ConfigMgr) you must first understand the three key elements of reporting. They are:…

Accurate Results from ConfigMgr - Total Number of Software Titles
April 7, 2021
How to Create a Prompted WQL Query

Did you know that you can write a prompted WQL query within the Microsoft Endpoint Manager Configuration Manager (MEMCM/ConfigMgr/MECM) console? Yes, you can! It is one of those nice features…

Prompted WQL Query - Create Query
January 13, 2021
How to Create a Collection Prompt Query

This is one of the most requested asks in the forums, “How can I add a collection to my report?” After a bit of toing and froing, what the person…

Collection Prompt Query - End Result - Featured Image
December 9, 2020
Installation Guide to Ola Hallengren’s SQL Server Maintenance Solution

I originally posted these steps back in 2016, but with Ola Hallengren updating his SQL Server Maintenance Solution recently, I felt it was time to review, update and refresh my…

SQL Server Maintenance Solution - Execute
October 14, 2020
Display a Date in a Text Box

The idea for this blog post was on my list of “things to do” for quite a while. Why? Again, and again, I saw comments such as, “My date is…

Display a Date - Date Format Report