Announcing SQLSaturday #10 - Tampa 2009
Pam Shaw & Wes Dumey are leading the charge for the 2nd annual Tampa SQLSaturday on January 24, 2009. They are...
2008-09-14
479 reads
Blog Posts
SQL Code Review - Scalar Variables
One very common mistake I see when reviewing code is the case where the select statement is returning multiple rows,...
2008-09-14
529 reads
Business of Software 2008 - YCombinator - Jessica Livingston
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-12
765 reads
Kindle - The Two Week Followup
It's been two weeks since I got the Kindle. Actually it will be two weeks in a few hours. I've...
2008-09-12
982 reads
Business of Software 2008 - Dharmesh - On Startups
I'm starting a series of blog posts from the Business of Software conference
that I attended last week in Boston. If...
2008-09-11
791 reads
Chrome
I'm not usually much of a beta software guy, but I saw the new Chrome browser (http://www.google.com/chrome) from Google last...
2008-09-11
768 reads
2008-09-11
421 reads
Vacations Part II
One of the big decisions around vacations is whether it should be a 'do something' vacation or a 'do nothing'...
2008-09-11
1,253 reads
Blog Review - Yours & Mine
It's pretty common to see a mild plea from blog authors asking for feedback, or ideas about which to write...
2008-09-10
418 reads
Upcoming Presentation at the PASS Summit 2008
PASS asked all speakers to update their blogs with news about the event (a good idea), so here's my post!
I'll...
2008-09-10
385 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