Category: SQL Server

May 4, 2018
SCCM Reporting and You at OWSUG

The Ottawa Windows Server User Group (OWSUG) is hosting a session called SCCM Reporting and You! This session will be held on Wednesday May 9 at 6:00 p.m. SCCM Reporting…

May 2, 2018
How to Import Custom SCCM Data into ServiceNow

This is the fourth post in a five-post blog set. This one will focus on how to import custom SCCM data. Originally, I created a blog post set around ServiceNow…

April 24, 2018
How to Integrate SCCM Data with ServiceNow

This post is the third post in a five-post set intended to help show you how to integrate SCCM data with ServiceNow. Here I will show you how to create…

March 21, 2018
Updated – How to Match SSRS Brand Colors with SSRS Site Items

A number of updates have occurred with SQL Server Reporting Services (SSRS) since I first published my original blog post on this topic over a year ago, so I thought…

December 27, 2017
SCCM Maintenance Tasks

This time of year is a good time (when things are a bit slow) to check Configuration Manager’s (SCCM) environment to ensure that everything is working well. We all know…

December 12, 2017
Getting Started with Power BI Desktop and SCCM

In this blog post I will show you how to connect Power BI Desktop to your System Center Configuration Manager (SCCM) SQL Server database. During the connection process I will…

December 6, 2017
How to Install Power BI Desktop

I was looking at my upcoming blog post set about Power BI and I thought it would be appropriate to start off first by showing you how to install Power…

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

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…