BI Training with Eugene Meidinger
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
62 reads
I’ve known Eugene Meidinger (SQLGene) for a number of years and we share a lot of interests outside of technology. We’re both avid boardgame and card game players, though...
2024-01-31
62 reads
Introductory Ramble Spark Connect In July 2022, at the Data and AI summit, Apache Spark announced “Spark Connect,” which was a way of connecting to Apache Spark using the...
2024-01-31 (first published: 2024-01-17)
365 reads
The holidays have passed and it’s a new year. You probably have a gift card or two and haven’t decided how to use it yet. Allow me to help:
Buy...
2024-01-30
33 reads
Thanks to everyone that came to my talk at THAT Conference. The deck is here, if you want to download it and use it as a resource, or to...
2024-01-29
27 reads
A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...
2024-01-29 (first published: 2024-01-10)
283 reads
📰 News Fabric end-to-end use case: Data Engineering part 2 – Pipelines If you’re new in Microsoft Fabric – check this series and build it with Sam. Set up...
2024-01-29
18 reads
I’m in Round Rock, TX today at THAT Conference. I attended THAT Conference in Wisconsin Dells last summer, and it was fun. I took my wife, but I wish...
2024-01-29
18 reads
SQL Server Error 8623
At least once day, an application for one of the databases I manage gets this error:The query processor ran out of internal...
2024-01-29 (first published: 2024-01-13)
877 reads
If you aren’t familiar with the ATT&CK framework and knowledge base, it’s a tool to help classify and understand cyberattacks. Recently (Oct 2023), ATT&CKcon 4.0 was held and MITRE...
2024-01-29
18 reads
lyssanmania – n. the irrational fear that someone you know is angry at you, that as soon as you wander into the room, you’ll be faced with a barrage...
2024-01-26
23 reads
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Comments posted to this topic are about the item Creating a JSON Document I
Comments posted to this topic are about the item Who is Irresponsible?
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers