Negotiating - It's Not All About Winning
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
2008-08-04
6,378 reads
Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of...
2008-08-04
297 reads
I'm probably in the minority, but I use an offline reader for consuming feeds. Nothing wrong with browser based readers other than that...
2008-08-04
253 reads
We've got two technical sessions scheduled for tomorrow night. The first is by long time oPASS member Dolores Tofel discussing...
2008-08-03
320 reads
SQLSaturday #5 in Olympia is progressing nicely. 85 registered, venue locked in, and work under way for fund raising via...
2008-08-01
558 reads
Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't...
2008-07-31
1,454 reads
Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to...
2008-07-30
1,369 reads
Recently I was driving home and as I made that turn into the sub-division where I live, over the course...
2008-07-30
1,355 reads
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,161 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