MySQL migration: MyISAM to InnoDB

MySQL migration: MyISAM to InnoDB   By Keith Winston on July 18, 2005 (8:00:00 AM) The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines, so you can choose among nine low-level table formats the one that suits your application… Leer más »

What is referential integrity?

  Simply put, referential integrity means that when a record in a table refers to a corresponding record in another table, that corresponding record will exist. Look at the following:

Backup – Restore SQL 2005

T-SQL code BACKUP: USE myDatabaseName GO BACKUP DATABASE myDatabaseNameTO DISK = ‘C:\filePath\myDatabaseName.bak’NAME = ‘The name of the back up.’   RESTORE: RESTORE databaseName FROM DISK = ‘C:\filePath\backupFilename’ Tags: backup, restore

RDP Remote Enable Utility

<download> This Utility will enable Remote Desktop connections on remote servers. UPDATE!! now it will also change the port number that RDP listens on. This is good to add a layer of security in. If you find this tool useful please think about a donation using the link below. File Attachment: RDPEnable.zip (597 KB)

Install HP LaserJet 1020 on Mac OSX.

Heres a recap for everyone to Install HP LaserJet 1020 on Mac OSX. 1) Download; http://www.narc.ca/1601-LJ_1022_Series_OSX.dmg (Old version) 2)If you have anything for the HP 1020 in «/Library/Reciepts» delete it. 3) Delete anything for the HP 1020 in Printer in «Printer Setup Utility» 4) Add new printer in «Printer Setup Utility», select HP LaserJet 1020,… Leer más »

Bleezer is a powerful blogging client. And it’s free

Why use Bleezer to blog? * Blog from anywhere. Work on Windows, OS X, and Linu * Work with any blogging service. As many as you want, even Blogger. * WYSIWYG editing. Edit your posts as they will actually appear. * Image upload. Images will automatically be uploaded to your server * Category support. Support… Leer más »