Don’t Change Anything
Being responsible for data integrity as well as the cleaning of data can be a problem for an organization. Steve Jones reminds us today that we should be careful about changing the data we work with.
2010-04-07
139 reads
Editorial
Can We Skip the Marketing?
Steve Jones has a message for the speakers and presenters from Microsoft today.
2010-04-13 (first published: 2010-04-06)
180 reads
Answering to the Business
As data professionals, or IT workers, we often have a lot of insight into how much our services cost and the options that are available. But many times the rest of the company does not. Steve Jones thinks we could be more transparent, and possibly help them to be more efficient.
2010-04-05
91 reads
Down Tools Week
Sometimes it's important for a developer or DBA to be given the opportunity to 'shake up their brain'. What falls out is almost always worth having.
2010-04-05
288 reads
2010-04-02
71 reads
No More NULL
A change in the support for NULL values has Steve Jones commenting on the implications.
2010-04-01
759 reads
ORM Mapping
A guest editorial from Phil Factor that discusses ORMs and how they ca be used, or mis-used, in our applications.
2010-03-31
399 reads
Why Be an MCP?
With Steve Jones on vacation, we reprint on of his more popular editorials from the past. This was originally published on Feb 14, 2005.
2010-03-30
210 reads
Space in the Clouds
Spatial support is coming to SQL Azure soon, and Steve Jones thinks about how the service could improve this support.
2010-03-29
63 reads
Open Source is Not a Career Path
A reprint from the early days of SQLServerCentral as Steve is on vacation. Here is Steve Jones' Open Source Musings from February 3, 2005.
2020-06-22 (first published: 2010-03-29)
285 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