Hemantgiri S. Goswami

Personal Details

Bio

Hemantgiri is a seasoned SQL Server Consultant with demonstrated history for close to 20 years. He is a published author specializing in High Availability and Disaster Recovery area. He was awarded Most Valuable Professional by Microsoft 4 times. He is a regular speaker at events in Surat. Hemantgiri is a founder and leader of the SQLPASS Chapter for Surat.

His mission statement is to help organizations make their SQL Server more reliable, and efficient.

Hemantgiri is published author of the book - SQL Server 2008 High Availability; a book for SQL Server DBA aspirants, System Administrators and Developers, it provides step-by-step information to get you through the installation of various SQL Server High Availability options like Clustering, Replication, Database Mirroring and Log Shipping.

Current position (3)

Sr. Consultant

SQL Server Consultant

Founder and President

Surat User Group

Moderator - MSDN Forums

Microsoft

Achievements (1)

Microsoft Most Valuable Professional 2021-22

Microsoft Award for Data Professional category for community contribution

Degrees (2)

MBA (Information System)

Sikkim Manipal University

2010 to 2012

B. Com.

Veer Narmad University

1996 to 2009

Presentations

Presentations (1)

Battle Tested Monitoring for Always On Availability Groups

You are the go-to guy for your company. You are not only coding but also administering
SQL Server in your organization. You've also implemented one of the coolest High Availability
feature – Always On Availability Group. However, you are not sure if you are monitoring everything that you should and you don't have a commercial tool to help.
Lately, there were some issues reported where you have seen AG is lagging behind, and it has eaten up your time and effort analyzing what went wrong
I can help you here!! I can share some of the monitoring scripts that I have written, and I can show you some monitoring tips that can help you. I would also like to help you with some of the metrics/counters that you would like to capture for analysis to make sure your Always On Availability Group is healthy. These are the things that you would love to try and implement in your environment. By the way, have you ever think of getting this monitoring via a Power BI tool? If not, ready to see the repo

Past talks (9)

Battle Tested Monitoring for Always On Availability Groups

SQL Saturday # 902

Kathmandu, Nepal

November 29, 2019

How SQL Server Stores Data Inside

Surat

January 9, 2016

SQL Server 2016 - New Features

Surat

January 9, 2016

Cloud Basics

Surat

January 9, 2016

Statistics and Performance Tuning

Surat

January 9, 2017

Global Azure Boot Camp

Surat

January 9, 2017

Always Encrypted

Surat

January 9, 2017

Always On Basic Group

Surat

January 9, 2017

Improving Service Broker performance

Surat

January 9, 2017

Reviews

Testimonials (1)

I know Hemant from last 13 years now and since last 10 years, we have been using his services both as a DBA & a Speaker. Basically, we arrange regular sessions in our office on different technical & non-technical topics on regular basis and when it come to selecting a speaker for MS SQL Server, we are left with NO CHOICES as IT HAS TO BE Hemant. Hemant has got very sound knowledge in MS SQL Server and in all these years we have found that he has got an answer to every question we throw at him. He is just awesome! We feel highly honored & lucky that we have got a SQL Geek who is easily approachable for any knowledge sharing activity we plan for. And a point on which I am jealous of him is his feedback score that he gets after the training session gets over - always 10/10 I highly recommend him as a Speaker & which him good luck!
Vinay Pugalia
Verified

Hemantgiri S. Goswami

Personal Details

Presentations

Books & Articles (4)

Expertise (10)

Awards & certifications (5)

Reviews