You can use geography data type in SQL Server but only if you use SQL Server 2008. Does not matter if it is SQL Express. It is not supported (yet, may be in SU3) in SQL Azure although SQL Azure is version 2008. But then it is only 10.25 and not 10.5.
You want a jump start follow this link: