Home » Archive

Articles in the Database Category

Database, Linux »

[8 May 2011 | No Comment | ]
How to Change or Set the MySQL Root Password

When you are setting up a database, it comes standard with the sa account that has access to everything. Unless you want to get comprised, you should change it to a difficult password. On some databases such as mySQL, the sa account is called root and it has a blank password.

Database »

[14 Feb 2011 | No Comment | ]
Useful MySQL Commands

If you support or use MySQL as your database backend, you will most likely be doing certain tasks over and over again. For example, once you have a table, you may want to modify the columns. Here are some commands that come in handy and can be used as a reference guide.

Database, Windows »

[12 Feb 2011 | No Comment | ]
Backup All SQL Server Databases

If you do Microsoft SQL Server Administration, you know how easy it is to back up your databases using the Enterprise Manager. Using the GUI comes with a price though. You sacrifice the ability to script what you are doing to other servers. What if you have other servers you want to backup all your SQL Server databases? How would you do it in the most effective way?

Database »

[8 Feb 2011 | No Comment | ]
Shrink SQL Server Log File

Question: I have a transaction log file in SQL Server 2000 that is over 1GB in size. Does it need to be this big? How do I shrink it to a small size such as 10MB?