Done and Out
for a week. I'm leaving for vacation and leaving SQLServerCentral.com
in the capable hands of Andy. He'll be sending out some...
2005-07-15
1,388 reads
Blog Posts
SQL PASS Chapter in South Carolina
If you are interested in helping to organize or be a part of an
official Professional Association of SQL Server chapter...
2005-07-15
1,401 reads
Memory Leak
A couple of days ago I noticed that the index rebuild for the search
engine was failing at night. In line...
2005-07-14
1,479 reads
Reboot
Apologies, a minor reboot of the db server this morning. Somewhere we're leaking memory, more details later, so I had...
2005-07-14
1,492 reads
RunAs
When I started working at JD Edwards, I was a corporate administrator
on the windows network. Since the DBAs were a...
2005-07-12
1,531 reads
It's always something
As Phill posts in his blog, we've had a couple interesting threads in the forums where the respect and tolerance...
2005-07-11
1,440 reads
This is lovely
I got a note that someone thought they shouldn't have to register on
the site and get a newsletter to read...
2005-07-07
1,381 reads
What Is Really Interesting?
When I wrote the editorial for today on A Humbling Experience,
I was sure that it would generate a bunch of...
2005-07-07
1,499 reads
Interviewing a DBA
Andy and I had an interesting question on this today. He's trying to
hire a DBA and he had his first...
2005-07-05
1,582 reads
To Blog or Not To Blog
Blogging seemed like a big deal in 2004. At the 2003 PASS Summit, we were told by Microsoft that they...
2005-06-29
1,516 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