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

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

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

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

By rdr1

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

data compare between 2 tables with same structure for any changes after etl run

By syam.tunuguntla

i have huge table with lot of data and is also wide. i took...

Visit the forum

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  1960
If I run this code, what document(s) is/are returned? 
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers