2012-01-30
83 reads
Editorial
Try Some New Tools This Month
Today we have a guest editorial from Andy Warren. Today Andy suggests you try some new tools and see if you can increase your productivity.
2012-01-27
288 reads
Healthy Work Habits
Today Steve Jones talks a little about the work environment for IT workers. We ought to pay attention and ensure we are taking care of ourselves.
2012-01-26
234 reads
No Cloud for Stack Exchange
The use of cloud computing isn't in the plans for the Stack Exchange network of sites? Steve Jones thinks they have a pretty cool reason not to use the cloud and he thinks you ought to have a similar view at work.
2012-01-25
75 reads
Back to Vegas
The DevConnections conference in the spring of 2012 is in Las Vegas, and Steve Jones is glad to be going.
2012-01-24
106 reads
Jiggly Code
There should be some method to your madness when fixing code. At least, that's what Linus Torvalds thinks and Steve Jones agrees.
2012-01-23
235 reads
Thoughts on Survival
Today we have a guest editorial from Andy Warren. Are you in a survival job? Read Andy's thoughts and let us know.
2012-01-20
179 reads
Better Than Batman
Steve Jones praises Bill Gates today, and the work he is doing to make the world a better place.
2012-01-19
181 reads
BYOD
In the future we may be required to bring our own devices to work. Does that make sense? Would you want to get an allowance and purchase your own laptop?
2016-03-18 (first published: 2012-01-18)
253 reads
The Virtual Lab
Today Steve Jones talks about the need for a lab for each of us, and a few ways you can build one.
2012-01-17
230 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