SQL Server Citation

16/02/2026

Very happy to share a milestone from this week 🙏

Successfully completed a rolling upgrade of a 4-node SQL Server cluster from SQL Server 2022 to SQL Server 2025 for a prestigious government project.

No downtime. No disruption. Clean ex*****on.

Rolling upgrades in clustered environments require careful planning, coordination, and disciplined ex*****on — especially in high-visibility environments.

Proud of how smoothly this one went and thankful for the excellent collaboration with the client’s engineering and infrastructure teams.

Moments like this remind me why I love working on complex SQL Server environments.

On to the next challenge.
—
Hemantgiri Goswami
SQL Server Citation | https://sqlservercitation.com

We can help you make your SQL Server more efficient and reliable. Let’s work together to achieve your organization goal.

12/11/2025

🎉 Exciting News — SQL Server Citation™ is now a Registered Trademark!

I’m delighted to share that SQL Server Citation™ has officially been recognized and published in the Indian Trade Marks Journal (May 2024) under Class 09 and Class 42, covering both software and consultancy services.

This milestone represents more than a registration — it’s a validation of years of consistent work, credibility, and client trust.
From our beginnings as a knowledge-sharing initiative to becoming a recognized consulting brand, SQL Server Citation stands for reliability, technical depth, and integrity in database consulting — across SQL Server, PostgreSQL, and MySQL platforms.

This trademark strengthens our brand identity and reinforces our long-term commitment to:
✅ Delivering dependable, transparent consulting services
✅ Maintaining authenticity in every engagement
✅ Building lasting trust with our clients and partners

A heartfelt thank you to all clients, peers, and well-wishers who’ve supported this journey. The best is yet to come!

(Images below: Trademark certificates for Class 09 — Software, and Class 42 — Software Consultancy.)

13/04/2025

After many years, I had the pleasure of delivering a corporate training session on Always On Availability Groups for a batch of 20+ professionals — all hands-on, all practical.

It was incredibly rewarding to share my real-world experience configuring and managing High Availability and Disaster Recovery solutions. The participants were fully engaged and enjoyed the session as much as I did!
Of course, I made sure to say a little prayer to the Demo God before starting — and this time, they answered! Every demo went off without a hitch 🙌

Looking forward to more such enriching sessions!

16/05/2024

Create failed for Availability Group

One of my clients received an error Create failed for Availability Group while creating Always on Availability Group.

15/05/2024

Common Mistakes in SQL Server – Part 5

This week, I am going to explain a very important thing that is often skipped. It is a common mistake that can indeed lead to performance problems. Implicit Conversion can cause unexpected performance issues and hinder query optimization. This week in Common Mistakes in SQL Server - Part 5 let's spe...

14/05/2024

Common Mistakes in SQL Server – Part 1

I’ve worked on many projects where in the significant amount of work comes for Performance and Tuning, the first approach is to identify the culprit and quick fix it and the next course of action would be to fix it permanently. In this series of articles I will be sharing the common mistakes in SQ...

13/05/2024

How to Secure SQL Server

Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. In this article I share some of the pointers that can help you understand How to Secure SQL Server. At times when applications are run in...

12/05/2024

SQL Server Blog quarterly review

This SQL Server blog roll talks about the few blog articles I have published in last couple of months. I am certain you would like reading

11/05/2024

Common Mistakes in SQL Server – Part 6

recompilation is a valuable tool in SQL Server when you want to ensure that your queries are using the most appropriate ex*****on plans.

10/05/2024

SQL Server Security Checklist

In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can be used as SQL Server Security Best Practice Checklist as well