No Rows – What It Is and Why You Should Use It

Instead of showing empty report sections because a query produced no results, I wanted to add some text to explain the outcome. I turned to an option called, No Rows, in order to populate the space with text. This blog post shows you what steps to take in order for...

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

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....

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....

How to Import a RBA Security Role

Knowing how to import a RBA (Role-Based Administration) security role from one ConfigMgr site to another will allow you to use security roles from other sites. This is a useful technique to know because it allows you to create an RBA role within a development...

SrsResources is Not Declared: Wrong DLL

I learned a lot while converting all of Enhansoft’s reports over to Role-Based Administration (RBA). One of the issues that I ran into early on was how to preview the SSRS reports within SQL Server Business Intelligence Development Studio (BIDS).  I received help from...

SrsResources is Not Declared: Missing DLL

An error occurred during the local report processing. The definition of the report ‘/PC Warranty Information’ is invalid. The Value expression for the report parameter ‘UserTokenSIDs’ contains an error: [BC30451] Name ‘SrsResources’ is not declared. When...