One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure.
The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state.
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this.