Makhshif Tanvir·Dec 26, 2025Understanding and Resolving ACTIVE_TRANSACTION in SQL Server Transaction LogsTransaction log growth is a common operational challenge in SQL Server environments. One frequently encountered reason for uncontrolled log…
Makhshif Tanvir·Aug 13, 2025Cluster management using PCS (Pacemaker/Corosync Configuration System) and STONITHPCS is a cluster management tool used to configure and manage high-availability clusters on Linux. Its main goals:
Makhshif Tanvir·Jul 29, 2025How to Kill a Backup Job in Dell NetWorkerIn backup environments managed by Dell EMC NetWorker, you might occasionally encounter a stuck, hanging, or unwanted backup job. When that…
Makhshif Tanvir·May 19, 2025Setup Emails using Database mail in SSMS (SQL Server management studio)Automation is essential for every repetitive task these days so is the configuration of database health reports. This where the Database…
Makhshif Tanvir·Jan 30, 2025A specified logon session does not exist. It may already have been terminatedYou may encounter this error on task scheduler while creating a task as administartor:
Makhshif Tanvir·Jan 15, 2025Setting Up a Percona PostgreSQL Cluster Using Patroni, etcd, HAProxy, Keepalived.In this blog, I’ll walk you through step-by-step instructions to set up a highly available Percona PostgreSQL cluster using open-source…A response icon1A response icon1
Makhshif Tanvir·Jul 25, 2024MSSQL: Saving changes is not permitted.TheI was modifying the length of a column in my MSSQL table and was getting the error in subject. The error message you are seeing indicates…
Makhshif Tanvir·Jul 24, 2024Seamless Failover with Keepalived and PostgreSQL Streaming ReplicationEnsuring the high availability of your database is crucial for maintaining uninterrupted service and data integrity. PostgreSQL, renowned…A response icon1A response icon1
Makhshif Tanvir·Jul 24, 2024Resolving SQL71627 Error When Creating a BACPAC File for SQL DatabaseWhen migrating an on-premises SQL Server database to Azure SQL Database, you might encounter various errors and issues. One such error is…
Makhshif Tanvir·May 20, 2024Resolving the “User, group, or role already exists in the current database (Microsoft SQL Server…If you’ve ever worked with SQL Server Management Studio (SSMS), you might have encountered the frustrating error: