Ravi Kumar SV

I am Ravi Kumar SV working as SQL Server Consultant for Hyderabad-based Healthcare Company. I started my IT career in 1998 with Microsoft Visual Basic 5.0. While working on Visual Basic 5 and 6 for five years, I was introduced to Microsoft SQL Server 6.5 there on I explored SQL Server technology. I have expertise in Microsoft SQL Server 6.5 to its latest form. I also worked with Pharma manufacturing Company, Jewellery manufacturing unit, and Healthcare Company as Sybase, SQL Server and Oracle consultant.

All authors

Blog Post

Rules of Thumb in Physical Database Design
I am starting my first post in my blog of tuning the physical database...

2012-03-17

All authors

Blogs

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...

Impactful Sessions I’ve Seen: T-SQL Tuesday #196

By

This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...

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