Changing Server Default Collation
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...
2009-05-29
1,615 reads
Blog Posts
Found a Bug in SQL Server 2005
It doesn’t happen often but every once in a while you may be the lucky person to find a previously...
2009-05-29
2,148 reads
Fusion IO’s on Their Way!
My company has taken the plunge and we have two of the Duo 640’s coming. As soon as they get...
2009-05-29
1,533 reads
Security Basics: Applying the Principle of Least Privilege Properly
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do...
2009-05-29
3,155 reads
SQL Rockstar
I was scanning blogs the other day, and noticed Tom LaRock's new image on Twitter. He's SQLRockstar after a little...
2009-05-29
2,006 reads
The Conference ROI
I saw recently that Brent Ozar wrote a blog about justifying the cost of attending the 2009 PASS Summit. I...
2009-05-29
3,370 reads
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and...
2009-05-29
1,947 reads
Book Review: Real Leaders Don't Do Powerpoint
I bought Real Leaders Don't Do Powerpoint by Christoper Witt ($15 at Amazon) on a trip, Powerpoint catching my eye...
2009-05-28
1,737 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,165 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,940 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...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Using OPENJSON
Comments posted to this topic are about the item Using OPENJSON
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