It was time for an upgrade
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
645 reads
Blog Posts
Kindle Fire Parental Controls
I blogged a while back about not having the ability to easily disable purchasing on the Kindle. Until recently we...
2012-05-05
479 reads
SQLRally Can’t Miss Events
Things have been quiet around here lately and I have a one word explanation….SQLRally. There’s work and family and several...
2012-05-05
587 reads
Call for Mentors for The Mentoring Experiment
We’re about to start our second experiment over at The Mentoring Experiment and we need mentors. Last time we picked...
2012-05-04 (first published: 2012-04-24)
1,847 reads
Can You Dig It? – Determining Index Plan Usage
She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...
2012-05-04
1,443 reads
Denali – Day 4: Editions & Licensing
Denali – Day 4: Editions & Licensing
Editions:
Here is a brief edition summary of Editions available for all sql server from 2005 to...
2012-05-04
612 reads
DQS Domain Validation Rules
A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...
2012-05-04
751 reads
Living a Dream
It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...
2012-05-04
1,214 reads
Slowing Changing Dimension (SCD) demystified – Part 2
In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...
2012-05-04
752 reads
SQL Saturday Houston Recap
Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event. This...
2012-05-04
586 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