Library changes

I haven’t been to my local library in many years, in fact I think the last time I went to one was back in high school. They have embraced technology and is now more convenient to use their services. They have added and are using updated computers. Also, you can now use 1 library card…

How to convert MSSQL date format to MySQL

I recently had to transfer over some databases from MSSQL Server 2000 to MySQL. Unfortunately, the date format that MSSQL keeps is MM-DD-YYYY HH:MM:SS am/pm. MySQL uses YYYY-MM-DD HH:MM:SS (24hour format). For example, 8/14/2007 5:00:00 PM (MSSQL format) and 2007-08-14 17:00:00 (MySQL format). In MySQL, we can use the date_format(). But what is the equivalent…

New toys from Apple

Today Apple held a conference at their Northern California headquarters. As expected, they unveiled the redesigned iMacs and keyboards. They also released the new versions of iWork 08 and iLife 08. I’m really excited to see the new features iLife has to offer. I’m trying to download the video now. It’s over 20 minutes. A…

I got my MBP back

This is the process I went through when I dealt with Apple and repairs on my Macbook Pro. Here’s the timeline: July 15th: Went to an Apple store and had a genius look at it. He created a ticket and suggested to ship the laptop to the repair center. July 17th: Box to send the…