On December 17, the PASS organization announced the news that it would cease operations on January 15, 2021. Since the announcement, folks have been scrambling to figure out how to keep their user groups and events going or downloading recordings. By the way, if you need assistance with your user group, please reach out to […]
2020-12-26
201 reads
Merry Christmas today. Happy Holidays to all of you, for whichever holiday you celebrate this time of year. It's been a long, hard year, but I hope you are healthy and happy as we close out 2020. Hopefully next year is more enjoyable for all of us.
2020-12-25
47 reads
2020-12-24
108 reads
2020-12-23
287 reads
2020-12-22
265 reads
2020-12-21
92 reads
2020-12-19
97 reads
Redgate has done something this month to try and create culture for its employees during the pandemic.
2020-12-18
123 reads
There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.
2020-12-17
138 reads
Today Steve asks what you might want out of your local organization devoted to the data platform.
2020-12-16
79 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...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
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