Category: SQL Server

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…

October 23, 2017
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,…

October 19, 2017
How Do You Install SQL Server Data Tools?

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…

October 11, 2017
Does SQL Server Database Compatibility Level Matter?

Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over…

October 5, 2017
Why is Using a SQL Server Alias for Column Names Important?

Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your…

September 12, 2017
Cloud Reporting: How to Setup a Linked Server

By Garth Jones What about cloud reporting? What if your cloud provider doesn’t have the tools that you need to create reports from a database in the cloud? These were…