How To Restore Corrupted System Databases

How To Restore Corrupted System Databases

Today Dec 31, Sunday. Everybody waiting for the New Year. I’m also waiting for that and enjoying the last holiday of this year. But my SQL server doesn’t like the 2018 I guess 🙁 We have migrated our SQL Datawarehouse from Datacenter to AWS. We followed block level copying method which means sent entire Disks data to AWS then create volumes from that data. We kept data and logs on different disks.

Read More

Configure Bucardo replication on CentOS

configure bucardo replication centos

I was working with a migration process to migrate the Postgresql Database from Ec2(centos) to AWS RDS. Since I did many migrations to RDS but this is my first migration with Postgresql. The challenge was the source database in Postgresql 9.2 and I wanted to 9.6 on RDS. So decided to configure bucardo replication centos.

Read More

Postgresql Insecure directory in ENV PATH – Unable To Start

Postgrsql Insecure directory in env path

Insecure directory in $ENV{PATH}

I was discussing with one of my friend who is a Developer, as he was working with PostgreSQL 9.5 in Ubuntu 16.04LTS from past few months. But suddenly he couldn’t able to start PostgreSQL service. He tried to reinstall PostgreSQL many times, but no luck. So he gave his laptop to me and asked to fix this issue.(Because of Im a DBA 🙂 ). The very first thing I started to look at the Postgresql logs. Unfortunately, nothing was there. So I checked the syslog file and found something wrong. It was showing the error in Postgrsql Insecure directory in env path.

Read More

SQL Server Availability Group without Cluster And AD In Windows

SQL Server Availability Group without Cluster And AD In Windows
SQL Server Availability Group without Cluster – Dear DBAs, Do you think is this possible? Luckily yes, its possible to create an availability group without a Windows Failover Cluster on Windows. But unfortunately, there are few restrictions. Also, we don’t need to restore the Database on secondary. The availability group has a feature called Automatic Seeding to restore the database automatically from the Primary server.

Read More

How To Handling DBA Tasks In SQL Server On Linux

Handling DBA Tasks In SQL Server On Linux

Handling DBA Tasks In SQL Server On Linux

Hello SQL DBAs, the time has been already arrived to move to the Open Source Community. After a very long time, Microsoft Released the stable version of SQL Server for Linux. Also, Microsoft provides perfect documentation to configure everything.  So we(DBAs) needs to work on SQL server in Linux. So this blog post is nothing but will provide some useful information to handling DBA tasks in SQL Server on Linux.

Read More