SQL Server Citation

SQL Server Citation Remote DBA, Microsoft SQL Server, High Availability, Health Review, Performance tuning Thanks for your time to read through my blog posts.

SQL Server Citation is evolved as a content rich blog over years, initially my idea was to post articles here just for the sake of my knowledge and reference. Eventually, I started posting more frequently and amazed to see that other people are also reading my blog articles :)

I tried to post tips and tricks, and some time how to kind of article that interests me and I think SQL Server community will get benefited.

Very happy to share a milestone from this week 🙏Successfully completed a rolling upgrade of a 4-node SQL Server cluster ...
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.

🎉 Exciting News — SQL Server Citation™ is now a Registered Trademark!I’m delighted to share that SQL Server Citation™ ha...
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!

Create failed for Availability Group
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.

Common Mistakes in SQL Server – Part 5
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...

Common Mistakes in SQL Server – Part 1
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...

How to Secure SQL Server
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...

SQL Server Blog quarterly review
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

Common Mistakes in SQL Server – Part 6
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.

SQL Server Security Checklist
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

Address

Surat
395003

Opening Hours

Monday 10am - 7pm
Tuesday 10am - 7pm
Wednesday 10am - 7pm
Thursday 10am - 7pm
Friday 10am - 7pm

Telephone

+918320333642

Alerts

Be the first to know and let us send you an email when SQL Server Citation posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to SQL Server Citation:

Share