Asking a SQL Question
I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions...
2008-06-18
1,560 reads
Blog Posts
SQLSaturday #4 Lessons Learned
Earlier in the week I posted a quick & positive note about the event, today I'll add some notes about things...
2008-06-18
1,389 reads
Link: Killing Terminal Service Connections
Needed to kill a connection so I get could logged on recently to a server and didn't have the server...
2008-06-17
1,395 reads
Off-Topic: Microsoft Marketing
I saw a blog post by Robert Hensing talking about Microsoft's new GPS product and its very uncreative name. This...
2008-06-17
1,882 reads
Community Speakers/Leaders - Where's the ROI?
I participated in a lunch meeting recently with a number of people from MS that work on their community efforts,...
2008-06-16
1,786 reads
Trigger Notes
One of the questions that came up during a panel discussion at SQLSaturday #4 was whether it was better to...
2008-06-15
1,479 reads
RC0 and HierarchyID
I gave a presentation Tuesday to my local SQL user group on 2008 T-SQL and data types. One of the items...
2008-06-13
766 reads
TechEd - Execution Plans
Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book...
2008-06-13
860 reads
Avoid Domain Admin level accounts for SQL Server
Every so often I see a post in the forums where someone has stated they've used a Domain Admin level...
2008-06-12
12,922 reads
Notes on My Visit To The Space Coast Users Group
I visited the Space Coast group last night, hosted by Ken Tucker, and did about 90 minute of SQL Q&A...
2008-06-12
562 reads
Blogs
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...
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
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