SQLPASS Day 2: Keynote Live Blog
Them's some SEXY DBAs...
I’m live blogging the PASS keynote…it’s 8:44 local time.
Here’s the PASS website description of the day 2 keynote...
2010-11-10
518 reads
Jen McCown
SQLPASS Day 2: WIT Luncheon Live Blog
12:42pm local time at the live streamed Women in Technology luncheon…let’s blog. I’ll italicize my comments, to differentiate betwee that...
2010-11-10
1,130 reads
SQLPASS Day 1: Keynote Live Blog
Day 1 Keynote Jumps the Shark with Tina Turner Impersonator
I’m live blogging the PASS keynote…it’s 8:38 local time.
You wouldn’t guess...
2010-11-09
768 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
850 reads
Attend the PASS Summit From Home
You there, sitting in your cube and fuming at all the PASS Summit talk: you couldn’t talk your company into...
2010-11-01
889 reads
A Little SSMS Wish
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
523 reads
SQL Saturday #56 BI Edition Wrap-up
On Saturday I (unexpectedly) presented at Dallas’ first Business Intelligence-focused SQL Saturday at the Microsoft campus in Irving. I wasn’t on...
2010-10-25
1,521 reads
SQL Saturday #56 – The 24 hour Challenge
SQL Saturday #56, Dallas BI edition, is tomorrow. Last night before the NTSSUG meeting, we had an unusually high number of...
2010-10-22
803 reads
Ground Zero Database Design: Part 2
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
753 reads
SQLKilt / WIT Shirts
This shirt was specifically requested by an online friend who shall remain nameless (his name rhymes with “Duck Hoodie”). Another...
2010-10-20
1,105 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