MS Access Annoyance: Doesn’t Link Synonyms
I use Access when I don’t have dedicated admin tools for editing data, frequently the case for infrequently changed data...
2010-06-30
3,145 reads
Blog Posts
One of these things is not like the other
I’m working with PowerShell, and digging it. I decided that I wanted to create a new script (blog post later,...
2010-06-30
2,082 reads
PASS, Don’t Waste My Time
Update: Apparently I can't write, or get a point across from the
comments and a few emails, so I have...
2010-06-30
2,516 reads
SQL Saturday #48 - Columbia, SC - Registration and Call for Speakers is On-line
The website is up for SQL Saturday #48 - Columbia. We're holding it on October 2, 2010, in West Columbia, SC,...
2010-06-30
1,436 reads
The Politics of SQL Server Performance
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,517 reads
Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to...
2010-06-30
2,126 reads
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter)...
2010-06-29
1,608 reads
ASK SQLServerCentral - The New Community Model
We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange...
2010-06-29
1,740 reads
Conference Calls Are Hard
Conference calls are a fact of life for most of us. Remote offices, remote workers, clients – lots of reasons to...
2010-06-29
1,426 reads
Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,035 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