This article describes the steps you take to prepare the VMware infrastructure for installing and configuring a high-availability SAP ASCS/SCS instance on a Windows failover cluster by using SIOS...
2022-11-28
140 reads
SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be...
2022-11-28 (first published: 2022-11-17)
3,350 reads
This month the fine folks behind New Stars of Data and the DataGrillen Newcomer Track bring us the Tell Your Story blog party. Where we
The post Tell My Story...
2022-11-28
40 reads
It’s the last trip for me today. I head to the UK for a few work things and then my wife is coming over to take a quick vacation...
2022-11-28
102 reads
Today’s coping tip is to connect with someone from a different generation. This tip makes me feel old. When I see “different generation” I used to think of someone...
2022-11-25
11 reads
The first "full" day of PASS 2022 kicked off with a bang when Rohan Kumar (@RohanKData) stepped out on the keynote stage to announce SQL Server 2022 was GA...
2022-11-25 (first published: 2022-11-17)
224 reads
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want...
2022-11-25 (first published: 2022-11-09)
240 reads
This blog post is not about which User Interface is better, Classic or Snowsight – If anyone does want my feedback on what I like and don’t like about...
2022-11-25
235 reads
Today’s coping tip is to try a new way to practice self-care and be kind to yourself. One of the things that I learned to do better during the...
2022-11-24
5 reads
Today’s coping tip is to build new ideas by thinking “Yes, and what if…”. I tend to look for the holes, problems, limitations, and downside of various proposals. I’ve...
2022-11-23
9 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