Author Archives: Ramasankar

About Ramasankar

My name is Ramasankar Molleti, and I have been working on various database systems (SQL Server, Oracle, Postgres, DynamoDB, Redshift) over 10 years, primarily focusing on Database Administration, Architect , Development and Business intelligence. I also have working experience on Amazon Web Services DevOps. I hold various Microsoft certifications (Microsoft Certified Information Technology Professional, Microsoft Certified Technology Specialist, and Microsoft Certified Solution Associate). Disclaimer The views expressed on this website/blog are mine alone and do not reflect the views of my company. All postings on this blog are provided “AS IS” with no warranties, and confers no rights. The owner of https://sqlram.wordpress.com will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of this information.

How to Backup SQL Server Backups to Amazon S3 Storage

It’s been a long time since i posted in my blog. One of the common request i have been asked by my colleagues, friends about “Is there a way to automate backups that are taken on the SQL Server database … Continue reading

Posted in Uncategorized | Leave a comment

How to kill all the sessions in postgreSQL database

The below script will be used to kill all the sessions except your session. If you are looking for specific process id then you can provide the pid value in the where clause as below   Hope you enjoyed the post! Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter    

Continue reading

Posted in PostgreSQL | Leave a comment

Powershell Script to change IIS AppPool

Posted in IIS, Powershell | Leave a comment

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

How to debug SSIS package

You or your team or someone has written an SSIS package which is running flawlessly over few days/months/years. One fine day SSIS package is failing continuously and you need to troubleshoot and fix the issue. Error message is not showing … Continue reading

Posted in Database Administration, SSIS | 1 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

Cumulative Update #4 for SQL Server 2012 SP3

Microsoft announced the 4th cumulative update release for SQL Server 2012 SP3 is now available for download at the Microsoft Support site. For original post you may refer here  Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

Posted in Database Administration | Leave a comment