You can now run powerful LLMs like Llama 3.1 directly on your laptop using Ollama. There is no cloud, and there is no cost. Just install, pull a model,...
2025-05-02 (first published: 2025-04-17)
422 reads
No tour this year, but Redgate does have a few DevOps events scheduled. I’m hoping for more, and the first one for me this year is Atlanta. You can...
2025-05-01
24 reads
Ever tried to request SQL Server funding from the CFO? Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind...
2025-05-01
45 reads
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...
2025-04-30 (first published: 2025-04-15)
202 reads
I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from...
2025-04-30
137 reads
This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on....
2025-04-30
31 reads
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-30 (first published: 2025-04-16)
387 reads
SQL Saturday Austin 2025 is in just a few days. I am honored to be speaking there, and glad to be going back. I’ve missed a number of the...
2025-04-29
55 reads
I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event focused entirely on SQL Server Query Tuning! This is...
2025-04-28
27 reads
I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is finally being updated. For many of us, SSMS has...
2025-04-28
134 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers