Disappearance
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
661 reads
Blog Posts
Podcasting
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,046 reads
How do you make a Wiki work?
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
634 reads
Contributing to Wikipedia
Recently I posted about an interview with Jimmy Wales and only a couple days after that I ran across What...
2007-12-06
588 reads
Tribute to Honor Jim Gray
Saw this on the Association for Computer Machinery SIGMOD announcements.
Tribute to Honor Jim Gray
It is scheduled for May 31, 2008...
2007-12-05
552 reads
How Will Processor Licensing Evolve?
Information week had an interesting article that talks about the different methods of licensing used, ranging from the what we're...
2007-12-04
646 reads
Powerpoint from a Blackberry
Ran across the Impactica Showmate, a $249 item (gadget?) that allows you to present Powerpoint presentations wirelessly via Bluetooth directly...
2007-12-04
648 reads
Event and Session Evaluation Results for SQLSaturday Orlando
SQLSaturday is ultimately about attendees, and they finally speak! The scores look very good and the comments should be useful...
2007-12-02
614 reads
The DBA Routine Posted on SSC
This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an...
2007-11-30
1,444 reads
Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,399 reads
Blogs
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers