IT and Innovation
This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...
2011-05-19
747 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it last year with the exception that I at least...
2011-05-19
8 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it...
2011-05-19
520 reads
Change SQL Servers Authentication Mode with PowerShell
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,877 reads
WHERE HAVE YOU BEEN, patrick leblanc????
Ok, so what have I been up to?Well a lot has changed for me over the past couple of months,...
2011-05-19
1,133 reads
Report Builder: Change Report Server Connection
A question that I have been asked quite often is, “How can I change the Report Server that I am...
2011-05-19
6,500 reads
The 2013 PASS Summit Goes to Charlotte
Just in case you didn’t catch the news yesterday on Twitter, the PASS blog, or via the PASS Connector, we...
2011-05-19
696 reads
Answering SQL Questions and Forum Fun Overview
Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...
2011-05-19
655 reads
Fun with SQLskills
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...
2011-05-18
897 reads
Summit Preference Voting
This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...
2011-05-18
736 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