Monitoring status of AWS EC2 Snapshots within Nagios

I recently wrote a script to automate the creation of snapshots for EBS volumes for Amazon EC2 instances (https://deangrant.wordpress.com/2013/08/06/aws-create-ec2-snapshot-based-on-metadata-tag-value/). Following on from this I wanted to report the status of snapshots completed and return this status to Nagios. This was to be achieved by comparing the number of EBS volumes that contained a specific metadata tag … More Monitoring status of AWS EC2 Snapshots within Nagios

New paravirtual driver for Amazon EC2 instances

So Amazon have announced a release of a new Amazon Machine Image for Microsoft Windows Server 2003 R2, 2008 and 2008 R2 which now includes a new pararitualized driver, which according to Amazon provides the following benefits: Launch any Microsoft Windows Server AMI (2003 R2 to 2012, 64 bit) on any instance type Increase your Microsoft … More New paravirtual driver for Amazon EC2 instances

Working with SQL collation on Amazon Web Services instances

So when deploying a Amazon Machine Image (AMI) to a new instance in Amazon Web Services EC2 where SQL Server is installed as part of the AMI, you inherit the SQL server collation for that particular install. This is one issue I have experienced where the SQL Server collation of the AMI has been ‘SQL_Latin1_General_CI_AS’ and I … More Working with SQL collation on Amazon Web Services instances