:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,440 reads
SQLStudies
T-SQL Tuesday #52: Keep your head down!
It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...
2014-03-11
1,291 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
728 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,056 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,554 reads
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,099 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
506 reads
Getting a query plan
Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware...
2014-02-19
1,486 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,619 reads
T-SQL Tuesday #51: Doubledown disaster
Jason Brimhall is hosting the 51st T-SQL Tuesday this month with “Place your bets!.
It’s always a gamble when buying a...
2014-02-14 (first published: 2014-02-11)
1,579 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