Maintaining a professional network can take some effort from you, but the modern social networking tools can help. Steve Jones talks about some of the benefits from keeping in touch with other professionals this way.
2009-11-25
53 reads
We aren't necessarily liable for data breaches at our company, but will that last forever? Steve Jones talks about some things that you might want implement to ensure that you aren't liable if there ever is a security issue.
2009-11-24
52 reads
Brad suggests some tips on how to maximize your professional development in 2010. Get a plan together now, and you'll make your life a lot easier.
2009-11-23
214 reads
When you have a team of people working together to manage systems, communication becomes important. Steve Jones notes that a lack of working with each other and letting the rest of the team know what you are doing can cause unnecessary work for others.
2009-11-23
106 reads
Would you like to have only SQL Server Authentication on your instances? That's the subject of this Friday's poll.
2009-11-20
86 reads
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
2009-11-19
196 reads
A guest editorial from Phil Factor looks at the Speed Phreak competition that has been taking place recently and is quite popular. Read about the inspiration for the competition and why you might want to participate.
2009-11-18
282 reads
Why attend a conference? After the PASS Summit and SQL Connections, Steve Jones shares a few thoughts about the benefits of attending a conference for employees.
2009-11-17
99 reads
Does a programmer need to know how his code gets executed? Arguably, developers should focus on database structures rather than a particular implementation, and Phil tries to convince us that good programming is not just knowing everything about your programming environment.
2009-11-16
139 reads
It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.
2009-11-16
96 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