Category Archives: Uncategorized

How to Migrate SQL Server Database running on EC2 instance to Amazon RDS Instance

Recently i worked on migrating sql server databases running on amazon EC2 instances to Amazon RDS instances. Starting from 27th Jul 2016 Amazon announced you can ship your databases from ec2 to rds using native backup and restore method. Let’s see … Continue reading

Posted in Uncategorized | Leave a comment

Script to get SQL Server Error logs via Email

This is one of the handy script to get sql server error logs via email. Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

Posted in Uncategorized | Leave a comment

The SQL Server Basic Installer: Just Install it in three clicks

Microsoft introduced the new Basic Installer experience for SQL Server 2016 Express, SQL Server 2016 Developer, and SQL Server 2016 Evaluation Editions. Just three clicks you can get a default installation of these editions. You may check full details here Cheers … Continue reading

Posted in Uncategorized | Leave a comment

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