Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...
2023-09-27 (first published: 2023-09-04)
403 reads
Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading
2023-09-27 (first published: 2023-09-05)
405 reads
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...
2023-09-25
72 reads
The Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...
2023-09-25
14 reads
Enable PowerShell Remoting
I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...
2023-09-25 (first published: 2023-09-24)
228 reads
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register today and save a note in your calendar. The event has a great schedule (scroll...
2023-09-25
15 reads
A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...
2023-09-25
74 reads
One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...
2023-09-25 (first published: 2023-08-28)
379 reads
My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...
2023-09-25
16 reads
Yet another kind of orphan users in SQL Server
Or YAOU for short. (This silly acronym, I just made it up so don’t try...
2023-09-25 (first published: 2023-09-02)
1,134 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