PowerPivot for Excel Now 2012 Only
I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...
2012-07-17
881 reads
Office 2013 Preview – Enabling PowerPivot in Excel
With the Office 2013 announcements today I was excited to download and get my hands on the tools. Because this is still...
2012-07-18 (first published: 2012-07-17)
3,306 reads
Crystal Reports DataDate in SSRS
Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...
2012-07-16
1,385 reads
BI Systems Architecture Diagrams
Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...
2012-07-16
639 reads
PASS BI/DW presents Dimensional Modeling 101–by me…
With a little help from the Kimball Group, I have become somewhat knowledgeable with the Data Mart dimension model approach...
2012-07-16
867 reads
SQL in the City – London 2012
It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal....
2012-07-18 (first published: 2012-07-16)
3,077 reads
Talent Shift
Today a friend Kevin Edward Kline announced he was joining SQL Sentry. Last week Kevin announced his intent to leave...
2012-07-16
553 reads
How to use LinkedIn to enhance your career
LinkedIn is a great resource to improve your career. It has definitely worked for me as the last 5-6 jobs I have...
2012-07-20 (first published: 2012-07-16)
3,903 reads
MidnightDBA tutorials and webshow now on iTunes!
We’ve been slacking for way too long, but as of this week our video RSS feed is up to date!...
2012-07-16
701 reads
SQL Audit 102 – Reading audit output
Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in...
2012-07-19 (first published: 2012-07-16)
3,260 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