Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,395 reads
Blog Posts
Managing Funds for User Groups
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
637 reads
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
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
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
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...
Forums
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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...
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