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 Server 2016 BOL states Database MirroringĀ feature will be removed in a future version of MicrosoftContinue reading “Database Mirroring = SQL Server 2016 AlwaysON Basic Availability Groups”

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. In order to do this, you would need a alerts setup so that you canContinue reading “Availability Groups Monitoring Alerts”

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 Alway on AG listener and automatically add this database to Availability groups. Here is theContinue reading “Powershell Script to Add New Database to Existing Availability Groups”