I’ll Be Presenting at the PASS Summit 2012
I’m a little late posting this, but I had two sessions accepted out of four I submitted. I’ll be doing...
2012-07-16
543 reads
Why Attending a Monday Pre-con Will Be Awesome
Why Attending a Monday Pre-con Will Be Awesome
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is coming up in a...
2012-07-16
1,140 reads
SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,090 reads
Speaker Selection for SQLSaturday Orlando-The Monday List
Nine more speakers we’re pleased to say will be joining us for a fabulous SQLSaturday in Orlando!
Timothy McAliley
Juan Soto
Erika Bakse
Jose...
2012-07-16
665 reads
Building Your First Power View Report
This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.
Fulfilling User Needs
Developing a...
2012-07-16
1,213 reads
Finding Your Dream Job - sharing some thoughts of the day...
Everyone at some time or another thinks about finding or landing their dream job. It could be in the form...
2012-07-16
2,084 reads
SQL MVP Available for Database Needs....
Recently, I wrote about and introduced us to, SQLBif, a
caricature of a SQL DBA who was down on his luck,...
2012-07-16
1,393 reads
Encrypting Connections to SQL Server
I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...
2012-07-16
5,686 reads
SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,616 reads
SQLSaturday Site Wish List
Overall I find the site to be useful and responsive, but sometimes I see small things that I wish were...
2012-07-15
652 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