All Things Awesome and MidnightDBA-y – 12/9/2010
Here’s the rundown of what we were up to last week
Friday night at 11pm CST we present another wildly appealing...
2010-12-13
812 reads
December PASSMN Meeting This Week
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
Let PASSMN put a little SQL and PowerShell in your...
2010-12-12
635 reads
SQL Standards
Three posts, three critical rants. It's time to be constructive.
I was given the responsibility to decide on the SQL development...
2010-12-12
1,666 reads
SQLPSX 2.3.1 Release
We’ve released a minor update to SQLPSX which includes several bug fixes as well as two new modules. Here’s an...
2010-12-11
775 reads
SSIS: great idea, but buggy as heck.
Oh SSIS, how I love and hate you.
As DBA at my company, I don't actually develop much in SSIS. But...
2010-12-11
1,796 reads
RTFM365, Week 1
Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t...
2010-12-10
517 reads
Come be your best with Pragmatic Works
Have you been trying to figure out how to take your career in Microsoft BI, SharePoint and SQL Server to...
2010-12-10
531 reads
SQL Server 2008 R2 System View Map
It’s a map!Have you been looking for something inside the system views of SQL Server 2007 R2 and haven’t known...
2010-12-10
464 reads
IT Education Part 2
For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...
2010-12-10
717 reads
12 Days of SQL, On the 2nd Day of SQL…
Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any...
2010-12-10
788 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