The Trouble with Rules
I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...
2015-09-16
595 reads
Columnstore Indexes – part 66 (“More Clustered Columnstore Improvements in SQL Server 2016”)
Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...
2015-09-15
542 reads
Free SQL Training in Seattle
Free Training in Seattle!
Related Posts:
Seattle SQL Pro Workshop 2017 October 19, 2017
Seattle SQL Pro Workshop 2017 Schedule October 26, 2017
T-SQL Tuesday 109: Influence Somebody Invite December 4,...
2015-09-15
8 reads
Free SQL Training in Seattle
The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of...
2015-09-15
677 reads
Custom Placeholders in SQL Prompt 7
I love my snippets in SQL Prompt. Adding some snippets can make work go so much quicker. I add new...
2015-09-15
1,168 reads
Powering Up HDInsight with Power BI–
On Tuesday, September 15, I presented on this topic for Pragmatic Works. You can find that session here. This session...
2015-09-15
606 reads
Ryan Adams for SQL PASS Board
It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those...
2015-09-15
568 reads
Actions In Extended Events
an action invokes memories of verbs and "to do" something. If you recall from the quick definition in the article on Extended Events Objects, an action is "a means...
2015-09-15
10 reads
Actions In Extended Events
The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some...
2015-09-15
1,470 reads
PASS Election Changes
The 2014 NomCom made some changes to how the election process works and it’s something you need to pay attention...
2015-09-15
521 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