Author Archives: Ramasankar

About Ramasankar

My name is Ramasankar Molleti, I have been working on various database and cloud systems (SQL Server, Oracle, PostgreSQL, DynamoDB, Redshift, Amazon, Azure) over 12 years, primarily focusing on Architect , Development, Administration and Business intelligence. I hold various Certifications such as Amazon Web services Solution Architect Associate, Microsoft certifications (Microsoft Certified Information Technology Professional, Microsoft Certified Technology Specialist, and Microsoft Certified Solution Associate).

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