PASS Summit 2013–Board Q&A
PASS Board Q&A just starting. Session is being recorded – transcript will be published, no decision on whether recording will be...
2013-10-18
714 reads
PASS Board Q&A just starting. Session is being recorded – transcript will be published, no decision on whether recording will be...
2013-10-18
714 reads
The PASS Board of Directors will be available for questions from the members from 12:30 to 1:45 in Ballroom C....
2013-10-18
614 reads
Today flew by. I posted earlier about my visit with Dr. DeWitt and it’s late, so bullets for the rest...
2013-10-17
632 reads
Waiting on the second day keynote to begin.
Douglas McDowell going over funding sources for PASS – primarily the Summit, but $100k...
2013-10-17
619 reads
Incoming President Thomas LaRock up. 3000 viewers of PASS TV yesterday. Adam Jorgensen the the new VP of Finance and...
2013-10-17
708 reads
I was lucky/thrilled to get to spend a few minutes chatting with Dr. DeWitt this afternoon (and thanks to PASS...
2013-10-16
637 reads
I took a quick break at 5:30 to drop off my bag at the hotel and head back to attend...
2013-10-16
286 reads
I’m starting the official ‘day one’ at the bloggers table with Tim Mitchell and Colin Stasiuk. We’re at a side...
2013-10-16
368 reads
Waiting on Microsoft keynote to begin. Hoping for excitement!
SQL 2012 has had fastest adoption rate. No arguing it’s good, wonder...
2013-10-16
571 reads
Still at the opening day keynote, waiting for next demo to start.
I think the PASS water bottles are the most...
2013-10-16
659 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...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
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