Solid State Drives are becoming more commonplace in database systems. eBay and Facebook have implemented large SSD systems in their environments. Steve Jones thinks DBAs should be learning more about how SSDs affect SQL Server.
2026-08-17 (first published: 2011-08-16)
418 reads
I've just spent a week in the UK visiting the Redgate HQ with my fellow advocates. I'm really blessed to get to work with such a great bunch of people. A couple of the conversations we had stuck with me and I'd like to share them here. Sitting in the midst of Cambridge, Cambridgeshire, UK, […]
2026-08-15
204 reads
2026-08-14
186 reads
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
204 reads
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
Managing incidents as a DBA /DB manager and some of the key things you should be doing.
2026-08-08
167 reads
2026-08-07
235 reads
AI is causing some people to work more, which seems at odds with the idea of what AI should be: a useful tool.
2026-08-05
203 reads
Recognizing queries that might perform poorly is a skill that will help you, and your AI assistant, produce better code in production.
2026-08-03
247 reads
Yeah, I've got the Go-Go's running in my head because I'm going on vacation tomorrow (holiday for you UK types). I've been slogging through a really dense book, War in Human Civilization. Total recommendation. Get it. Read it. However, I'm right near the end and there's been a lot of discussion about the impact of […]
2026-08-01
165 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item 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