An Easter SQL
Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the...
2015-03-31
3,746 reads
Intro to SQL Server Automation with PowerShell
March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...
2015-03-30
902 reads
Outlier Detection with SQL Server, part 5: Interquartile Range
By Steve Bolton
…………The last seven articles in this series of mistutorials on identifying outlying values in SQL Server database were...
2015-03-30
5,864 reads
SQLPort – 5 Years
On 21st of April 2015, SQLPort is preparing a very special event. The reason for this is that on 21st...
2015-03-30
1,101 reads
Toshiba Portege Z30 Review
I saw recently that Grant Fritchey wrote a review of his laptop, the Portege Z30. I had noted Grant’s issues...
2015-03-30
1,787 reads
Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at...
2015-04-06 (first published: 2015-03-30)
7,143 reads
Does the New Cardinality Estimator Reduce Bad Parameter Sniffing
No. Next question.
Although, that answer can be slightly, ever so slightly, nuanced…
Parameter sniffing is a good thing. But, like a...
2015-04-06 (first published: 2015-03-30)
7,288 reads
Port numbers and SQL Server
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
10,079 reads
Latches, Spinlocks & Lock-Free Data Structures Recording
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...
2015-03-30
1,306 reads
Can Log Shipping Work Without Shipping the Log?
When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...
2015-04-02 (first published: 2015-03-30)
6,902 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