Tips Archives

Is Hyper-V Server Slow? Check Broadcom NIC KB

by Garth Jones | Feb 1, 2017 | Tips

The first day after upgrading from Hyper-V 2012 Server to Windows Server 2012 R2 Standard with the Hyper-V role installed. I was in the office early, like any good administrator, making sure that there weren’t any issues. Unfortunately, before I had a chance to look...

How to Setup Report Caching for a SSRS Report

by Garth Jones | Jan 26, 2017 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

Some of the reporting questions that I get asked have to do with the burden reporting puts on servers and how this can be reduced or controlled. In general, the burden for most reports and organizations is minimal as reporting is generally an underused feature....

Avoid Installing WID and SQL on the Same Server

by Garth Jones | Jan 12, 2017 | ConfigMgr, How-To, Tips

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 write more about that at a later date. While building this lab, I needed to setup WSUS on my new CAS server. This post tells you about...

I Want My Reports In Full Screen!

by Garth Jones | Dec 19, 2016 | ConfigMgr, How-To, Tips

I work with a lot of clients to help them create ConfigMgr dashboard reports. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) Administrator, you will at some point want to create a Dashboard! ConfigMgr Reporting is really SQL Server...

Does Your OS Architecture (x86 or x64) Matter within a Query?

by Garth Jones | Dec 6, 2016 | ConfigMgr, Tips

When ConfigMgr administrators are creating a collection query to find all computers with a particular application for both x86 and x64 computers, almost everyone falls into the same mistake. That mistake is querying for both x86 and x64 software titles using an Inner...

Why is SQL Server Indexing Important?

by Garth Jones | Nov 16, 2016 | ConfigMgr, Tips

This is one of those questions where the answer should seem obvious to everyone. But it is surprising how many ConfigMgr environments don’t have SQL Server indexing enabled nor the ConfigMgr Rebuild Indexes task in use. Let’s start by defining SQL Server indexing. In...