The 9th Day of SQL: Things Aren't as Simple as They Seem
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...
2010-12-21
712 reads
Fashionably Late, but She's Here!
I'm pleased to announce the latest addition to the Kelley family, a beautiful baby girl born at 11:56 PM last...
2010-12-21
718 reads
Easy CDC in 5 hours (less for you!) using automatic code generation.
Updates:
Update #3:
Another reformat, thanks to andreas for giving me the heads up. The pre tags aren't behaving across browsers so...
2010-12-21
1,266 reads
SQL Server 2008 R2 RTM Cumulative Update 5 Released
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753. I count 40 separate...
2010-12-21
894 reads
MCM Live Blog – Week December 20
Watching videos?! Su-ure!
Time for the second week of blogging about the things that I’m doing to study for the MCM...
2010-12-21
591 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give a little follow-up on how my foray into Powershell...
2010-12-20
9 reads
Powershell, Me and the MCM part II
Last week I posted the first part of this series. I thought it would be a good idea to give...
2010-12-20
832 reads
Can You Dig It? – SHOWPLAN XML Structure
She can dig it!
D Sharon PruittIn the last couple plan cache posts, I talked about a couple items that are...
2010-12-20
894 reads
SQL Server 2005 Service Pack 4 RTM Released
Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server...
2010-12-20
803 reads
SSWUG Free SSIS Expo
Stinking Feet?
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get...
2010-12-20
578 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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