If you get stuck type resources and references

resetAdmin.txt

The situation is this... you can no longer get into the umbraco backoffice for one reason or another... trust me it happens!

So, there is a package you can download and it works in most cases:
https://our.umbraco.org/projects/developer-tools/umbraco-admin-reset/
With this package you simply upload the dll to the server via ftp and place it in the .bin folder and you can login in with Admin and Admin1234!

===================================================

however, if you are doing local dev with a compact SQL DB you will have to open the db in web matrix or similar then you can use this command:
UPDATE umbracoUser set userdisabled=0, userLogin='admin', userPassword='bnWxWyFdCueCcKrqniYK9iAS+7E=' where id=0
so, if you run this script against the DB, that sets the password to "default" - minus the quotes. SO after you get logged in, you can change the password to whatever you want.

====================================================

This one is exactly an umbraco thing... but let's say you are prepping an excel file for import INTO umbraco and you need some random email addresses is excel, well you can use this forumula:
=CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&"."&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&"@"&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&".com"

=====================================================