SQL Saturday Cleveland #SQLSat473
On February 6, 2016, Cleveland is hosting a free training event for SQL Server. This has a lot of the great stuff from the big, paid events, and skips...
2016-01-11
16 reads
SQL Saturday Cleveland #SQLSat473
On February 6, 2016, Cleveland is hosting a free training event for SQL Server. This has a lot of the...
2016-01-11
538 reads
2016-01-11
561 reads
SQL Server 2016 – whats new…lets see
Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....
2016-01-11
438 reads
Sudoku by SQL Part 2 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-10
370 reads
New Year Wish List for SQL Server Features
With SQL Server 2016 to be officially released this year, I want to make a wish list for the features...
2016-01-15 (first published: 2016-01-10)
1,709 reads
Sudoku by SQL Part 3 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
375 reads
Sudoku by SQL Part 1 of 3
The Challenge
Since I came across the first sudoku I was wondering if it could by solved by SQL using queries...
2016-01-09
448 reads
Creating a Matrix in Power BI With Multiple Values on Rows
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,315 reads
We Want You!
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
425 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