Choosing the Right Microsoft Reporting Technology Part 4: PerformancePoint
If you’ve followed this blog series from the beginning then you may have started thinking about which tools would be...
2012-03-21
1,577 reads
Blog Posts
Comparing users and role memberships between two databases
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
898 reads
Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.
To create a PowerView report first we need to create a BI Semantic Model Connection,
but If we did not deploy...
2012-03-21
2,882 reads
Fast Track for SQL Server 2012
When the Fast Track Data Warehouse 3.0 Reference Guide was published, it was based off of SQL Server 2008 R2....
2012-03-21
991 reads
Microsoft DreamSpark Program
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...
2012-03-21
1,381 reads
Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,266 reads
Speaking at SQL Saturday Houston
It’s SQL Saturday season again! I found out this morning that I’ll be speaking at next month’s SQL Saturday event...
2012-03-21
607 reads
Spring DevConnections 2012
Hello Dear Reader, this week finds me in beautiful Miami FL. Next week I’ll be in Vegas, for one night...
2012-03-21
662 reads
SQL Lunch - SQL Reporting Services
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
1,853 reads
SQL Lunch–SQL Reporting Services
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
946 reads
Blogs
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