The IT Explosion
So many people are joining the IT industry all the time and Steve Jones talks about the attitudes that they bring with them.
2010-01-26
208 reads
Editorial
We'll go no more a' tibbling
Phil Factor points out the limitations and irritations of Hungarian Notation.
2010-01-25
859 reads
Keeping up with Technology
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
2010-01-25
118 reads
Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
258 reads
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
648 reads
Help Others, Help Yourself
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
2010-01-20
221 reads
Perfect is the Enemy of Good
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
2010-01-19
155 reads
Moving PASS
The PASS Summit has been held in Seattle for a number of years, but recently people have asked to move it somewhere else. Steve Jones talks a little about the issue.
2010-01-18
93 reads
The End of Support
It can be nerve-wracking for a DBA when support for their server ends. This week support for SQL Server 2005 Service Pack 2 ended and Steve Jones talks about your options.
2010-01-18
427 reads
The Price of SQL Server
SQL Server is an expensive product to license. Or is it? Steve Jones asks today if you feel it's expensive, and what price might you want to pay.
2010-01-15
445 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