Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
613 reads
Jack Corbett
- Interests: Sports, books, Bible
Checklist for having a Remote Presenter at your User Group
After having a bit of a tough time in the April OPASS meeting (read about it here), due to not...
2010-04-15
297 reads
OPASS April Meeting Recap
Well, we had our April meeting on Tuesday the 13th. Let's just say it wasn't our most successful meeting, and...
2010-04-14
473 reads
T-SQL Tuesday #005 – Don’t Send a Blank Report from a Report Subscription
Aaron Nelson (@SqlVariant) is hosting this month’s T-SQL Tuesday (#tsql2sday) and his topic is reporting.
One of the frustrations I have...
2010-04-13
1,811 reads
April OPASS Meeting Featuring Joe Webb
Tomorrow night, April 13th, at 6pm we will be having our April OPASS meeting, sponsored by Veredus Orlando with Joe...
2010-04-12
437 reads
SQLSaturday Orlando 2010 - The Planning Begins
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
428 reads
PASS, Microsoft, and Certification
Steve Jones’ (@way0utwest) recent SQLServerCentral editorial, The Missing Certification, has spawned a vigorous debate about what the missing certification should...
2010-04-01
1,421 reads
Didn't I Just Post about Slipstream making Installs Easier?
So the other day I posted, Slipstream - Makes installs simple, and this afternoon I needed to do a SQL Server...
2010-03-30
1,401 reads
Slipstream - Makes installs simple
I was recently working on building a test environment for myself while I was studying for the MCITP-Database Administration exams. ...
2010-03-29
1,567 reads
A Personal Story about Networking
This is not a technical or SQL Server post, but it does illustrate the power of networking.
We recently took my...
2010-03-24
512 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