-
SSH without typing password using public key
I’ve done transferring public key id_rsa.pub (or id_dsa.pub and identity.pub) and appending that to authorized_keys (or authorized_keys2) file on remote host many times in the past, but the last time I did that was a bit over 2 months ago. Today I wanted to write a Python script for blog database backup and copying to…
-
Getting rid of “Welcome to Internet Explorer 8” screen
The lack of Vimperator function in Chrome, which exists in Firefox, prevents me from totally switching to it. Because I work in different environments in terms of different clients and operating systems, I have to use Internet Explorer sometimes. And I found the “Welcome to Internet Explorer 8” screen upon IE starting, if you have…
-
List all database files in a SQL Server instance with Python and pyodbc
For SQL Server management from Linux, I’ve used pymssql on Linux before, but realized lately that it is hard to configure with the heterogeneous environment I am in. So I am giving pyodbc a try. The install on Windows is simple. Listed below is some code that I put together quickly for some testing. It…
-
Notes for mounting Amazon EBS block device
I needed a disk that is around 1 TB for testing on Windows 2008, and noticed that EC2 Extra Large Instance (API name m1.xlarge) satisfies that requirement. But after launching it via AWS Management Console and remote into the server, I noticed I only got 30 GB, far less than the 1690 GB that was…
-
SQL Server 2008 R2 unattended installation via configuration file
I wrote about unattened install of SQL Server 2008 R2 here, where all parameters were entered on the command line directly. Another way, perhaps a better way, of automation is to put all parameters in a configuration file. Here is a sample: [sourcecode language=”text”] [SQLSERVER2008] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or…