Self-service Reporting in SQL Server “Denali”
Project “Crescent” is the name currently used to describe the new self-service reporting
capability to be released in the next version...
2010-11-14
617 reads
pturley
Cloudy Days Ahead
Microsoft is investing heavily in cloud computing with several online services available
under the Azure Platform.
SQL Azure
The SQL Azure cloud...
2010-11-13
441 reads
PASS 2010 Summit Announcements and New SQL Server Developments
To say that this was a very full conference would be an understatement. The
SQL Server platform has grown to be...
2010-11-13
485 reads
Join us at PASS 2010!
Please join as at the 2010 global summit for the Professional Association for SQL
Server in Seattle. The conference is the...
2010-10-13
494 reads
Product Review: SnagIt 10
Screen captures have become part of our computer culture… “I’ll send you a screen
shot of the window so you can...
2010-09-02
508 reads
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
627 reads
Project Phoenix: a Chance to Support the Community and Build a Career
Do you know someone with an IT background who could use a break, is passionate about
technology and wants to make...
2010-08-04
502 reads
2010 Microsoft BI Conference: Directions in Microsoft BI
The combined Microsoft BI Conference and TechEd in New Orleans last week was a great
experience. The shear magnitude of the...
2010-06-21
1,165 reads
BI Conference Grocery Shopping Demo
Help enter demonstration data for the Microsoft BI Conference.
Go to the shopping
demo web form and enter some transactions.
No...
2010-05-27
1,447 reads
Portland SQL Saturday / Code Camp 2010
Today was the Portland SQL Saturday and Code Camp at the University of Portland and
it was a great experience. I...
2010-05-23
430 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