Free Webinar Series This Week
If you haven’t heard already this week there is a great free webinar series going on that’s meant for beginners. ...
2010-02-22
627 reads
Blog Posts
I Feel Like a Heel
It’s now 3 events that I’ve canceled in the last 6 months, and a 4 or 5 more that I’ve...
2010-02-22
879 reads
IgnoreUnrelatedDimensions in Analysis Services 2008
Once of the more common issues with working with data in a cube is that it does not always line...
2010-02-22
459 reads
Introduction to Using Profiler with SSAS 2008
There are many ways to optimize your analysis services cubes, but the real trouble is how do you know where...
2010-02-22
606 reads
It will happen on a spring day in May...
"The world's favorite season is the spring. All things seem possible in May." - Edwin Way Teale This spring, the Portland,...
2010-02-22
463 reads
Power Plans and Windows Server 2008 R2
After seeing an interesting blog post on AnandTech IT last week that showed slower query response time in x64 SQL...
2010-02-22
3,443 reads
SQL Server 2008 - Adding Row Totals
During a recent client engagement I was asked if there was a quick way to add a row containing totals...
2010-02-22
733 reads
What Does It Look Like When Everything Is Okay?
I'm a big believer in looking at systems when everything is okay. I'm not the only one, as Joe Richards, a...
2010-02-22
874 reads
What’s up with the reads?
So the other day I read Andrew Kelly’s article, Do You Have Hidden Cache Problems, in the latest electronic edition...
2010-02-22
369 reads
When Should You Start Speaking?
I know it’s daunting and a little intimidating, but there are so many people with knowledge to share. I see...
2010-02-22
937 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...
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...
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