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”

Forgot SQL Server “SA” password? Don’t Worry

Hi Rama, Need your help. I forgot the “SA” password and I am unable to access to SQL Server via windows/sql authentication.  Is there any way we can recover the “SA” account? Hello Vamshi, Yes, we can as long as you are able to RDP and you are a built in administrator to your windows box.Continue reading “Forgot SQL Server “SA” password? Don’t Worry”

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”

SSIS Error – The Binary code for the script is not found

Application team reported me that one of the SSIS package is failing after recent changes. It was failing with message “Binary Code for the script is not found” I have been asked to troubleshoot the issue. I have opened the SSIS package in SQL Server Data tools and try to run the package from SSDT.Continue reading “SSIS Error – The Binary code for the script is not found”

Query Store – Key feature in SQL Server 2016

As a DBA, how many times you hear about a user reporting that a query suddenly running more slowly than in the past? SQL Agent job usually takes 3 hours , but this is running more than 12 hours, Could you please investigate? What would you do in this case? There are number of commonContinue reading “Query Store – Key feature in SQL Server 2016”