T-SQL Tuesday #96: Thank You for Taking the Time
A lot of people have made a difference in my career. A LOT! I don’t think we ever thank those...
2017-11-14
622 reads
Blog Posts
T-SQL Tuesday 96 - Folks Who Have Made a Difference
This month’s topic: Folks Who Have Made a Difference
T-SQL Tuesday is a monthly blog party for the SQL Server community...
2017-11-14
320 reads
TSQL Tuesday 96: Folks Who Have Made a Difference
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
15 reads
T-SQL Tuesday: The Contributing Factor
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
330 reads
TSQL2sDay – Folks Who Have Made a Difference
This months TSQL2sDay is an absolute brilliant one hosted by Ewald Cress
the opportunity to give a shout-out to people (well-known...
2017-11-14
277 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
288 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
56 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and...
2017-11-14
51 reads
Watching for powershell changes and running Invoke-Pester
It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and there are quite a few things to like about...
2017-11-14
10 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
141 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