A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,989 reads
Blog Posts
August Question: What types of continuing education do you use to keep up with being a DBA?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-08-02
606 reads
PASS Update #40 (Elections)
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
353 reads
SQL Saturday #28 - Two Weeks Away
It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly...
2010-08-02
359 reads
SQL Saturday 28 Baton Rouge and Ask the Experts
The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks! Have you registered?
I’m honored...
2010-08-02
608 reads
SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
652 reads
SSWUG Ultimate Virtual Conference October 20-22, 2010
I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010....
2010-08-02
789 reads
What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
599 reads
Winner of the July Question of the Month
This month’s question of the month was:
Tell us your story of how you happened to become a DBA.
This month, the...
2010-08-02
384 reads
A Milestone
I just passed 100,000 views on the blog. That’s from 400 posts over a period of time starting in March...
2010-08-01
658 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