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
Blog Posts
Let database work for your daily life
I know there are many off-shelf stuff, like MS Money, that can help you organize your personal financial things, but...
2005-09-11
1,340 reads
about xp_sendmail
I got a very interesting issue, I may guess the reason but not sure why it is this way.
Symptom: Logon to...
2005-09-09
1,379 reads
Careful Blogging
I still not sure that this blog service was a great idea, but some of
you seem to like it, so...
2005-09-08
1,375 reads
one issue about SQL 2000 BOL
This is my first post, congrats to myself. 🙂
DTS Connection object does not list "UseTrustedConnection" property
I am working on a...
2005-09-08
1,349 reads
In praise of three day weekends!
I guess it might be because I have been so busy for the last two months with the book, but this...
2005-09-05
1,237 reads
Head back up above water
I've spent the last few weeks writing SOX documentation, more SOX
documentation, and even more SOX documentation. A lot the documentation
doesn't...
2005-09-02
1,391 reads
Of anarchy and thin veneers...
Following the horrifying stories that are unfolding in the aftermath of
Katrina, it is difficult for the mind to single out...
2005-09-02
1,314 reads
The Data Center in New Orleans
There's a blog running at LiveJournal from one of the guys at directnic. There's evidently an ISP that is still...
2005-09-02
1,466 reads
Blessed to live in the boring MidWest
The images on the TV news this morning were surreal. Hundereds of people dead, missing, homeless because of Katrina and...
2005-08-31
1,273 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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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