Author Archives: Ramasankar

About Ramasankar

My name is Ramasankar Molleti, and I have been working on sql server over 10 years, primarily focusing on Database Administration, Architect , Development and Business intelligence of sql server. I also 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 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

Advertisements
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

New SQL Server 2016 Online Alter column

Over the few months i have been playing with SQL Server 2016 new features. Microsoft SQL Server 2016 introduced new alter column with ONLINE option. Let’s explore this. Create a table and insert data    Find what page has been allocated … Continue reading

Posted in Database Administration, SQL Server 2016, T-SQL | Leave a comment