The Great Uproar and some advice
My editorial
this past week had to do with a great uproar on the interviewing piece
that ran Monday. I felt I...
2005-10-20
1,443 reads
Blog Posts
On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,286 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,385 reads
Blogging Is Hard
Why is that? My Database Daily editorial for this week focuses on that and I thought it would be interesting...
2005-10-14
1,385 reads
Remote Access
We typically have great weather in Colorado where I live, but we do get
snow. And occassionally it causes issues. Like...
2005-10-12
1,521 reads
Minor Panic
I know, I need some stuff posted about PASS and I'll get to it. My wife
was injured (she's ok) while...
2005-10-09
1,412 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,304 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,245 reads
Back home after PASS
The past week at PASS was more informative and fun than I could ever have imagined. By getting involved in the...
2005-10-01
1,288 reads
PASS 2005: Day Four
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,363 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
Question of the Day
Using OPENJSON
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