Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,978 reads
Scrum what are story points
In this blog post I discuss Scrum (agile development methodology) and method to accurately estimate effort to complete sprint which...
2012-07-18
725 reads
SSRS does not require IIS
Starting with SQL Server Reporting 2008 Reporting Services (SSRS) was the removal of the Internet Information Services (IIS) dependency, so you do...
2012-07-18
7,607 reads
#TSQL2Day – A Day in the Life of A Service DBA
Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin...
2012-07-18
457 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my blog. Very few articles if any have been produced....
2012-07-18
9 reads
Where in the World is…
You may or may not have noticed that over the past several months I have been somewhat absent from my...
2012-07-18
943 reads
What’s been happening in Wayne’s World
Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...
2012-07-18
751 reads
Enabling "Open Project Folder" for project types that don't support it
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...
2012-07-18
765 reads
The Hollywood DBA
I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...
2012-07-18
1,010 reads
SQL Saturday #171 Pittsburgh!
It's official, there's going to be a SQL Saturday in Pittsburgh this year!
The date is October 6th, and the...
2012-07-18
616 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