Amazon EC2 Windows Server IIS , FileZilla and SQL Server Express

1,July,2011

This tutorial helps you understand how you could launch an EC2 instance quickly with FTP and SQL Server remote connectivity.

Note:  No method in this tutorial is considered safe and secure. This is just a basic tutorial which will help you setup an EC2 instance quickly, you would probably want to dump this instance in most cases or enhance your security parameters if you plan to continue using the created instance.

Launch an instance

...

READ MORE

Script to change case of mysql tables

1,July,2011

Here is  an SQL script that renames all tables in a mysql schema schema to its lower case form.

select concat('rename table ', table_name, ' to  temp' , ';','rename table temp to  ',  lower(table_name), ';' ) from information_schema.tables where table_schema = 'your-schema';

The above script generates SQL statements (which you can copy-paste) that will help you to change case of table names to lower....

Best of MVC Links

11,June,2011

For Starters

• http://channel9.msdn.com/blogs/matthijs/aspnet-mvc-2-basics-introduction-by-scott-hanselman
• READ MORE