Hemantgiri

With 25 years in the IT industry, I specialize in SQL Server and cloud technologies, holding certifications in ITIL , Azure, and Google Cloud. I have a proven track record of delivering reliable and efficient solutions across various clients and domains.

As a published author, speaker, and community leader, I am passionate about SQL Server high availability, disaster recovery, and capacity planning. I authored a book on SQL Server 2008 High Availability and have delivered presentations at technical events in Surat. Additionally, I founded and lead the SQL PASS Chapter in Surat, nurturing a vibrant SQL Server community.
  • Interests: Reading,Writing,Painting

All authors

All authors

Blogs

Fabric Mirroring doesn’t start copying Rows

By

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

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

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