Category Archives: Always On Availability Groups

Database Mirroring = SQL Server 2016 AlwaysON Basic Availability Groups

Database Mirroring was one of the widely used feature since SQL Server 2005 until Microsoft announces Always On availability groups. Database Mirroring feature has been listed as deprecated ever since Availability groups have been introduced from SQL Server 2012. SQL … Continue reading

Posted in Always On Availability Groups, Database Administration | Leave a comment

Availability Groups Monitoring Alerts

You have setup the availability groups. How would know that the availability groups are running fine? All the good DBA’s always want to be notified via email when there are any issues related database servers not just only availability groups. … Continue reading

Posted in Always On Availability Groups, Database Administration | Leave a comment

Powershell Script to Add New Database to Existing Availability Groups

One of the common tasks for DBA to add the new database to existing availability groups. This can be┬ádone fairly easy via SSMS. The requirement is how to deploy the new database from Team Foundation Server (TFS) to SQL Server … Continue reading

Posted in Always On Availability Groups, Database Administration, Powershell | Leave a comment