Category: SSMS

June 24, 2020
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…

February 5, 2020
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…

July 30, 2019
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…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

What do I mean by, “Setting up security for SCCM Power BI reports?” First, in order to create and run Power BI reports, you need to access the SQL Server…

July 10, 2019
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…