It's nice to be able to choose what you want, or what might fit you better. Too much choice, however, can be a bad thing, even in software where it seems we could have unlimited choices. Steve Jones tasks about the need to limit choice.
2009-12-07
67 reads
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
2018-08-02 (first published: 2009-12-07)
383 reads
The client tools for SQL Server have grown from small single purpose applications to larger tools that combine a number of functions. Do you like that? Is it a good idea? Steve Jones asks the question in today's Friday poll.
2009-12-04
91 reads
Who checks on those who manage our systems? Is there auditing in place for those accidental DBAs?
2014-10-16 (first published: 2009-12-03)
325 reads
We all want the best. Whether it's a new stereo or a high availability solution for your database server. Steve Jones talks about the need for us to learn more in order to make the best decision for ourselves.
2009-12-02
67 reads
After the holiday, Steve Jones gives a little insight into his job, and what he likes about running SQLServerCentral.
2009-12-01
104 reads
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
2009-11-30
66 reads
Some developers have reacted with dismay to the recent news that Microsoft’s Oslo project is being integrated into the SQL Server platform and renamed SQL Server Modeling. The overwhelming feeling seems to be that their DSL dream is being snatched away.
2009-11-30
94 reads
For a fun Friday poll, what type of SQL or database related name would you give to yourself or someone else? Steve Jones asks the question after someone sends an email about naming their new boat with a SQL name.
2009-11-27
78 reads
Happy Thanksgiving to everyone in the US. The editorial today has a blooper reel from the podcasts in celebration of the holiday.
2009-11-26
46 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Using OPENJSON
Comments posted to this topic are about the item Data Modeling with dbt for...
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