Dell Selling an iSCSI Box
Saw an plug for it from our sales rep yesterday, MD3000i. Starts at $7300 with just a couple drives, goes...
2007-09-11
500 reads
Blog Posts
How Many Good Hours Do Employees Work?
You might call me a bean counter, but it's a fact that every manager needs to manage the distractions that...
2007-09-11
526 reads
SQL 2008 CTP4 Available - If you have time!
Makes me yearn for a faster connection, about a 2300 mb download to get all the various pieces and if...
2007-09-10
1,260 reads
SQLSaturday - Who are the Customers?
For those who might not have browsed previous posts I'm heading up a free one day training event called SQLSaturday...
2007-09-10
549 reads
Vacation... and the need for it
I have been on vacation the last week, which meant I spent the previous three weeks at work preparing to...
2007-09-10
614 reads
Background Images in Reporting Services posted on SSC
I wrote this up based on some questions in our recent BI class where we spend almost a full day...
2007-09-06
535 reads
CodePlex, CodeZone, and Connect
You might have visited these already, but it's interesting to see MS diversify a bit from the standard MSDN template....
2007-09-06
968 reads
Registration is Open for SQLSaturday Orlando
It's taken a while to get here, but we're finally accepting registrations for the event. This link will take you...
2007-08-31
1,344 reads
Blogging on Blogs & Professional Development
Steve posted an interesting editorial on blogs at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=393904 and the follow up discussion was pretty interesting. Read that if...
2007-08-30
1,531 reads
Getting Random Results Posted on SSC
I previously blogged about using newid() to get random ordering and after chatting with Steve about it, decided to write...
2007-08-30
1,353 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