Collation: Definition
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-19
2,261 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 2
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has...
2014-03-24 (first published: 2014-03-19)
1,469 reads
The SQL Elephant in my room
TweetG’day,
Are people familiar with the saying “If there’s an elphant in the room, introduce it“? – if not, then to sum...
2014-03-25 (first published: 2014-03-19)
5,447 reads
When Data Should Walk Out The Door
What would you do?
What would your reaction be if, one day, all that old data you’ve been holding onto for...
2014-03-24 (first published: 2014-03-18)
1,975 reads
Speaking About Unstructured Data at SQL Saturday #287 – Madison
I haven’t been to Wisconsin in a long time. Not since I was a little kid, going to visit family....
2014-03-18
820 reads
Breaking: SQL Server 2014 RTM in two weeks
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
821 reads
Parallel Data Warehouse (PDW) benefits made simple
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a...
2014-03-18
2,472 reads
Where is my Availability Group?
In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the...
2014-03-21 (first published: 2014-03-18)
2,985 reads
Finding Mistakes
Ever had that moment where you start getting errors from code that you’ve tested a million times? I had that...
2014-03-18
784 reads
Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
531 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