How to administer SQLExpress using Microsft SQL Server Management Studio

All you need to do it put in the server name followed by sqlexpress
EG:   sqlserversqlexpress and you can connect and manage it.

You will need to know a local password user such as SA for SQL authentication, or be logged into the server with a Windows  administrator account that the same on both the management server and the SQLexpress server if you use Windows authentication.

How to install LAMP on Ubuntu

I have been looking at the easiest way to get a LAMP server up and running in minutes.

I found the following command  and it works like a charm!

sudo apt-get  install lamp-server^ phpmyadmin


Follow the on screen prompts and you are good to go!

How to change the IP address on Ubuntu Linux

Type the following command   sudo nano /etc/network/interfaces

Find auto eth0 and edit the lines below.

If it is set for DHCP and you want to change it, change the following lines from:

iface eth0 inet dhcp

To something like this for example: (please use your own network IP addresses , DNS servers and domain name where applicable)

iface eth0 inet static

How to allow only traffic from your Elastic load balancers to access your web servers on Amzon EC2

I wanted to modify a security group on some web servers that were behind an elastic load balancer so that they would only accept traffic from the load balancers. The problem was that  I wasn’t sure what IP address or security group to allow. As the IP would change all of the time, you just need to allow this built-in group as the source for your port: amazon-elb/amazon-elb-sg.

This will just permit YOUR load balancers to reach your webservers on your chosen ports such as 80 and 443, and you will notice that it will be renamed in the amazon console to something like this amazon-elb/sg-x00xx000 (amazon-elb-sg) .