SSMS

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…

As I write this blog post, I am sitting in my hotel room after a long day of Midwest Management Summit at the Mall of America (MMSMOA) sessions. Here I…

How many times have you wanted to make your System Center Configuration Manager (SCCM) SSRS reports quickly convey a small piece of information? Adding a dynamic image might be exactly…

This blog post is a step-by-step guide to help you with the setup of the new data warehouse service point feature in System Center Configuration Manager (SCCM). What is the…

At the last Midwest Management Summit which was held at the Mall of America, I was stopped in the hallway after one of my SCCM reporting presentations. I was asked…

Did you know that you need a Role-Based Administration (RBA) security role when you want to edit System Center Configuration Manager (SCCM) Current Branch or 2012 R2 reports with Report…

This blog post was originally published in early 2017, but since then newer versions of SQL Server were released, so I thought that it was time for an update. Here…

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…

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,…

Many of my blog posts about tips and tricks for reporting (mostly SQL Server Reporting Services (SSRS)) focus on System Center Configuration Manager (SCCM). Recently I noticed, while writing another…