Prevent documents from opening in the browser from SharePoint 2013

I recently had a SharePoint document library that housed Excel files. The browser would try to open the file in a tab in the browser itself. However, an error would occur with the services that allow this to happen. So I decided to tell SharePoint that when a file is clicked on, open it using the client software if it is available. To do this, go to the library in question, and click Library Settings. Choose Advanced Settings and set "Opening Documents in the Browser" to "Open in the client application".

Sign in as a different user in SharePoint 2013

Microsoft took away the menu option to Sign in as a different user.  This was invaluable to test sites to make sure everything looked right for different users or to test access.  There are a couple of ways you can still do this.  You can append this to the site address:

/_layouts/closeConnection.aspx?loginasanotheruser=true

Or you can hold down shift while right clicking the Internet Explorer option.  Then choose Run as different user.  Then navigate to the site.

The "12 Hive" location in SharePoint 2007

C:\ProgramFiles\Common Files\microsoft shared\Web Server Extensions\12

SharePoint 2007 Session Timeout

You can set the timeout of the session in SharePoint 2007 by opening up Central Administration, clicking Application Management, and clicking Manage Session State.

SharePoint 2007 - Determine Configuration Databases

It can be difficult to see which databases are used by which SharePoint farm especially when you have been experimenting with several different environments.

To see what databases are used simply open up Central Administration, and click Operations.  Then go to Perform a Backup.  On this page, you will see all of the configuration databases used by this farm.

Of course, if it's content databases you're interested in, simply go to the Content Databases page under Application Management.

Changing the SharePoint 2007 farm account password

When you first configure SharePoint 2007 and it's associated Shared Services Provider on a server, you specify a username and password in several places.  You will see this informally called the "farm account".  If this password ever gets changed, there are a few hoops you need to jump through in order for SharePoint to continue to function.  This page demonstrates the different steps to accomplish this.  I'll summarize here:

stsadm -o updatefarmcredentials -userlogin DOMAIN\USERNAME -password THEPASSWORD

iisreset /noforce

stsadm -o updateaccountpassword -userlogin DOMAIN\USERNAME -password THEPASSWORD –noadmin

stsadm -o spsearch -farmserviceaccount DOMAIN\USERNAME -farmservicepassword THEPASSWORD

stsadm -o spsearch -farmcontentaccessaccount DOMAIN\USERNAME -farmcontentaccesspassword THEPASSWORD

stsadm -o osearch -farmserviceaccount DOMAIN\USERNAME -farmservicepassword THEPASSWORD

stsadm -o editssp -title SharedServicesProviderName -ssplogin DOMAIN\USERNAME -ssppassword THEPASSWORD

iisreset /noforce

Go to the Shared Services Provider page, Search Settings, and click on the Default content access account.  Change the password here.