Murphy walks among us. You know Murphy, the famous "optimist" who helps make every bad situations even worse? Well, after a disaster has occurred is not the time to figure out how and where you need to recover your data. Sure, we practice (ok, hopefully we practice!) recovering our database(s) from tape or disk. And during our testing we restore it into a test database or, if we’re lucky enough, into a test server. Great, but how does the application connect to the recovered database if we’ve run into a massive hardware (server) failure?

There are a variety of ways to determine which version of SQL Server you are running. While the @@version information will tell you the current version
SELECT @@version
SELECT LTRIM(RIGHT(LEFT(@@VERSION,38),9))

The following code will as well, and in a slightly different format:
SELECT 'SQL Server '

There are a variety of ways to change your MySQL password.  One of the easiest is from the command line.  You can use a command like:

 mysqladmin -u root password yourrootsqlpassword

to change your password.  The above command changes the password of the acount root to yourrootsqlpassword.

MySQL is a free database available from My SQL AB (www.mysql.com). This database is a fully relational database environment and there are several tools available to help you manage the database.

User Management

What is a database? A database is a container of related data, usually identified by data stored in tabular, row-column format. This differs from a datastore in that a datastore usually refers to a single object. A datastore could be a PDF (Adobe Acrobat format) document, a word processing document, a picture, or some other format or document.

The most common format for databases is now SQL or Structured Query Language. This is an international standard, although there is no formal certification process to determine compliance with the published standard.