Tips & Tricks
Test Your Role-Based Administration (RBA) Queries in SSMS
I write a lot of queries for Configuration Manager 2012 (CM12) and Configuration Manager 2007 (CM07). I also use SQL Server Management Studio (SSMS) to test all of my queries before I create SSRS reports. Now that CM12 R2 is released, I still want to test all of my...
How-To Preview SCCM SSRS Reports in BIDS
Taking only 5 minutes to set-up, you can Preview SCCM SSRS Reports in SQL Server Business Intelligence Development Studio (BIDS) instead of uploading reports to the SCCM 2012 R2 SSRS site to preview and test each time. Doing this now will save you all those extra time...
Where Are My Charts? GDI+
I recently ran into an issue where a chart was missing in one of my newly converted System Center 2012 R2 Configuration Manager (CM12 R2/ SCCM / ConfigMgr ) reports. ConfigMgr Reporting which is really SQL Server Reporting Services (SSRS) Reporting. I was spinning my...
Business Intelligence Development Studio (BIDS) or Report Builder (RB)?
I often get asked why I always use Business Intelligence Development Studio (BIDS) instead of Report Builder (RB), so this blog post will help to identify some of the reasons why I prefer BIDS to RB. Business Intelligence Development Studio vs Report Builder BIDSRBYou...
How to Set-up an Email Subscription in SSRS
On a fairly regular basis, someone within the forums or mailing list will ask, “How can I email a copy of my SCCM report to my Manager every week?” As Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) Administrator, You need to...
How to Setup the Most Complicated MEMC Environment
Installing and setting-up Configuration Manager (CM) can be a long and time consuming task, but CM Admins can make this even more complicated for themselves. And yes, this is possible! For this example I am using CM12 SP1 R2. But how can you setup the Most Complicated...
Blog Clean Up
I have had a blog going since 2004! And I have migrated the blog site from various blogging software over the years to where it is now. It also came from various sites like Enhansoft.com, SMSUG.ca, owsug.ca, etc. In 2006, one of my goals was to release one blog per...
Blog Clean Up
I have had a blog going since 2004! And I have migrated the blog site from various blogging software over the years to where it is now. It also came from various sites like Enhansoft.com, SMSUG.ca, owsug.ca, etc. In 2006, one of my goals was to release one blog per...
How to Install the SQL Server WMI Provider
I wanted to install Ola Hallengren’s SQL Server Maintenance Solution on my lab’s Windows Server Update Services (WSUS). When I tried to install Ola’s script, unfortunately, I received an error message saying that the SQL Server Agent service wasn’t running. I thought...
Adding an All Option to Your Prompt
In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...