Reporting services error: User XXXX does not have required permissions
If you encounter the following error trying to access reporting services:
User XXXX does not have required permissions. Verify that sufficient...
2018-03-02
274 reads
Blog Posts
SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2018-03-02
290 reads
SQL Server and Evil Greedy Data Types
In a recent post, I talked about SQL Server reads and how the data is stored in pages. One of...
2018-03-02
56 reads
Use Filtered Statistics to Improve Performance on Very Large Tables
Let’s say you have a very large table on a SQL Server 2012 Standard Edition instance. This means: old cardinality...
2018-03-02
411 reads
Using a gMSA with SQL Server
As you already know, SQL Server runs as a service. And services require a service account to run under. While...
2018-03-02 (first published: 2018-02-19)
17,376 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
159 reads
What is the CXPACKET Wait Type?
This wait type indicates that parallel plans execute on the server. This wait type doesn’t necessarily means there is a...
2018-03-02
859 reads
YouTube Channel Update
Hey! Here’s the latest on my YouTube Channel. Click on through and subscribe. I’ll be doing lots of stuff on...
2018-03-02
320 reads
A Swiss Army Knife Might Not Make the Best Shovel
You might have noticed that I’ve been pretty quiet as of late. We’re working on a super top secret internal...
2018-03-01
767 reads
An overview of SQL Server backup-and-restore process
In a manner of speaking, planning and implementing a SQL Server backup design is an art. Backup, Restoration, Recovery, Business...
2018-03-01
851 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers