Category: SQL

March 21, 2019
How to Install SQL Server 2017

I was surprised to discover that with all of my blog posts about reporting in System Center Configuration Manager (SCCM) current branch, I don’t actually have one on how to…

February 13, 2019
Non-Printable Characters in SCCM

Recently, the Enhansoft Team was made aware of an issue with non-printable characters in several System Center Configuration Manager (SCCM) SQL Server views. What does this mean? SCCM reports with…

June 6, 2018
Updated-How to Create a SQL Server Computer Account Login

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…

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…

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

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 this information within…

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

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 native RDL in…

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…