SQL Server STUFF
The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...
2022-01-10
24 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
More Times Like These with SQL Server
I blogged the other about have some issues translating Oracle date formats to SQL Server date data types I find the way SQL Server handles dates with a defined...
2021-12-06
10 reads
Times Like These with SQL Server
I was doing some conversion of Oracle code (PL/SQL) to SQL Server code (T-SQL) – which had some quirks. I just thought that I’d share a quick tip that...
2021-12-02
17 reads
What exactly is a modern data warehouse?
G’day, I was asked recently what a modern data warehouse is – and that’s a vey thought provoking question. First, there’s the tag “Modern” – I think what’s modern...
2020-12-14
19 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-24 (first published: 2020-06-09)
6,857 reads
OPENJSON and CROSS APPLY
OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...
2020-06-09
16 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
285 reads
OPENJSON and an Alias
Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...
2020-06-08
13 reads
OPENJSON : Getting to the data, and the PATH – PART I
Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...
2020-06-07
29 reads
OPENJSON : Getting to the data, and the PATH – PART I
Recently we reviewed FOR JSON PATH. That was used for shaping tabular data (data that comes directly from a SQL table) into a JSON document. The PATH we are...
2020-06-07
8 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
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