Category Archives: Uncategorized

Different ways to Monitor Deadlocks

Every database environment, deadlocks are common problems and it is important for DBA’s to monitor deadlocks and make sure to prevent them from reoccurring. There are multiple ways to monitor deadlocks Using Trace Flags  We can enable two trace flags 1204 … Continue reading

Posted in Database Administration, Deadlock, Uncategorized | Leave a comment

Find Missing Backups and send email notification

This is another useful script to find missing backups and send email notifications to DBA Cheers Hope you like the post! Ramasankar Molleti LinkedIn: LinkedIn Profile Twitter: Twitter

Posted in Uncategorized | Leave a comment

Free SQL Server 2016 Developer Edition

Earlier this month, Microsoft announced the general availability of SQL Server 2016 for Windows and Windows Server.  You can get started today with SQL Server 2016 Developer Edition, which is free and has all the features and capabilities of Enterprise Edition … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | Leave a comment

How To Change SQL Server Instance Collation After Installation

Last week one of the support team member contacted me for help how to change the collation without re-installing sql server. Team has installed and configured sql server but forgot to change the collation as per the customer application needs. … Continue reading

Posted in Uncategorized | Leave a comment