Gartner Developer Conference
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to...
2007-06-13
2,014 reads
Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,352 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,336 reads
June Midlands PASS Meeting Canceled
We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in...
2007-06-07
1,307 reads
Katmai Manageability
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto...
2007-06-06
1,359 reads
SQL Server 2005 Security
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off...
2007-06-06
1,479 reads
Southern BBQ
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and...
2007-06-06
1,406 reads
DBCC Internals
CHECKDB
- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used....
2007-06-05
1,872 reads
Beyond Relational
I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one....
2007-06-05
2,019 reads
Maintenance in SS2K5
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans,...
2007-06-05
1,571 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