Writing Parametrized MDX for Reporting Services
Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all...
2014-08-04
560 reads
Deny vs Revoke
Quick quiz. Which of these two commands is the opposite of GRANT?
DENYREVOKE
Well lets start with some definitions
GRANT – Grants permissions on...
2014-08-12 (first published: 2014-08-04)
8,535 reads
Effective Business Intelligence
How Business Intelligence Can Help
Effective business intelligence starts with questions that will help your organization make better decisions. For example,...
2014-08-04
684 reads
ExpressProfiler - new release
Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...
2014-08-11 (first published: 2014-08-04)
8,828 reads
Renaming or Changing SQL Server Cluster Instance
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...
2014-08-12 (first published: 2014-08-04)
16,508 reads
Let SQL Server Write Code for You
Introduction
Many times I happen to find myself in a situation where, as a DBA, I need to write some long...
2014-08-11 (first published: 2014-08-04)
10,993 reads
Building The SQLSaturday Orlando Marketing Plan-Part 29
Received an email from LinkedIn that the ad was approved and so far we’ve spent a whopping 83 cents! Not...
2014-08-03
412 reads
Building the SQLSaturday Orlando Marketing Plan-Part 28
Today at lunch I looked at LinkedIn advertising. I only capture the last part to share here, but you put...
2014-08-01
583 reads
Reblog: July 25 to July 31
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-08-01
576 reads
Speaker of the Month: August 2014
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,055 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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