The Ji Village News

Author: Haidong Ji

  • Problem: Fedora Core 2 as Virtual PC on Windows

    Today I tried to install Linux as a guest OS on Windows Virtual PC. I got Fedora Core 2 late last year during a training. So that is what I tried. I picked “Other” OS and created a new virtual disk. Installation started and I picked Graphic mode installation. The Anaconda hardware probing processing started.…

  • Musical, New York City, and Memories

    We saw Joseph and the Amazing Techincolor Dreamcoat on Sunday at the Auditorium Theatre in Chicago. It was a wonderful experience. Joseph was the second live musical I saw. The first is Cats. We saw it on Broadway in New York City in 1998, the year before Benjamin was born. At the time, I was…

  • Randy’s posts on planning, career development, and training

    Wow, PASS board member and Sql Server guru Randy Dyess is on a roll. I love his posts on planning, career development, and training. Very candid, thoughtful, and insightful. I sure learned a lot from them.

  • Find out date and time of the last database restore

    Sometimes you may have the need to find out the date and time a particular database was last restored. Here is a simple way to do it. It should work in both SQL Server 2000 and SQL Server 2005: use msdb select max(restore_date) from restorehistory where destination_database_name = ‘MyDatabaseName’

  • Set sqlcmd initialization file

    By now you probably can tell that I am a big fan of sqlcmd;) Here is one more nugget on sqlcmd that I can throw at you: You can set a variable so that sqlcmd would run a query whenever you launch it from the command line interactively. For example, you can let it run…