Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
329 reads
Review of “Start Here! Learn Microsoft Visual C# 2010?
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,084 reads
June 2012 – Monthly SQL Server Checklist
It’s the first Monday of the month, have you checked your servers out? Do you know that everything with your...
2012-06-08 (first published: 2012-06-04)
2,447 reads
Back to Pensacola and SQL Saturday #132
This will be my fourth trip to Pensacola for SQL Saturday #132. I’ve enjoyed going every time and I usually...
2012-06-04
970 reads
Microsoft Master Data Services in SQL Server 2012
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is...
2012-06-08 (first published: 2012-06-04)
20,652 reads
Testing backups – Is RESTORE DATABASE…VERIFYONLY good enough?
Is it just me, or does there seem to be a lot of discussion these days about testing backups and...
2012-06-04
1,527 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,337 reads
Tips to avoid deadlocks?
A database server should be able to service requests from a large number of concurrent users. When a database server...
2012-06-04
3,396 reads
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
14 reads
Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,277 reads
Blogs
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...
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