Visual Studio Team System - Database Professionals: Database Connection Error
If you're like me, you don't have SQL Server 2005 sitting on the
default instance because SQL Server 2000 is sitting...
2006-08-06
661 reads
Blog Posts
Excellent article on SQL Server 2005 Common Table Expressions
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
754 reads
Identifying NTLM vs. Kerberos authentication using Fiddler
I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...
2006-08-02
4,561 reads
Does your organization need a DBA? (part 2)
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
693 reads
Does your organization need a DBA?
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,537 reads
Succint Article on Encypting File System (EFS)
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,588 reads
Detecting SQL Server 2005 Properly
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,475 reads
More SQL Server blogs
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,317 reads
New Windows Vista Security Blog
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,391 reads
Haidong Ji blogs on a tip for learning Perl
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,591 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...
Kamagra Oral Jelly 100 mg to Treat Sexual Problems
Kamagra Oral Jelly 100 mg is a medication used to treat erectile dysfunction (ED)....
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