The Growth of Data Types
This week Steve Jones asks you what you think will make up the majority of your future databases? Will it be numerical data or will some other type come to dominate?
2011-09-02
139 reads
Editorial
Where Do You Park?
Today we have a guest editorial from Andy Warren. Most people work in an office and need to commute, which brings with it the inevitable fight for parking in many companies. How is it handled for you?
2011-09-01
168 reads
The Special Cloud
Amazon has built a cloud just for the US government. Will we see more specialized clouds in the future that might let us move some of our data to the cloud?
2011-08-31
128 reads
An Investment in Knowledge
Inspired by a quote from Benjamin Franklin, Steve Jones talks about investing in your career.
2011-08-30
263 reads
A Look Back at Apple
With the resignation of Steve Jobs from Apple this week, Steve Jones looks back at his memories of the tech icon.
2011-08-29
110 reads
Specialists or Generalists: Who are best as Developers?
Should we have specialists or generalists working as developers in our companies? A guest editorial today from Mike Angelastro asks the question.
2011-08-29
251 reads
Would You Rather Work for a Strong or Weak Manager?
Today we have a guest editorial from Andy Warren. Andy asks if you prefer to have a strong manager or weak one, and why.
2011-08-26
188 reads
Keep Data Forever
Today Steve Jones talks about some of the issues with keeping data around a long time and a new archival medium.
2011-08-25
201 reads
Pop Tarts and Hurricanes
Today Steve Jones talks about the relation between hurricanes and poptarts, and why you should be working on your T-SQL skills.
2011-08-24
156 reads
The Talent Crunch
There seems to be no shortage of IT jobs in the US, and Steve Jones reminds us that the shortage is for talented workers, not just workers.
2011-08-23
478 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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
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