Tips & Tricks
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 install SQL Server. In order to remedy this, I will show you how I installed SQL Server 2017...
Finishing Touches: Adding a Row Count to Your Report
Over the last six months or so, I published a number of blog posts about many different types of finishing touches you can add to your reports and this post is no exception. Have you ever looked at a report, especially one with multiple pages, and wondered, “How many...
Top 10 SCCM Posts from 2018
With the start of 2019 in full swing, I thought it would be useful to look back and see what posts our readers found to be the most popular in 2018. After reviewing the posts, I ended up creating two top 10 lists. One list is specifically for SCCM posts and the other...
3 Tips for Customizing the Azure Portal Home Page
The first time I logged on to Azure as a new user, I saw a ton of icons, but as an Intune Administrator, most of them were completely irrelevant to me. If you’re in a similar situation, customizing the Azure portal home page is the solution. How, though, do you get it...
URLs and SSRS Reports
Don’t we all love lessons learned? Here’s one that I learned years ago about URLs and SSRS reports, but was reminded about this past summer. Last July I was creating a new System Center Configuration Manager (SCCM) software update (SU) report in SQL Server Reporting...
Different Report Styles
Why is it important to know the difference between report styles? You need to know what style is best in order to display SCCM data properly. Reports come in many different shapes and sizes, but the five styles I’ll talk about in more detail later on in this post...
How to Remove Port 80 from PBRS
This article shows you how to removed port 80 from PBRS Power BI Report Server. In this article, I will complete the process of setting up PBRS to use certificates. Note Although this blog say for PBRS it 100% applies to SQL Server Reporting Services (SSRS), therefore...
How to Remove Port 80 from PBRS
This article shows you how to removed port 80 from PBRS Power BI Report Server. In this article, I will complete the process of setting up PBRS to use certificates. Note Although this blog say for PBRS it 100% applies to SQL Server Reporting Services (SSRS), therefore...
Blog Clean Up
I have had a blog going since 2004! And I have migrated the blog site from various blogging software over the years to where it is now. It also came from various sites like Enhansoft.com, SMSUG.ca, owsug.ca, etc. In 2006, one of my goals was to release one blog per...
VM Collections!
While reading a Reddit, I ran across a post WQL Query SCCM. Originally the post was listed in another language, I forget which one as it is not important. After some back and forth, I understand they he wanted to create a collection of VM host. In this article I will...