Category: Troubleshooting

October 26, 2017
What Happened to the Tools Gauge in My SSRS Dashboard?

In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing…

October 24, 2017
What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?

A long time ago I started working on two projects using SQL Server Business Intelligence Development Studio 2005 (BIDS). I wanted to keep working on these projects, so I upgraded…

October 11, 2017
Does SQL Server Database Compatibility Level Matter?

Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over…

October 5, 2017
Why is Using a SQL Server Alias for Column Names Important?

Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your…

May 10, 2017
How to Query Asset Intelligence for Top Console User Details

By Garth Jones Here’s some background on how I came to write this blog post. In a recent forum post, someone mentioned that user details were not being displayed within…

February 15, 2017
Why Won’t Collections Update on the CAS?!

By Garth Jones While I was working on my new lab, I noticed that collections were not refreshing, so I dug deep into the server and noticed that the link…

February 1, 2017
Hyper-V Server Slow? Check Broadcom NIC KB

By Garth Jones The first day after upgrading from Hyper-V 2012 Server to Windows Server 2012 R2 Standard with the Hyper-V role installed, I was in the office early, like…

December 13, 2016
How to Test Your MP to Confirm If It Is Healthy

By Garth Jones This is one of those testing questions that I get asked fairly often: How can I test to confirm that ConfigMgr is working? This is a complicated…

August 11, 2016
Please Wait for the Local Session Manager

By Garth Jones and Joseph Yedid Recently Joseph and I installed a new Uninterruptible Power Supply (UPS) on one of our Hyper-V servers. As part of this process, we needed…

August 10, 2016
KB3000850 Causes Patching Issues

By Joseph Yedid As of late I have had to create a bunch of fresh VMs and patch them up. Just so happens that one of those VMs was a…