2010: The Year In Review
“Quitting smoking is easy; I’ve done it dozens of times.” the great American writer Mark Twain once said.
Although I’ve never...
2010-12-15
535 reads
Blog Posts
Dashboard and KPI Design–the Definitive Industry Standard
First of all, the title is intended to be
a little tongue-in-cheek – just a little bit. I’ll explain. Last week
while I...
2010-12-15
434 reads
Email Pruning
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
873 reads
Generating RING_BUFFER_OOM Errors
Onion Ring Buffer?
Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened...
2010-12-15
743 reads
Last Call SQLRally Call for Presenters
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the...
2010-12-15
705 reads
PASS Election Review Committee - We Need Your Input!
The PASS Election Review Committee has geared up and we've started looking at the process of the entire election process...
2010-12-15
1,097 reads
Pragmatically Thankful
This season, as we continue to grow and partner with some of the best of the best in the industry....
2010-12-15
509 reads
Preventing Subscriptions from Blocking Interactive Report Executions
A consulting client recently asked how they could resolve a capacity-planning issue
on their production report server. They manage a busy...
2010-12-15
650 reads
Relational Types.
As I try to drag my team (sometimes with resistance, sometimes with pleasure) into the world of relational principles, I...
2010-12-15
608 reads
Should I have AutoGrowth enabled on my SQL Server Database
I was reading a few forum posts yesterday where a few people were complaining that the transaction log had grown...
2010-12-15
2,381 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