Posts

Showing posts from 2010

Ditch your backup tapes, use disks!

Image
Image via CrunchBase We've been backing up to LTO2 tapes for years using a Dell PowerVault 132T with an internal IBM Ultra drive. Differential backups from our SAN don't take too long, but full backups take nearly an entire day. The backup set has grown as the business has, and it's rapidly approaching 1tb, spanning 3-4 tapes. About 10 days ago the internal drive finally croaked. Swallowed a tape and wouldn't let go. I was able to retrieve it using some directions found on IBM's website, but after trying another backup, only to have it fail with the same results, we realised a change was needed. What we needed was a reasonably priced, reliable destination for our data. I knew that a replacement LTO2 drive was going to be expensive, and probably needed to be a Dell approved model that had the proper firmware to work; picking up just any internal SCSI drive wasn't going to cut it, and this was confirmed after poking around in Dells support area. I was able

Subsystem for Unix-based Applications and Windows Batch scripts

Image
Image via Wikipedia Some time ago, I installed the SUA package with the thought I might use it for scripting and other tasks that I find easier to accomplish using GNU -like tools rather than Windows . Recently I needed to run a batch script that programatically checks for the evidence of some data files and injects them into MS Sql via DTS . This script worked fine on another server for years with a few tweaks now and then, and suddenly during my tests on this machine, it was failing. What I found was that my script was using the Windows FIND command, which is also installed by SUA. When I used FIND in my script, it was using the SUA flavor, and not the Windows version. I checked my PATH environment and saw that SUA's path was listed first, then %SystemRoot% , and %SystemRoot%\System32 where Windows FIND is installed. If I were a betting man, I'd have to say that since the SUA tools are listed before Windows, they get processed first. I've not tested this, but really

Milwaukee PC Non-Customer Service

Image
Last week Friday, a tape got stuck in our Dell PowerVault 132T Library. Luckily, I was able to remove the tape and resume order to our backups ...or so I thought. After checking in Saturday it was clear that we were going to be without backups, something that makes my skin crawl. Image by artescienza via Flickr So promptly after our return to work after a nice long Labor Day weekend, I rushed out and to purchase an external drive to backup data to. My choice for such emergency trips is usually Milwaukee PC , since they are likely to have what I need in a pinch even if it is a few more dollars. Image via Wikipedia They indicated there indeed was a 2tb drive in stock, so I bought an enclosure and we headed over to the display case to retrieve the drive. Unfortunately the drive was no where to be found...bummer. A 1tb drive was likely not going to be quite large enough, but it was going to have to do. I started planning what data to trim from the backups to make room, then sudd
Image
Today during errands, we stopped by Goodwill and picked up this excellent enameled cast iron stew pot for $10. It inspired me to cook up an Indian stew for the family. My wife liked it so much she suggested I blog what I did, since it was all spur of the moment, like so much of my cooking is. The ingredients are as follows, in what I remember to be the approximate quantities... 1/2 vidalia onion diced 2 stalks celery chopped 2 medium carrots chopped 1 green chili pepper chopped 1 green bell pepper chopped 1 1/2 large tomato chopped 2 small white potatoes diced 2 cloves garlic minced 2 teaspoons minced ginger 3 or 4 mint leaves 3 or 4 bay leaves 4 or 5 small green leafy nutty spice I picked up at an Indian store, but have NO idea what it is... 1 teaspoon cardamom powder 1 teaspoon tumeric powder 1 teaspoon coriander powder 1 teaspoon cumin seed 2 teaspoon mustard seed 1 teaspoon fish sauce 2 tablespoons lemon juice 1 can coconut milk 2 teaspoons chicken bullion 1/2 lb cub

Ubuntu AMR Codec

Image
What a PITA. I have a cool smart phone that takes video, and can't get audio to work in Ubuntu , since Intrepid and Jaunty don't appear to come with AMR codecs compiled in ffmpeg , or gstreamer. Now, you can try to compile your codecs from source, and I've certainly done this sort of thing before; I can build my own kernel (In the days BEFORE xconfig), run Slackware/Gentoo, etc. This just didn't work for me. BUT, there is an easy solution. YOUTUBE.COM Image via CrunchBase That's right. Upload your video to YouTube , wait for it to process, and download the resulting MP4 from the My Videos area of the control panel. Presto, you've got your audio converted to something usable in short order.

