Stepping Stone Cert II
Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and...
2010-04-20
740 reads
Blog Posts
Whats a Good Rule for Max Degree of Parallelism?
Introduction
I am one of those people that believe that anything worth doing is worth having a script to do it....
2010-04-20
546 reads
A DMV a Day – Day 19
The DMV for Day 19 is sys.dm_os_wait_stats, which is described by BOL as:
Returns information about all the waits encountered by...
2010-04-19
2,051 reads
Goggle PowerMeter Update
As I have mentioned before, I have a TED 5000 electric power monitor installed in my house that monitors and...
2010-04-19
573 reads
How Do I Find SSIS Packages that Exist in Multiple Folders?
Introduction
If you are using SQL Storage for your SSIS packages and have multiple folders to make life easier then there...
2010-04-19
299 reads
Just one mirror
You can only have one mirror of a SQL Server database in SQL Server 2005/2008. I researched that last year...
2010-04-19
644 reads
Missing European PASS
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
871 reads
Missing European PASS (Updated)
As most of you know, the Icelandic volcano has played havoc with travel plans for speakers coming from the US...
2010-04-19
463 reads
Powershell Script for Verifying Space
First let me say, I know my Powershell skills are sub-par. I’m working on it. Slowly but surely. That said,...
2010-04-19
1,205 reads
Pride of Idea Ownership
I’ve had this on my list to write about for a while, just didn’t have a great example until this...
2010-04-19
498 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...
Kamagra Oral Jelly 100 mg to Treat Sexual Problems
Kamagra Oral Jelly 100 mg is a medication used to treat erectile dysfunction (ED)....
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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