Adding an All Option to Your Prompt

In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...

Why Am I Getting Incorrect Results in Visual Studio?

When I first encountered this issue, some time ago, I checked all of my queries in SQL Server Management Studio (SSMS) and guess what? As I suspected, the queries were 100% correct! I was troubled because I couldn’t figure out why, if my queries were correct, I was...

Visual Studio Code

You know how life gets busy and you never seem to have any time for smaller projects? Well, am I ever grateful to Julie Andreacola who reminded me about Visual Studio Code while we were at the Midwest Management Summit (MMSMOA) in Minnesota earlier this year. She...

RBA and Non-RBA Queries: When is Slower Actually Faster?

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently turned my attention to one of Enhansoft’s Software Update (SU) reports....

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 I’ll show you, step-by-step, how to create a SQL Server computer account login, how to grant SQL Server...

What Happened to the Tools Gauge in My SSRS Dashboard?

In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing out that the gauge is not displaying properly. What’s the matter with it? In this blog post, I...