Data Privacy – Playing your part
Tuesday 28th January 2020 was “Data Privacy Day 2020” Some may refer to this as Data Protection Day, but it is really just a day to draw attention to...
2020-03-10 (first published: 2020-02-03)
206 reads
measure twice, cut once.
2020-02-02
15 reads
Is NoSQL still a thing?
G’day, Looking back, perhaps one of the (many) mistakes that I’ve made in my career was to initially ignore the N0SQL movement. I’ve focused my career on Relational Database...
2020-01-27
41 reads
Moving to a Modern Microsoft Platform
Melbourne Event – Monday 17th June 2019 (Free – including lunch and prizes) PASS, in conjunction with Microsoft, Intel and community leaders are offering free training on Moving to...
2019-06-06
12 reads
Speaking at Events
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
19 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2019-02-25 (first published: 2019-02-02)
2,577 reads
Azure Notebooks – a nice little tool.
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,107 reads
T-SQL Tuesday #109 – Mentors and Mentees
G’day again,
So, it’s time for T-SQL Tuesday again, the blog party
started by Adam Machanic (
This time we're talking about people...
2018-12-11
181 reads
TSQL Tuesday #108 – Learning to Learn
G’day,
One attribute that I think is more relevant today than ever is to have a broad base of skills with...
2018-11-15
196 reads
A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2018-11-06 (first published: 2018-10-28)
3,203 reads
Blogs
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...
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