PASS 2005: Day Three
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,308 reads
Blog Posts
PASS 2005: Day One
This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS...
2005-09-28
1,422 reads
PASS 2005: Day Two
Day Two at PASS started out on a sour note. Rewind about 36 hours, to when I was checking in...
2005-09-28
1,550 reads
MySQL 5.0 Release Candidate Released
The release candidate for MySQL 5.0 is out. This little database is really growing up.
http://www.mysql.com/news-and-events/news/article_959.html
2005-09-27
1,372 reads
PASS Prizes
We get a referral fee from PASS for each person that registers for the
Summit with the "SSC" source code. It's...
2005-09-27
1,660 reads
September CTP Issues
The September CTP of SQL Server 2005
is not available and I'm sure lots of people have downloaded it. I
actually grabbed...
2005-09-23
1,430 reads
New Server
Surprisingly the DELL server showed up late Friday afternoon last week
when I was expecting more of a Wed-Thur delivery this...
2005-09-20
1,429 reads
Thinking about PASS
With PASS just a little over a week away, I realized that I had better fine-tune my presentation and practice...
2005-09-18
1,304 reads
Whoops
I setup an announcement for today (Sept 14) that the Sept CTP for SQL
Server 2005 was released and that Database...
2005-09-14
1,433 reads
PDC
Bill Gates keynote is on webcast now, grab it and check it out.
Also a hint. Paul Flessner is speaking tomorrow...
2005-09-13
1,446 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