The Ji Village News

Category: Technology

  • Installing Windows 7 on Samsung N120 Netbook

    Installing software on a netbook is tricky, as there is no CD/DVD-ROM drive on it. One could buy a usb-attached CD/DVD-ROM for it. It is also possible to do it with usb thumb drive and usb disk drive. I have Western Digital’s usb disk drive, and that was what I used to install Windows 7…

  • SQL Server Database snapshot as a change control tool

    Microsoft introduced database snapshot in Sql Server 2005. It is used to keep a point-in-time snapshot of the database state at the time the snapshot was taken. It is also good for reporting purposes when database mirroring is implemented, because while a mirroring partner database is not accessible, one can produce a snapshot of that…

  • SQL code for SQL and Relational Theory

    I am reading SQL and Relational Theory by C. J. Date. Baron Schwartz wrote a nice review for it. I am reading the online version, about half way through, so am not sure if it has an accompanying CD with source code. In any case, if you want to play with some SQL code listed…

  • Perl script to split sql script into separate files

    Below is a quick script I put together to split one single file that contains many stored procedures into many files that contain just a single stored procedure. It can be easily modified for views, user-defined functions, etc.. Notes: 1. It does put BEGIN and END before and after the procedure creation. Because some script…

  • Calling MySQL fans in the near west suburb of Chicago

    I’ve been to the Chicago MySQL meetups a few times at Uncommon Ground near Wriggly Field. Honestly I don’t think I gained much out of it. The few times I was there, the group was small, which is not necessarily bad. (In fact, a small group can even be a good thing.) But the thing…