SQLSat153 Recap
You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City. If you...
2012-10-24
757 reads
SQL RNNR
SQLSat153 Recap
You may not know that this past Saturday ( October 20, 2012) was SQLSaturday 153 in Salt Lake City. If you knew about it, awesome. If you attended –...
2012-10-24
11 reads
Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there...
2012-10-15
976 reads
Lions and Tigers and Bears…
Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...
2012-10-15
14 reads
Do you Dream?
You ever have those nights consumed by all things SQL?
I do. It happens more than I might like sometimes. Usually...
2012-10-11
941 reads
Do you Dream?
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
12 reads
High Energy Plankton – T-SQL Tuesday #35
High Energy Plankton
In 2022 humans will finally have become their own worst enemies/frenemies. No matter how hard Gore works to...
2012-10-09
1,090 reads
High Energy Plankton – T-SQL Tuesday #35
So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?
Related Posts:
Data Platform MVP 2020 August 12, 2020
It's an Honor:...
2012-10-09
7 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here....
2012-10-04
945 reads
Finally, it has happened…
Last month I blogged about my absence from the blogosphere. If you want, you can read about it again – here. Granted, it has been a month and I...
2012-10-04
5 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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