Awesome Software/Training Deal!
Here at Pragmatic Works, we are not just a bunch of great consultants! We create software too! Some that helps...
2011-04-21
470 reads
A SQL Server Hardware Nugget A Day – Day 20
For Day 20 of this series, we are going to talk about some factors to consider if you are thinking...
2011-04-20
781 reads
Building an algorithm
When I was in college, and even high school, all of my computer science classes required me to build algorithms....
2011-04-20
1,546 reads
Fail-Win Balance
It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for...
2011-04-20
529 reads
Daily Denali Delight – Day 1
Code-named Denali – the next version of SQL Server is fast approaching.
And whenever CTP2 gets released (is this still unconfirmed?) you...
2011-04-20
922 reads
CodeName for the next generation of SQL Server??
Ever since the first version of SQL Server (1988??), Microsoft has found some interesting codenames for their releases
1993 – SQL Server 4.211995...
2011-04-20
797 reads
Powershell Day 20
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
430 reads
Adding Data Files To A Mirrored Database
This is my first post! I don't really expect anyone to find this blog.
So I have a pretty big...
2011-04-20
3,810 reads
SQL Saturday 67 Slides Are Now Available
I recently debuted a new presentation, “What To Do When It All Goes So Wrong”. The presentation is designed to...
2011-04-20
736 reads
Evaluating my SQL Connection Scores
This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...
2011-04-20
1,490 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