PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
814 reads
Guest Post – The Last Starfighter
Today I am delighted to be able to share with you a guest post from one of my all time...
2012-06-13
1,218 reads
@LearningTree: 2108 SQL Server 2012 Database Administration
This past week my international adventures have continued. As some of you know, for the past couple of years, I...
2012-06-13
1,543 reads
Command Line Prompts for Checking Active Directory Membership
Using Active Directory groups are a great way to manage and maintain security for a solution. Think about if you...
2012-06-13
1,910 reads
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month...
2012-06-12
1,912 reads
SQL Server 2005 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-12
1,151 reads
T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,053 reads
Using PowerPivot to Monitor Reporting Services
PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...
2012-06-12
1,540 reads
T-SQL Tuesday #31 – Logging
It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...
2012-06-12
1,647 reads
T-SQL Tuesday 31: SSIS 2012 Logging
Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.
I like to think of logging as a...
2012-06-19 (first published: 2012-06-12)
3,818 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
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