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

Claude Code Helps Analyze Test Data Manager Log Files

By

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Read the latest Blogs

Forums

Is it uncommon for Dev's to have a data model of the source data

By Coffee_&_SQL

This is a generic question. To the moderators, I wasn't sure where to place...

ROLLUP to calculate Month total for all Categories

By Reh23

Good Afternoon, I have built a table with four columns:  Period(Month), Category, Numerator, Denominator....

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

By Bill Pearson

Comments posted to this topic are about the item Level 28: DAX Text Functions:...

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code: 

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers