Category Archives: Uncategorized

Lambda to delete indices older than ‘x’ days on Elastic Search

This is simple example of how we can delete the indices older than ‘x’ days. This example needs aws4auth, elasticsearch, curator modules installed. You can build these modules on using linux machine. I’ve used one of the ec2 instance that … Continue reading

Posted in Uncategorized | Leave a comment

AWS Lambda to connect to PostgreSQL and execute a function/query using Python

It’s been long time since i wrote a blog post. In this post i would like to show an example of lambda to connect to PostgreSQL database and execute the query. Build a PostgreSQL psycopg module in order to connect … Continue reading

Posted in AWS, PostgreSQL, Uncategorized | 5 Comments

Powershell Script to change all windows scheduled tasks credentials

One of my student asked me is there any simple script to update all windows scheduled tasks credentials in one step. Here is a simple way to do Hope you enjoyed the post! Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

Posted in Uncategorized | Leave a comment

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 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