The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
2009-09-28
112 reads
Steve Jones looks at some of the interesting news this week in the SQL Server world.
2009-09-28
77 reads
Can you trust the information you get online? There are lots of people that think so, and that's been one of the huge benefits of a highly connected world. Most of us ask questions and get help from others around the world using various forums. This Friday Steve Jones asks you about the help you get online.
2009-09-25
97 reads
Today we have a guest editorial from Tim Mitchell that looks at the stereotypical geek. Have you worked with one? Is it harder to manage technical people? Or is it the job? Read Tim's thoughts and let us know if you agree.
2009-09-24
154 reads
When things aren't done well or set up properly in your systems, is it a mistake or a failure? Steve Jones talks about the need for those working with technology to be sure that they are taking responsibility for being educated about how to do things.
2009-09-23
95 reads
There's a networking seminar at the PASS Summit, and with the explosion of social networking sites, lots of technology workers have been thinking about how to better network for their career. Today Steve Joens talks about why it's a good idea to build up your networking skills.
2009-09-22
181 reads
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
2014-06-27 (first published: 2009-09-21)
237 reads
Phil ponders whether the term 'DBA' is still really meaningful, or if it's just a blunt instrument used to bash a diverse population into a mis-conceived niche. Is it worth the trouble of being typecast, just to have those 3 letters on your CV?
2009-09-21
260 reads
Working with passwords that provide enough security and are hard to crack is complicated enough. Most users want to simplify their lives with fewer passwords if possible. This Friday Steve Jones asks how you handle passwords across systems.
2009-09-18
110 reads
When you upgrade to a new server, there's more than just making sure that everything is ready to move, but do you clean house? Do you ever go back and ensure you're not moving things that you don't need?
2009-09-17
107 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