About Garth Jones

RBA and Non-RBA Queries: When is Slower Actually Faster?

by Garth Jones | Jul 10, 2019 | ConfigMgr, Tips

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently turned my attention to one of Enhansoft’s Software Update (SU) reports....

Why Did My Column Headers Stop Working in SSRS 2016?

by Garth Jones | Jun 26, 2019 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

What happened to my column headers in SQL Server Reporting Services (SSRS) 2016?! This was the question I kept asking myself over and over again. It took some time, but eventually I figured it out, so in this blog post, I explain the problem and how I successfully...

How to Deploy SSRS Reports from Visual Studio to the SSRS Server

by Garth Jones | Jun 19, 2019 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

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. I say, “normally,” because recently I ran into an issue which meant enabling the publishing...

Using a SQL Server Query to Create a PowerShell Script

by Garth Jones | Jun 5, 2019 | How-To

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 asked myself, “Why not use a SQL Server query to create a PowerShell script?” I did exactly that and this...

How to Add Repeating Header Rows Within a SSRS Matrix

by Garth Jones | May 29, 2019 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

I am working a lot with matrices these days for a new SQL Server Reporting Services (SSRS) report in Enhansoft Reporting. The more I use a matrix the more things I discover that are different between matrices and tables, so here I will show you how to add repeating...