SQL Server

Fix AOAG Listener Error 19471: Kerberos Status is Showing The handle is Invalid

I was configuring AlwaysOn Availability Group between two replicas. Everything was configured successfully but Listener was failed to create with…

Why Should You Always Turn Off Database Auto Shrink Property?

SQL Server Auto Shrink is database property that allow database engine to automatically shrink database files if its value set…

Understanding Database Autogrowth in SQL Server

We use SQL Server database Autogrowth setting to automate database file growth. This property is very helpful if you use it…

How to Change Batch Size for Oracle to SQL Server Migration using SSMA

Migrating data from Oracle to SQL Server is very  complex process. Although, it has become little easy using SQL Server…

Understanding Backup Preferences for AlwaysOn Availability Group Databases

We know SQL Server Backups are resource intensive operation that strain on I/O and CPU (with backup compression). AlwaysOn Availability…

Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group

Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…

How to Find and Change IP Address, Subnet Mask & Default Gateway of Linux Server

Sometimes we need to check the IP, Subnet mask and default gateway of our Linux machine and sometimes we need…

Understanding SQL Server Backups

SQL Server Backups are the dump of its databases that can be used to recover them in case of any…

Fix SQL Server Error 19471: Listener issue that came during Configuring SQL Server AlwaysOn Availability Group

I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was…

Understanding SQL Server Recovery Model

A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not…