Windows 2003 Migration

Image
I haven't had to do a migration for some time, since the days of consulting have been over for 3 years now. Image by mooing brontosaurus via Flickr Even then, I'd only done a couple of 2000 to 2003, and one SBS 2000 to SBS 2003 migrations. This project involved moving from SBS 2003 to a Standard 2003 environment. I was a bit intimidated, and purchased the excellent Swing It! SBS Migration kit from Jeff Middleton . One good thing about it was that Exchange had been moved to a hosted solution last year, and they didn't use Sharepoint . Turns out this was a good purchase for a guy doing a solo project with few peers to bounce questions or ideas off of. Jeff freely provides answers and guidance in his forums, and his expert help is just a phone call away if you are current with your subscription. Pre-pay, and your support requests are responded in an even quicker manner. Fortunately, I didn't need to ask but a few questions, and I was on my way with the docs, and

LastPass Enterprise

Image
The Environment Image by justonlysteve via Flickr I work in an industry that deals with Protected Health Information (PHI). According to the Health Insurance Portability and Accountability Act (HIPAA) we need to apply certain measures to protect this information, and continue to improve those measures. Over time our company has increasingly found itself turning to the Internet to retrieve information regarding patient visits, explanation of benefits, remittance advise, bank statements, etc. The list grows daily. The Problem As this list grows, so do the accounts (username & password, and sometimes a challenge question). Keeping track of these is becoming a daunting task, and an even greater one is maintaining standards on password strength. In the IT support world, it is common to find weak passwords and poor account management practices: Written on Post-it Notes pasted under keyboards or worse, on the monitor. Using birthdays; pet, children, sibling, or spouse pet names; commo

freeFTPD

Image
Image by Micah68 via Flickr I've been using FileZilla FTP server for some time now and have been happy for the performance. Recently, we needed the ability to expose the FTP service to another client, and the documents that we'd be receiving would be arriving in an un-encrypted form, unlike our other clients. I decided I could simply enable FTPS , the SSL enabled FTP protocol and open a port to 990 on my ASA 5525 Security Appliance and NAT traffic to our server. Unfortunately I quickly found out that a passive FTPS server behind my firewall won't work without some specific configuration changes as discussed in this article . With all that fussing around, I decided to check out freeFTPd, a single deamon that offers both FTP and SFTP, not to be confused with FTPS, but the secure file transfer protocol that is common to the SSH ( secure shell ) protocol. It's fairly straight forward, but is a bit quirky and the documentation is non-existent. Follow some of my ti

Dashboard Samples

Image
Just finished posting two examples of the dashboards I've been creating for a few of our clients. Image by cobalt123 via Flickr One is a Visit Log , and the other is a Demographic Map . Demo went well with one of our clients, they appeared even a bit exited at the possibilities it represents for them... I'll start working on exposing other data, like Relative Values of services provided, attached receipts, etc.

AllScripts Tiger to MS SQL to GoDaddy Hosting

Image
Some time ago, I wrote an article about using Cognos Impromptu to export data to CSV from a then Misys, now AllScripts Tiger data source, and use DTS in MS Sql Enterprise Manager to import it for displaying data in ASP pages. I started using this method to export other types of data, in an attempt to create a dashboard for our clients. I quickly found that Impromptu is not well suited or reliable enough for scheduling multiple jobs. The requirements and caveats for using Impromptu in this manner are: Each report must be scheduled so as to not be running when the next is scheduled. Impromptu will not allow the next scheduled report to wait too long, and this may cause the "chain" of reports to fail. The workstation running the reports must have a user logged in with the Cognos Scheduler application running in order to fire the reports off. It cannot run via the Windows Scheduled Tasks (AT for us old-timers). If you run your reports against multiple companies, as we do