Dell Mini – The Follow Up
Back in January I posted about purchasing a Dell Mini 9, wanting to see what how it worked and a...
2009-06-24
1,372 reads
Blog Posts
SQL Server 2008 Encryption - Extensible Key Management
One of the new features with SQL Server 2008 is the addition of extensible key management, allowing hardware devices to...
2009-06-24
3,951 reads
What’s the Typical Resignation Notice Period for DBAs?
I was recently talking to a friend from the U.K about how much notice a DBA should give to their...
2009-06-24
2,007 reads
Why Do I Blog?
It's late, it's been a busy day, so why bother to spend 10 or 15 minutes at night jotting things...
2009-06-24
1,495 reads
Windows 7 Issues
I went to add a few things to the new Windows 7 desktop today, and of course I have installer...
2009-06-24
790 reads
Clear Ceases Operations
Saw this in email this morning, Clear has ceased operations after failing to negotiate with its senior creditor. I’ve written...
2009-06-23
626 reads
How to Identify Important Characteristics for a DBA Job Candidate
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds...
2009-06-23
3,051 reads
Paying for Content - SQL Server Knowledge
Someone asked me recently if I subscribed to any services to keep up with SQL Server content. Meaning did I...
2009-06-23
2,021 reads
Spring Cleaning
As happens occasionally I had a stack of books on my desk that needed to be put away, and as...
2009-06-23
531 reads
What Would You Like to See in a Book on Database Maintenance?
I am working on the outline of a new book I am writing, tentatively called Mastering SQL Server Database Maintenance....
2009-06-23
684 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
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
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
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