Cannot generate SSPI context…
Out of all the problems you can have with SQL Server troubleshooting connectivity issues can be the most challenging. When...
2009-07-20
6,521 reads
Blog Posts
Customer Loyalty Cards, Convenience, and Privacy
I bet most of you have at least one customer loyalty card in your wallet or on your keyring, one...
2009-07-20
719 reads
Get into the Top Ten Percent
When you start applying for jobs, and face competition from other candidates, who do you think gets the interview? Is...
2009-07-20
1,586 reads
MS Field Engineer’s on Performance Troubleshooting
Do you want to get a glimpse into how the Microsoft Field Engineers would go about troubleshooting performance issues on...
2009-07-20
780 reads
Mystery of Failing Database Mail
Have you ever seen this error when you have setup database mail:
The mail could not be sent to the recipients...
2009-07-20
429 reads
PowerShell's "Mini-Shell" Is Not A "Mini" Shell
I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337 . Here's the description in the item. Please invoke the...
2009-07-20
448 reads
Social Networking in the SQL Server Community
Like many SQL Server (and other technology) people, I utilize several social networking vehicles to stay in touch with others...
2009-07-20
1,859 reads
Communicating Ain’t Easy!
I read a nice article by Steve M List called Think Before You Speak in MSDN Magazine and it talks...
2009-07-19
495 reads
SQL Saturday Dallas
We are in the early stages of planning a SQL Saturday event in the Dallas area for January or February...
2009-07-19
1,077 reads
The Price of Convenience is Non-Ownership and Loss of Privacy.
This is as far as I ever plan to stray from writing purely technical posts. It just strikes so close...
2009-07-19
702 reads
Blogs
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...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
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...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
Data Modeling with dbt for Visual Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Data Modeling with dbt for...
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