Free data & statistics, data collection, analysis, visualization and sharing – knoema.com
Knoema is a knowledge platform. The basic idea is to connect data with analytical and presentation tools. As a result,...
2014-02-05
560 reads
Presenting at Code Camp Orlando
I’ll be at Code Camp Orlando on March 22, 2014 doing a presentation on storing credit cards in SQL Server...
2014-02-05
632 reads
Presenting at SQLSaturday Tampa
The schedule just went up, I’ll be presenting PCI for the SQL DBA this year. Looking forward to visiting Tampa...
2014-02-05
505 reads
Powershell – Extract Versions for SQL Features
Over the last few months I’ve been directed to ensure that all of our SQL Servers in the Development and...
2014-02-05
1,542 reads
Book Review: The Phoenix Project
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,934 reads
Transactions: What commands aren’t allowed?
Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put...
2014-02-13 (first published: 2014-02-05)
4,567 reads
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,357 reads
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across...
2014-02-05
413 reads
Actual Emails: More Grief for GUIDs
Wrote this email exchange with some developer colleagues about to embark on performance tuning.
Subject: bag o' tricks from DMV talk
From: A. Developer
Hey...
2014-02-12 (first published: 2014-02-05)
2,091 reads
PowerShell – SQL Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,079 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