1-Week to PASS Summit 2010 – After Hours
Final post for the countdown – a little later in the week than I wanted. Right now there is less than...
2010-11-05
613 reads
StrateSQL
Return of the Index Analysis Report
Let’s Anaylze An Index! Finally up to the last post of this series resurgence. Time to update the Index Analysis...
2010-11-04
1,142 reads
SQLServerPedia Award Nomination
I thought this week was going to be pretty low key. SQL Saturday 58 has wrapped up. The PASS Summit...
2010-11-04
980 reads
SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
454 reads
Why are DBA skills necessary? #TSQL2sDay
Time for another T-SQL Tuesday and this time I’ll finish my entry in time. This month we are talking about...
2010-11-02
776 reads
“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
875 reads
SQL Saturday 58 TODAY! #sqlsat58
Don’t forget the Minnesota SQL Saturday is TODAY. Obviously, this was written before today and I’m hoping to catch a...
2010-10-29
1,480 reads
Last Call for PASSMN Board of Directors
As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors. PASSMN...
2010-10-28
496 reads
2-Weeks to PASS Summit 2010 Countdown
It’s getting down to brass tacks. There is now only 2 more weeks until the PASS Summit. There’ve been a...
2010-10-26
820 reads
SQL Saturday 58 This Week #sqlsat58
Don’t forget the Minnesota SQL Saturday is this Friday. Remember, we’re DIFFERENT and out event is on a Friday instead...
2010-10-25
579 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