Brain

It knows all that is computer related

Tagged:  •    •    •  

The following T-SQL script will extract all data/log files for the currently attached databases, and then scan all of those directories to find files that are not being used by SQL Server. This will quickly locate mdf, ldf or ndf files located in your data and log directories to free up space.

Tagged:  •  

The follow is a short how to for creating a private network, for instance used as cross-over type connections amongst two virtual machines. This was doing using Windows version of VMware Server, with Fedora 8 as the guest OS.

Tagged:  •  

DRBD acts as a virtual layer between the OS file system and the raw disk device (or can actually work against LVM devices). Hence the reason for having a kernel module. To setup a second raw disk device on our VMware images, you can perform the following steps, with the guest powered off.

Add New Virtual Disk 

Tagged:  •    •  

This will compile and install DRBD on Fedora 8. The following steps were run against a bare Fedora system, kernel 2.6.23.9-85.fc8, and DRBD 8.2.1.

Prework

Tagged:  •  

This is a guide to configure and install Fedora 8 as guest virtual machine in VMware Server. To download VMware Server, you will need to create a login and obtain a free license key from VMware's website. This was done using the Windows version of VMware Server 1.0.4.  Steps should be the same for Linux based host OS's.

Tagged:  •    •    •  

Ever wonder when the last time your table stats where updated (perhaps done automatically because auto_stats is on?).

Tagged:  •    •  
The following VBScript will backup all MySQL databases on the localhost to a directory and maintain 10 days worth of backups
Tagged:  •    •  
This shell script will find the nearest (relative to ping latency) CVSUP server to get your source updates from

A list of applications that has passed the Andy meter as
being top quality, grade A computing fun. I found most from another
great OSDN website, Freshmeat:

Databases
MySQL - A very popular, very fast (for SELECTs) database
PostgreSQL - A very complete ANSI-SQL dbms unlike MySQL

Operating Systems
FreeBSD - Very stable and very cool OS

Tagged:  •    •    •  
The following VBScript will retrieve the current hotfix for a specified SQL 2005 Server, and return that hotfix as a the return code. Useful in batch files for selectively applying unattended service packs.