-
Recommendation: Vagrant and Veewee
Note: I’ve decided not to use Veewee due to silly compatibility issues for now. Quoting from Vagrant’s web site: Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual…
-
Increase disk size of VirtualBox Windows virtual machines
1. Shut down the VM if it is running; 2. On CLI, run: VBoxManage modifyhd /directory/myWindowsVM.vdi –resize numberInMB 3. Start VM -> Manage Computer -> Disk Management 4. If you want to give the space to the existing drive, right click on said drive -> Extend Volume… and follow instructions 5. If you want to…
-
Generating dimension data for dates
Most analytical and BI databases have date dimension table(s). One frequently needs to generate and populate such data. I present a solution below for such data generation, written in Python. Please use different database drivers/modules to connect to your specific database server (MySQL, SQL Server, Oracle, etc.) for data population. Notes: 1. It takes 2…
-
Sysinternals and PAL
Sysinternals and PAL (Performance Analysis of Logs) are two fantastic tools for general server information gathering and troubleshooting on Windows. Sysinternals suite is a set of tools that can be downloaded freely from Microsoft. One thing that is particularly attractive about them is that they can be run directly after downloading without special installation and…
-
Installing Perl DBI and DBD-mysql on Windows 64 bit
I had trouble getting Perl DBI and DBD-mysql on Windows in the past. In addition, on Windows 64-bit, you sometimes see recommendations of using 32-bit Perl. Today I got to test the latest 64-bit ActiveState Perl distro for Windows, version 5.12.3.1204. I tested it on Windows 2008 R2 64-bit. I am happy to report that…