Questions and Answers from Running a Local LLM
I had a few random questions from my Running a Local LLM on Your Laptop session at the Houston AI-lytics 2026 event last week, so this post looks at...
2026-04-27
35 reads
Blog Posts
Houston AI-Lytics 2026–Powerpoint Slides
Thanks to everyone for attending my session on running a Local LLM. If you have any questions, please feel free to reach out with them. The slides with links...
2026-04-25
40 reads
The Book of Redgate: Do the Right Things
I do believe that Redgate has been very customer focused since it’s inception. I’ve worked with them in some capacity since 2002 and I’ve felt this along the way:...
2026-04-25 (first published: 2026-04-24)
53 reads
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards or optimisation scripts. Tools can highlight waste, but culture determines whether anyone acts on it....
2026-04-24 (first published: 2026-04-15)
209 reads
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on Wheels blog for a long time and I appreciate all that he does, especially given...
2026-04-24 (first published: 2026-04-14)
255 reads
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
Hello, dear blog reader. Today’s post is coming to you straight from the home office, ready to talk about a topic that comes up more than you’d think: storing...
2026-04-22 (first published: 2026-04-14)
653 reads
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but still need high availability and disaster recovery? You’re not alone. One of the challenges with...
2026-04-22 (first published: 2026-04-12)
395 reads
SQL skills just got MORE important
There seems to be a school of thought in the tech community that a robust knowledge SQL is now optional. After all, with modern AI tools able to generate...
2026-04-22
41 reads
The Agent Era: When “How do I…?” Replaces “Where do I click?”
After a year away getting to grips with AI and its application across the various industries, I am placing a bet: agents will become the default interface for most...
2026-04-22
30 reads
Changing the Cardinality of a FK in Redgate Data Modeler
One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this easy,...
2026-04-20 (first published: 2026-04-13)
176 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