SQL Server Archives

How to Combine Two Views into one Query

by Garth Jones | Dec 20, 2023 | ConfigMgr, SQL Server, Tips

In this blog post, I will show you how to How to Combine Two Views into one Query. The other day, I was reading one of the various groups that I answer questions in. There was an interesting post that asked. (Edited) “I have been asked to see if there is a way to see...

Changing ConfigMgr Report Account Password, How do I do it?

by Garth Jones | Feb 1, 2023 | ConfigMgr, How-To, SQL Server, SQL Server Reporting Services

This comes of fairly often within Reddit or other forums, Changing ConfigMgr Report Account Password, How do I do it? What people do is change the account password within Active Directory (AD). Then they change the dataset password and everything works great for 10...

What is a 4-part version numbers?

by Garth Jones | Jan 11, 2023 | SQL Server

The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...

Why is Using a SQL Server Alias for Column Names Important?

by Garth Jones | Oct 5, 2017 | Reporting, SQL Server, SQL Server Reporting Services

Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.” Within the detailed part of the error message it said, “An item with the same key has...