Designing for Teams
When we build software, or we put together a process, we need to consider how teams use it, not just individuals.
2026-09-28
85 reads
software development
Absolute and Relative References
One of the challenges in digital systems involves how we reference other resources. Steve discusses whether absolute or relative references are better.
2026-09-26
66 reads
Make It Routine
Solving problems can be challenging, but once you have something built, it should be easier the next time.
2026-09-21
102 reads
2026-09-19
151 reads
2026-08-14
187 reads
Building Great Software
Steve notes that building great software isn't easy, and there is a lot of work that goes into this. Even in today's age of AI.
2026-08-12
205 reads
Imagine the Physical World
Today Steve notes that he often compares the work a computer does to what might happen if the same actions occurred in the physical world.
2026-08-10
161 reads
2026-07-29
172 reads
Make It Routine
One of the goals of software is to use the power of the computer to handle repeatable tasks. Steve notes that this can be hard at first, but the goal is that subsequent efforts become routine.
2026-07-27
130 reads
The New Software Team
Software teams are changing with AI and this might be an exciting time for developers if they take advantage of the capabilities available.
2026-05-22
139 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