A customer was asking about SQL Prompt recently and how their history is stored and if it can be moved to another machine. This post shows how this works,...
2024-02-09 (first published: 2024-01-22)
252 reads
Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...
2024-02-09 (first published: 2024-01-29)
666 reads
I’m thrilled to share that after 15 months of dedicated effort, my book, “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh,”...
2024-02-08
157 reads
Sometimes you need a fast way to test your API call and responses, and for that VS code is the perfect tool to do that. For today’s demo, we...
2024-02-07 (first published: 2024-01-24)
964 reads
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-02-07 (first published: 2024-01-23)
187 reads
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
47 reads
You might be able to shave off thousands – or more – in your monthly cloud bills for your critical SQL Servers, all while maintaining or even improving performance....
2024-02-05 (first published: 2024-01-21)
218 reads
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
90 reads
SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...
2024-02-05 (first published: 2024-01-24)
533 reads
I love this logo. Our marketing people were very creative. After the van tour last year, we decided to go with a plane this year. I wrote about the...
2024-02-05
43 reads
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...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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