Got Any Grapes?
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
This past weekend we took a mini vacation, along the way my daughter decided to play this song, which is...
2013-05-14
600 reads
It’s not uncommon to get frustrated about something at work and send out an email blasting whatever person or group...
2013-05-10
706 reads
I read quite a bit and it’s rare that I don’t have a book or magazine with me in case...
2013-05-07
677 reads
Recently at work we had a “Hawaiian Shirt Day”, a nice change from the usual business casual. I picked one...
2013-05-06
582 reads
For the past couple months I’ve been looking forward to a 5 week break, a chance to think about what...
2013-04-30
1,406 reads
As I re-read the original Looking Back post I realized I didn’t include anything about the fear part – stepping away...
2013-04-29
1,254 reads
Spend a few minutes reviewing 20 Critical Security Controls. Very interesting stuff. For example, #1 refers to having and maintaining...
2013-04-27
809 reads
In July 2011 I took what felt like a big chance and a detour to lead a large and complex...
2013-04-24
731 reads
The Way, starring Martin Sheen and directed by Emilio Estevez has been on my want to watch list for a...
2013-04-23
675 reads
I’ll be attending and presenting at SQLSaturday #200 in Philadelphia in June, then I’ll be attending the first ever SQLSaturday...
2013-04-22
650 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...
We need to replace our Windows server running SQL 2017. Any reason not to...
Comments posted to this topic are about the item 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