Super quick overview: When you type Stevepavlina.com you are first going to query a DNS. That will tell you what IP address steve's site is hosted on. Once you get on there the server will give you the files that you requested.
He probably has leased a server somewhere. Probably not his home computer.
check out wikipedia.com for more details