About Garth Jones

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...

How Do I Enable SQL Server Agent Service?

by Garth Jones | Oct 27, 2016 | How-To, Tips

The SQL Server Agent service is used by SQL Server to execute scheduled tasks. It is typically used for items such as backing up the SQL Server database or other maintenance tasks, and is a much have for Ola Hallengren’s SQL Server Maintenance Solution. By default,...