Zach's 1st MegaCon 2011 Hello Dear Reader! This past week is a blur. It was a tough week at work. That sentence is an understatement, but its really all I...
2023-04-04
32 reads
Today we have announced the schedule for Data Céilí 2023 and have opened registration! We have two days of great sessions for you, the 8th of June will have...
2023-04-03
24 reads
The grade for March is also D. Details below, but just not making a lot of progress in these areas. In fact, I find myself not motivated to work...
2023-04-03
15 reads
Data continues to be the lifeline for companies across the globe. As maturity levels continue to grow across companies, one aspect that sometimes needs to be checked is cataloging...
2023-04-03 (first published: 2023-03-20)
264 reads
If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering….. Will he write about Powershell? Ok, I will....
2023-04-03 (first published: 2023-03-20)
214 reads
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
185 reads
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
254 reads
It’s time for T-SQL Tuesday again, and this time there is an interesting invitation. Damien Jones reached out and wanted to host, so he gets to pick the topic...
2023-03-31 (first published: 2023-03-14)
266 reads
What is Kubernetes? Kubernetes which is also referred to as k8. k8 is an open-source container orchestration platform that automates deployment, scaling, and management of the containerized application. k8...
2023-03-29 (first published: 2023-03-19)
159 reads
Back in December 2019, I started presenting my session on mental health with lots of fear as to how the community was going to take
The post WIT/DEI Mental Health...
2023-03-29 (first published: 2023-03-24)
103 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers