SQLSaturday Orlando Marketing Plan-Part 41
Ah, an interesting week for registrations. We’ve jumped to 426 registered, making my goal of 500 doable. The jump is...
2014-09-08
523 reads
Better Presentations–Fonts
This is part of a series of tips for speakers to make your presentations better.
Please, please, please, learn how to set...
2014-09-08
831 reads
Parameterization Part 4: Handling Non-Uniform Data Distribution
This is the fourth post in the “Parameterization” series. In the previous post I wrote about parameter sniffing, and I...
2014-09-11 (first published: 2014-09-08)
7,143 reads
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
538 reads
Silicon Valley is a different world
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing...
2014-09-05
788 reads
Reblog: August 29 to September 4
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-09-05
740 reads
Database Free Space Monitoring – The right way
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
465 reads
Speaker of the Month: September 2014
This month I’m very grateful because I was given the opportunity to present at DevLink in Chattanooga. I got to...
2014-09-05
531 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-09 (first published: 2014-09-05)
7,448 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
642 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