What Write Ahead Logging Is and Why It Matters
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2024-06-12 (first published: 2020-01-20)
4,755 reads
Editorials
2024-06-10 (first published: 2020-01-23)
523 reads
Is Perfect Software Attainable?
I was in a social media discussion the other day where someone said “Perfection isn’t real, but progress is.” This started me thinking, is there really no perfection? Can you not actually create a piece of software that is perfect? Of course you can. As long as your requirements are perfect, and the code does […]
2024-06-08
107 reads
Poor Database Design Realities
Steve sees that poor database design is the reality of the world and we have to work around that.
2024-06-07
283 reads
Using AI for the First Draft
What is an AI LLM useful for? Steve thinks a first draft is not a bad way to look at your AI results.
2024-06-05
227 reads
DBCC CLONEDATABASE is Semi-Discontinued
Microsoft is no longer supporting some uses for DBCC CLONEDATABASE. Read a few of Steve's thoughts on the change.
2024-06-03
128 reads
On Being an "Expert"
I had the opportunity last week to present a session at DataSaturdays Stockholm. I can't say enough nice things about the event and the organizers. I presented on Query Store in SQL Server. In my mind, it's an entry-level to middle tier presentation. Most of the room was already working with Query Store, some quite […]
2024-06-01
123 reads
2024-05-31
156 reads
Common Algorithm Concerns
Steve doesn't have a lot of concerns about AI models writing code and reusing algorithms, but others might not feel the same way.
2024-05-29
203 reads
Managed Instance Impressions
Today Steve asks about your view of Managed Instance. He has found many people like the offering quite a bit.
2024-05-27
392 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers