Another Keyboard Down
I don’t know if they’re making them cheaper and shoddier or what, but it seems that I’m going through a...
2010-01-26
906 reads
Blog Posts
Database Normalization
Normalization :- Normalization can be defined as the process of organization the data to reduce the redundant table data to the...
2010-01-26
2,809 reads
2010-01-26
360 reads
First Normal form (INF)
First Normal Form (INF):- A table is said to be in a First Normal Form (1NF)if it satisfy the following...
2010-01-26
794 reads
How to Participate in the SQL Community – Draft #1
I mentioned last year about my plans to write this, and to make it a semi-collaborative effort by incorporating comments...
2010-01-26
590 reads
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
847 reads
It’s a Toaster
I had to install WinZip the other day, having the need to unlock a .RAR file. There’s no native support...
2010-01-26
1,161 reads
Jimmy May coming to our Local Chapter meeting
This is wonderful news to our new chapter. Jimmy May has agreed to come to give a presentation at our...
2010-01-26
689 reads
Proofing Your Resume
The resume that you send out, whether in print or electronically, is the first impression that you will make on...
2010-01-26
1,367 reads
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following...
2010-01-26
3,652 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