Ask Garth
  • Home Page
  • Books
  • Blog
  • NewsLetter
  • Which Right Click Tool are you?
  • Blame Garth
Select Page
Why is Using a SQL Server Alias for Column Names Important?

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...
What Are the Four-Part Names of a SQL Server Object?

What Are the Four-Part Names of a SQL Server Object?

by Garth Jones | Aug 16, 2017 | ConfigMgr, SQL Server Reporting Services, Tips

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 created by querying the SCCM database. Most often SQL Server Reporting Services (SSRS) is used to display SCCM...
How to Change the Page Measurements and Paper Size of a SSRS Report

How to Change the Page Measurements and Paper Size of a SSRS Report

by Garth Jones | Jun 22, 2017 | SQL Server Reporting Services, Tips

I recently was sent a SQL Server Reporting Services (SSRS) report that needed to be edited and updated. One of the items that I was tasked with was converting the report’s page size from centimeters to inches. Additionally changing the page layout from A4 to 11” x...
SQL Server Data Tools (SSDT) and RDL Versions

SQL Server Data Tools (SSDT) and RDL Versions

by Garth Jones | Jun 6, 2017 | SQL Server Reporting Services, Tips

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 the SQL Server 2008 R2 format. In this blog post I will show you where to find the SQL Server 2008 R2 RDL in...
Why Can’t I Access My SSRS Site Remotely?

Why Can’t I Access My SSRS Site Remotely?

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

While I was troubleshooting a Software Updates (SU) issue (there’s a long story here that I will skip!) I ran into an access issue with my SQL Server Reporting Services’ (SSRS) site. I wondered, “Why can’t I access my SSRS site remotely?”. This blog...
How to Define the Size of a SQL Server Database

How to Define the Size of a SQL Server Database

by Garth Jones | Apr 25, 2017 | How-To, SQL Server Reporting Services, Tips

In a couple of recent blog posts I talked about two ways to prevent the SQL Server database from running out of disk space because of transaction logs, and what I did when I discovered that my SQL Server Reporting Services (SSRS) database was using a ridiculous amount...
« Older Entries
Next Entries »
  • Privacy Policy
  • Facebook
  • X
  • RSS
Copyright Garth Jones 2003 - 2025
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
5580