Career Growth

SQLServerCentral Editorial

Fear of "What If"

  • Editorial

Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]

(2)

You rated this post out of 5. Change rating

2023-02-06 (first published: )

226 reads

SQLServerCentral Editorial

Learning Leads To Learning

  • Editorial

I am an amateur radio operator. In the US this is commonly referred to as a ham, or a ham radio operator. My call sign is KC1KCE, as issued by the US government through the FCC. And yeah, I can hear you now, a ham is the geek equivalent of a cross-fitter. How do you […]

(2)

You rated this post out of 5. Change rating

2023-01-20 (first published: )

147 reads

SQLServerCentral Editorial

Improving Skills at Work

  • Editorial

A large part of the success I've had in my career has come from growing my skills, both technical and soft, throughout the years. I've always been driven to learn more and improve my ability to accomplish the tasks I've been assigned. Or those that I've sought out and tackled. A little initiative has been […]

You rated this post out of 5. Change rating

2022-12-23 (first published: )

388 reads

SQLServerCentral Editorial

Losing Skills Because of Automation

  • Editorial

When I was younger, it seemed that everyone I worked with in technology knew how to build a computer. Most knew how to work with a BIOS, were comfortable with command lines, and could assemble complex compiler directives into a Make file. Over time, it seems many people, especially Windows and MacOS users, became focused […]

(2)

You rated this post out of 5. Change rating

2022-11-11

210 reads

Blogs

Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption

By

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 

By

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

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Read the latest Blogs

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

By Terry Jago

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)

By BOR15K

Hello all, I’m looking for advice on how to derive a daily snapshot table...

SQL 2017 to SQL 2025. Good to Go ?

By homebrew01

We need to replace our Windows server running SQL 2017. Any reason not to...

Visit the forum

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 beer
If I run this, what is returned?
select t1.[key]
    from openjson((select t.* FROM Beer AS t for json path)) t1

See possible answers