Category: SQL

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…

August 16, 2017
What Are the Four-Part Names of a SQL Server Object?

By Garth Jones The purpose of this blog post is to help you identify the four possible parts of a SQL Server object. System Center Configuration Manager (SCCM) reports are…

June 20, 2017
How to Add a User’s Office Location Details to a Report

By Garth Jones Fairly often I get asked, “How can I add a user’s office location details into a report?” The first question I always ask is, “Are you populating…

June 8, 2017
Query Designer in SQL Server Management Studio (SSMS)

By Garth Jones The other day I was showing a ConfigMgr Administrator how to write a query and also how to create drill-throughs from within his reports. I began by…

June 6, 2017
SQL Server Data Tools (SSDT) and RDL Versions

By Garth Jones You built your report using SQL Server Data Tools (SSDT) which saves the RDL in the SQL Server 2016 format. That’s great, but now you need the…

May 25, 2017
How to Set SQL Server Integration Services (SSIS) Protection Levels

By Garth Jones I’m using SQL Server Integration Services (SSIS) to clone a database. I’m doing this for a customer in order to off-load the querying and reporting functions from…

May 18, 2017
How to Install SQL Server Integration Services Tools

By Garth Jones I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a customer wants all querying and reporting off-loaded from the main…

January 12, 2017
Avoid Installing WID and SQL on the Same Server

By Garth Jones Recently I built a new test lab. As an aside, in my opinion, this is one of the most complicated labs that you could have, but I’ll…

October 11, 2016
What Are the Best Report Types for ConfigMgr?

By Garth Jones In some recent blog posts, I talked about Business Intelligence (BI) reports and other different types of reports. This blog post will take things a step further…

June 16, 2016
Collection Evaluation Viewer and Certificate Chain

By Garth Jones While I was writing my blog posts, ConfigMgr Collections and Collection Evaluation Viewer and How to Fix a Poorly Written WQL Query, I ran across an interesting…