SQL Server 2005 SP 4
Finally, after SQL Server 2005 SP3 was released Dec 2008, SP4 is now available for download.
To download visit Microsofts Download...
2011-01-05
673 reads
Ben Nevis Nov 2010
Ben Nevis – November 2010
Last major training trek before Kili !!
Was pretty cold up in Scotland………
2011-01-05
403 reads
Rebuilding the W510 - DVD Driver Issues with x64
I backed up my machine, copied a bunch of data to both a thumb drive as well as the second...
2011-01-05
902 reads
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions on the schedule. My answer is a resounding...
2011-01-05
14 reads
31 Days of SSIS – One Variable to Rule Them All (5/31)
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I am writing. Today...
2011-01-05
467 reads
Presenting At SQLSaturday #62 - Tampa
Even though I live in Orlando - just a hop, skip, and jump away from Tampa - I've missed their SQLSaturday for...
2011-01-05
567 reads
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more info here. There is a bit of interesting news...
2011-01-05
9 reads
SQLCruise Contest
For those who may not have heard, there is training for SQL Professionals called SQL Cruise. You can find more...
2011-01-05
676 reads
Tech Books: Caveat Emptor
These days, we have a myriad of ways to judge whether any given product – like, say, a book on SQL...
2011-01-05
781 reads
Good People Know Good People
I can’t remember where I heard this recently, but it’s been stuck in my head as one of those bits...
2011-01-05
631 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