To flatten a dimensional model built in Excel using pivot tables, follow these steps: save the original worksheet with the pivot table as a CSV (tab delimited is even better) select the range or column that contains the blanks (if you have blanks under the header, don’t select the column header in the range) select [...]
Setting up FileZilla for connecting to the server (first time only)
Start FileZilla. I’m using FileZilla 3.5.0 for this tutorial, but the steps should be the same in any recent version. We will start by creating a new site in FileZilla so that we won’t have to fill the credentials every time we would like to connect to the server. Open File > Site Manager… and [...]
PC LAW upgrade instructions
Here are the latest links form Lexis Nexis on PC LAW upgrade: http://www.lexisnexis.com/law-firm-practice-management/pclaw/?content=for-customers http://support.lexisnexis.com/pclaw10/record.asp?ArticleID=10609
OpenVPN connects, but no ping
OpenVPN connection issue on Windows Vista and Windows 7 Problem When connecting to an OpenVPN tunnel on Windows Vista or Windows 7, the OpenVPN GUI shows the connection as successful, but the protected network can not be reached. Solution Start OpenVPN as administrator. This is necessary even of the account launching OpenVPN is an administrator [...]
Installing a Secure Certificate on IBM Smart Business Server (VERDE)
At the time of this writing, the IBM Smart Business Server’s control panel doesn’t allow importing a secure certificate (SSL cert). Never-the-less it is possible to install a valid (CA signed) secure certificate from the command line. This article assumes that the reader is familiar with SSL and the basic SSL KEY, CSR, and CRT [...]
Migrating Data Between DB2 Servers
DB2 Support for Data Migration When it is time to upgrade from DB2 on Intel to DB2 on Power for example, taking a backup/restore approach isn’t possible as DB2′s backups are platform dependent. The solution is to use a DB2 command called db2move. Basics of db2move db2move allows to export data from DB2 at different [...]
Planning for Storage, Server, and Network Infrastructure
Questions to ask when planning storage and server infrastructure Storage Requirements What our their current storage environment? (What technology do we use? NetApp, EMC, HP, Hitachi, Compellant?) What is our current amount of usable storage? What is our current data in GB / TB? How much of that data is deemed critical as opposed to [...]
Remove old or bogus address form Outlook email auto-complete address book
Problem As a result of people changing their email address, or just simple typos, the MS Outlook auto-complete list ends up with a number of bogus queries. Solution To remove a name or email address from Outlook’s auto-complete list, simply follow these 4 steps: Create a new email message in Outlook (don’t worry, you can [...]
NetApp downgrade firmware
Downgrading firmware on a NetApp SAN If you have just reclaimed a shelf from a NetApp SAN that you would like to use with an older head, you will notice that the drives are not recognized. This is due the the fact that DataOntap upgrades the drives automatically when you plug them in to an [...]
NetApp route add default gateway
NetApp SAN default gateway setup DataOntap is a FreeBSD based operating system built by NetApp. However, most of the command line interface commands differ from the usual FreeBSD commands. When a new NetApp installation is performed, or a NetApp migration is needed, typically the IP address needs to be changed, as well as the default [...]