First, I’m a big believer in doing infrastructure as code.
Using the AWS SDK with any library is great, but for things like S3 I’d highly recommend you use a...
2021-03-24 (first published: 2021-01-19)
109 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-24
12 reads
Ulysses integrates with WordPress to enable publishing and editing to WordPress from within the app.
2021-03-24
31 reads
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2021-03-24 (first published: 2021-02-01)
401 reads
For those of us who have been involved in the Microsoft Data Platform community for a few years, the events of the last few months have been dramatic, culminating...
2021-03-24
22 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-23
13 reads
Lots of exciting things are happening with Data Saturdays and we want you, the #SQLFamily, involved. Last week, Rob Sewell (B|T) announced the new automation and setup process for...
2021-03-23
36 reads
I wrote recently about looking for candidates and the criteria that I initially considered. I am happy to say quite a few people expressed interest, and my list of...
2021-03-23 (first published: 2021-03-18)
70 reads
I’ve been working on a project for the last few months with a client who has chosen to implement Dremio in Azure. Dremio is a data lake engine that...
2021-03-23 (first published: 2021-03-18)
107 reads
I’ve been helping with the Data Saturdays project, in addition to trying to get SQL Saturday to grow again. Data Saturdays is looking for a logo, as the site...
2021-03-23
23 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