Vinay Thakur

Blog Post

How Log reader works- replication

Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...

2009-09-03

823 reads

Blog Post

Replication

Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...

2009-09-03

753 reads

Blog Post

Data Type Synonyms

Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...

2009-09-02

632 reads

Blog Post

reading.

Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.

2009-08-30

1,596 reads

Blogs

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

By

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

By

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

By

Hello, dear blog reader. Today’s post is coming to you straight from the home...

Read the latest Blogs

Forums

Creating a JSON Document I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document I

Who is Irresponsible?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who is Irresponsible?

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

By Massimo Preitano

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Visit the forum

Question of the Day

Creating a JSON Document I

I want to create a JSON document that contains data from this table: 

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933
If I run this code, what is returned? 
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers