Backup & Restore MS SQL 2000 Database

This is a short note I used at work to back up and restore the a MS SQL 2000 database. I have a database with the name abcengine running on a local SQL Server. I need to back up this datbase to a file, send it over to a remote SQL Server to restore it. There are two ways, which I’ve known, to back up a database. One of them is to use the Enterprise Manager to virsually back up, and another way is to use the Query Analyzer, writing the T-SQL code and run it. ...

January 15, 2009 · 2 min · 274 words · kenno

Python MySQLdb package for Debian

I try to use MySQLdb module with my Python code for the first time. This is what I see: import MySQLdb Traceback (most recent call last): File "", line 1, in ImportError: No module named MySQLdb your code here For Debian, the package for MySQLdb module is python-mysqldb. # apt-get install python-mysqldb Now, let’s verify if MySQLdb module has been correctly installed: >>> import MySQLdb >>> No more import error message, which means you can start using MySQldb module now.

November 9, 2008 · 1 min · 80 words · kenno

IIS7 - Cannot read configuration file due to insufficient permissions

The last time I intensively used IIS (Internet Information Services) was back in the year 2000 when I hosted a ASP site on the local Windows 2000 server. Since then, Apache has become my only friend in the web server world. Fast forward to present day with the current job where Microsoft technology is heavily based on, it’s time for me to get back on track with “almost-everything” Microsoft. Today, I tried to set up an Asp.net site on my local machine with IIS7, and I got the following error: ...

October 23, 2008 · 1 min · 121 words · kenno

Deleted folder keeps reappearing

A while back, I let my brother using my laptop while he was waiting for his to arried from online order. My laptop has dual boot: Windows Vista Home Premium and Debian. Of course, my bro would only use Vista. He created a folder with his name on the desktop for whatever purpose it was. Let’s called it: Evil. When the laptop was returned to me, I wanted to get rid that Evil. No matter how many times I tried delete it, it kept coming back. I turned to Google for solution hoping someone on the Interweb experienced the same thing, but it wasn’t helpful either. ...

July 11, 2008 · 2 min · 238 words · kenno

Visual Studio Shortcuts

This is an ongoing list of shortcuts used in Visual Studio 2005. Go To Definition: Ctrl + F12 Go to line number: Ctrl + G To comment a block of code: Ctrl + E + C To uncomment a block of code: Ctrl + E + U

June 17, 2008 · 1 min · 47 words · kenno