-
Install MySQLdb module for Python
Update: Commenter MarkR made a great point: if possible, use some packaging tools, to try to maintain proper dependencies, to the extent that is possible. Install from the source should be Plan B. So, try yum install MySQL-python first. This is mostly for my own future reference. It’ll be icing on the cake if it…
-
Windows disk throughput benchmark steps with sqlio
Credits to Linchi Shea, SQLServerPedia/Brent Ozar, and Jonathan Kehayias for their discussions on sqlio. Update: The test below, against one drive, can run for more than 1 hour. That is a long time. I’ve tested running 2 sqlio batch scripts against 2 locally attached drives, similar to the ones listed below, and found the results…
-
Parse sqlio log file with Python pyparsing
A few weeks ago I posted some questions on 3 Python text processing modules: pyparsing, SimpleParse, and NLTK. Today I need to analyze a log file generated by sqlio. I decided to use pyparsing. I am pretty pleased with it. I am aware that there are at least 2 utility scripts for this: one is…
-
Search objects in SQL Server databases with pyodbc
Command line utility to search for objects based on names. Search results will be displayed in well formatted tabular format, left-justified. 1. pyodbc installed; 2. Use trusted authentication by default. Find the relevant code to adjust to login/password as needed; 3. -w for wild card search. Default is exact name match, case insensitive in almost…
-
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…