Project Phoenix
Project PhoenixSometime people need a hand up – an opportunity to rise from the ashes. Over the last couple of years...
2010-10-09
895 reads
Blog Posts
What are Physical Sockets, Physical Cores, and Logical Cores and Why Does it matter?
I witnessed a confused conversation on Twitter today where someone was talking about how he uses the terms sockets and...
2010-10-09
12,717 reads
Career Warfare - Book Review
I picked up Career Warfare on the recommendation of a friend that had seen the Modern Resume presentation. I grabbed...
2010-10-08
672 reads
Free SQL Server Training for the Week of October 11, 2010
Monday
SQL Lunch - SSIS Design Patterns 1c: Variables, Events, and Automated Custom Logging Patterns - Andy Leonard
Tuesday
Idera - Accelerating Answers with Analysis Services...
2010-10-08
626 reads
New Hotness: sys.objects and sys.schemas
Last month we talked about the old and busted syscomments- and the new hotness that is sys.sql_modules – for pulling code out of...
2010-10-08
691 reads
Planning to Fail
Great title for a post, isn’t it? Seems foolish, lazy, or worse to plan for failure, right? Yet, in the...
2010-10-08
313 reads
SQL Lunch #32: SSIS Design Patterns, with Andy Leonard
Don't miss SQL Server MVP Andy Leonard on the SQL Lunch, Monday, October 11th.
#32-SSIS Design Patterns 1c: Variables, Events, and...
2010-10-08
796 reads
SQL Server Memory Related Queries
What is using all of my memory in SQL Server? If you ever believe that you are seeing signs of...
2010-10-08
2,749 reads
SSRS - Join Function
Often when designing a Reporting Services with parameters you
may be required to display those parameter values on your report.This is...
2010-10-08
4,196 reads
A little planning would have gone a long way
I was doing a database server migration for a client this week that involved a local database server with Access...
2010-10-07
902 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