SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,192 reads
Blog Posts
SSMS bug #1
This happens at my instance of SSMS and at the colleagues' one it doesn't. The SQL Server Agent duplicates its...
2016-06-01
229 reads
“Tuesday Morning” SQL Break – May 31, 2016
Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up. But since I...
2016-05-31
844 reads
Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS
[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....
2016-05-31
1,690 reads
Bad Data Can Kill
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,954 reads
Goodness-of-Fit Testing with SQL Server Part 7.4: The Cramér–von Mises Criterion
By Steve Bolton
…………This last installment of this series of amateur tutorials features a goodness-of-fit metric that is closely related to...
2016-05-31
1,171 reads
I hate saying no
I really do. There is a joke that DBAs say no to everything and there is some truth to that....
2016-05-31
746 reads
Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc
*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read...
2016-05-31
1,314 reads
Precedence Goes to Query Store or Plan Guide?
While presenting at SQLDay in Wroclaw, Poland, on the Query Store, I was asked a pretty simple question, which takes...
2016-05-31
942 reads
Running Multiple Threads Quickly
Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of...
2016-05-31
1,049 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