Category: SQL

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

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…