Author: Hemantgiri Goswami

The Importance of the Worker Threads in Always On

Most of my blog posts are an outcome of the work that I do over the weekend while holding the pager for my team. This blog post is no different. In this blog post, I will talk about the importance…

Read More >

Fixing could not start Service Broker for database

Blogging is something I love because it gives me a chance to share the ideas I have and the knowledge I have gained so far. Last week, one of our clients was doing some maintenance activity. Today’s blog post comes…

Read More >

The Life of a Happy Remote DBA

Life is a balancing act between the personal and professional. It is a journey and this journey should be filled with joy and happiness. It should also give you a chance to learn, to grow and to cherish moments, spending…

Read More >

SQL Server 2016 : A New Security Feature – Always Encrypted

Hemantgiri Goswami, Microsoft SQL Server MVP and Lead Database Consultant, explains the new Always Encrypted security feature on SQL Server 2016.

Read More >

Resolving Update-Update Conflict in Peer-to-Peer Replication

Hemantgiri Goswami, Microsoft SQL Server MVP and Lead Database Consultant, discusses how to resolve an Update-Update Conflict in Peer-to-Peer Replication in SQL.

Read More >

SQL Server 2016 – AlwaysOn Basic Availability Group

Hemantgiri S. Goswami, Pythian database expert and SQL Server MVP, discusses a new feature, Basic Availability Groups for AlwaysOn, found in SQL Server 2016

Read More >

Import/Export Multiple SSIS Packages

While I was working on a migration project recently, I had the task of importing and then exporting multiple packages – about 120~ on to a new server. Usually, if there are less numbers of packages we can do this task manually…

Read More >

Reading System Logs: SQL Server – Part 2

Greetings! Last time I talked about reading System Logs on the SQL Server box, explaining why it is really important that DBA(s) should scan through the logs once a day on a critical production system. As I mentioned in my previous…

Read More >

Reading System Logs on SQL Server

Recently, while I was working on a backup failure issue, I found that it was failing for a particular database. When I ran the backup manually to a different folder it would complete successfully, but not on the folder that it…

Read More >

SQL Server and OS Error 1117, Error 9001, Error 823

Along with other administrators, life of us, the DBAs are no different but full of adventure.  At times, we encounter an issue which is very new for us, rather, one that we have not faced in the past.  Today, I…

Read More >
Page 1 of 3123