Tips & Tricks
How Can I Hide an SSRS Gauge in a Dashboard?
A super-cool feature with SQL Server Reporting Services (SSRS) is all of the available options for creating dashboards and reports! For example, did you know that you can hide an SSRS gauge in a dashboard based on the results of a query? Or, that you can hide an SSRS...
How Can I Update the Plain SSRS Gauge in a Dashboard?
The default SQL Server Reporting Services (SSRS) reports in System Center Configuration Manager (SCCM), let’s face it, are plain. When you create a custom dashboard or report, however, they don’t have to stay that way! In this blog post I’ll show you how to update the...
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 out that the gauge is not displaying properly. What’s the matter with it? In this blog post, I...
How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?
I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?” In order to update the RDLs I would have to perform a, “Save As,”...
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 from BIDS 2005 to SQL Server Data Tools Visual Studio 2015 (SSDT). After editing and then...
How Do I Enable CLR within SQL Server?
If you take a copy of your System Center Configuration Manager (SCCM) database and put it on your laptop (or anywhere else) without SQL Server common language runtime (CLR) enabled, you will receive an error when accessing Role-Based Administration (RBA) functions....
Changing ConfigMgr Report Account Password, How do I do it?
This comes of fairly often within Reddit or other forums, Changing ConfigMgr Report Account Password, How do I do it? What people do is change the account password within Active Directory (AD). Then they change the dataset password and everything works great for 10...
Changing ConfigMgr Report Account Password, How do I do it?
This comes of fairly often within Reddit or other forums, Changing ConfigMgr Report Account Password, How do I do it? What people do is change the account password within Active Directory (AD). Then they change the dataset password and everything works great for 10...
How to Query AD for BitLocker Details
In two of previous blog posts, I show you How to Enable BitLocker Recovery Information to Active Directory and How to backup the keys to AD. But it dawned on me that I didn’t answer the question How can you query AD for BitLocker Details? It was obvious to me that you...
How to use PowerShell to query SQL Database?
This question comes up from time to time, where someone want to query MEMCM using WQL and runs into problems. I have done allot of work with WQL recently. What you will find when you query WMI with WQL is that you will easily hit WMI timeouts or Quota Violation from...