-
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 […]