Are You Security Minded?
It's fun to just sit and talk with people, never know what you'll learn or be forced to rethink based...
2008-12-09
733 reads
Blog Posts
DBAs Still in High Demand
With the world economy on the downside, there is at least one bright light, and that is DBAs are still...
2008-12-09
1,104 reads
Leaving Live
Last week Steve Ballmer had issued a challenge to MVPs to have them try Live Search instead of their regular...
2008-12-09
661 reads
A Custom Trace
I have to admit that when I had a performance problem with some code, I would often fire up Profiler...
2008-12-08
698 reads
Managing By The Numbers Part 2
Managing by the numbers often gets a bad name among employees because it can lead to a lot of gaming...
2008-12-08
655 reads
Tampa Code Camp Notes
I attended the Tampa Code Camp this past weekend. It was located at the Kforce Building in Tampa, a very...
2008-12-08
1,106 reads
Trying to Figure Out if SQL Server 2008 Data Compression Will Benefit You?
SQL Server 2008 (Enterprise Edition) offers row and page compression, which can potentially offer a boost in disk I/O in...
2008-12-08
1,501 reads
Using Result Set as Variable in Stored Procedure
I’ve been asked several times lately from non-SQL developers that are sometimes required to do some quick SQL work how...
2008-12-08
3,407 reads
A skinnier SQL Server Magazine
I could have sworn that my SQL Server Magazine seemed much smaller this month. When I pulled out last’s months...
2008-12-07
1,304 reads
Managing By The Numbers Part 1
I have a long held belief that if you really care about results, you have to measure them somehow. The...
2008-12-07
308 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