.net, c#, asp.net, linq, htpc, woodworking

Jarrett's Tech Blog - For January 2010

  1. Intel SSD Deal and Price Watch

    I'm in the market for an SSD but the prices are still sky high. I'd like to do a fresh install on my desktop machine and install Windows 7.  My current Vista install is running out space due to the WinSxs folder.  A new SSD would be a perfect reason for a reinstall and a nice speed boost.

    I've been running an SSD in my laptop for about 5 months and I love it.  The speed and battery life is incredible.

    Back in August 2009, I was lucky to snag an Intel X25-M G2 from Newegg for $229.


    The price immediately sky rocketed right after my purchase it and it hasn't settled back down since.

    I just installed this cool new extension for Chrome called The Camelizer.  It watches the price of products at various web sites and shows a graph.  I'll definitely use this tool to find the right time to buy.


    Update: I was watching the OCZ Agility drive with Camelizer and it notified me of a recent price drop.  I was extremely tempted as it also came with a mail-in rebate the lowered the price to $129.  This is a great deal for a 60GB SSD.  However, I just didn't feel the time was right as I haven't found a cheap copy of Win7 yet.  Anyway, within a few hours it sold out!



    Posted by JarrettV on January 30 at 10:41 PM

  2. Output Large Result Sets to Excel 2007 from SSIS 2005

    I was recently in a situation where I needed to output a large amount of data to an excel file.  This file is generated periodically and used by business analysts.  We are using SSIS 2005 and the BAs are using Office 2007.  Since the report would be bigger than 65,536 row limit of 2003 format, we needed to use 2007 format.

    You'll need to start your data flow with an OLE DB Source as according to this thread it is required for compatibility.


    Next, in the Connection Managers, create a New OLE DB Connection. Choose Microsoft Office 12.0 Access Database Engine OLE DB Provider. For now, leave the details blank and click OK to continue.


    Note: you'll need Office 2007 installed or the 2007 Office System Driver: Data Connectivity Components

    You'll notice that it looks like you are using a database connection instead of the typical Excel Connection you used for Excel 2003.


    Select your new connection and view the properties.  Change the connection string to the value below.

    Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";


    Don't forget to change the file path in the connection string.

    Next, I recommend you truncate any large columns to 255 using a Derived Column transformation.  Also, use a Data Conversion transformation to convert all strings to unicode strings.

    Now, that your data is in the correct format, let's clean up the column names.  I use a Union All transformation and delete the old columns and rename the derived and converted columns.  These last couple steps make the data more compatible with Excel.


    Finally, your ready to dump the data to an Excel 2007 file using an OLE DB Destination.  Choose your new connection you made earlier.  For the name of the table or view, choose New to create a new worksheet in the Excel 2007 workbook output.  In the CREATE TABLE script, you can rename the worksheet if desired.


    Because of the cleanup, you'll have a simple one to one mapping.  Now you can output more than 65k rows into an Excel file from SSIS 2005.


    Posted by JarrettV on January 26 at 1:26 PM

  3. Getting Started with Android

    I've been following Android since it was released in late 2008.  I was excited because I knew the potential was limitless. One year later, both me and my wife got our first Android phones, the Verizon Motorola Droid.  It only took a year for Android to mature into greatness, but it still has a way to go.  I'll discuss some of the basics of using Android and share some of my favorite tips and applications.

    Why I Like Android

    Android is built on top of a solid foundation of openness and optimism.  Computer geeks like me love the piece of mind that comes with knowing you can change/fix anything you don't like about your phone.  Android allows you customize anything about the phone.  Also, Google is pushing for an ecosystem where all devices are treated equal.  The future of the cell phone is not 2 year contracts or nickle and dime calling plans.  We will no longer need voice plans, just a monthly data plan.  Android will enable this.  If not 2010, 2011.


    Before You Start

    With Android, your data lives in the cloud.  For the best experience, before you get your new Android phone, you should update your contacts on your Gmail account.  Still using Hotmail? Now is a good time to switch.

    The contacts manager in Gmail works really well.  It isn't pretty and there does seem to be some missing features, but it gets the job done.

    • Organize your contacts into Groups
    • Clean up your contacts, put the proper first and last name in for everyone
    • Add phone numbers, addresses to your contacts so you can easily call or navigate to the contact
    • You can batch import from a CSV file
    • Add pictures to your contacts so they show on the phone (Note: your phone will pull a picture from Facebook but the picture is usually too small to see clearly)
    • Crop pictures of contacts to just their face so it is easier to recognize when they are small

    Things to Know About your Droid

    verizon-droid-phone-76ca6b81ec4c0d36_large[1] The Droid is a great phone, but there are few things you should know about it.

    • There is a button on the top to turn the screen on and off (I didn't know at first because my wife turned it on for the first time).
    • The screen and OS support multi-touch but it is not enabled.  When I first held the phone, my finger would inadvertently touch the side of the screen and my other finger would not register swipes and taps.  So make sure when you hold the phone, your fingers aren't touching the side of the screen.
    • The gold button on the side is the camera button.  Just hold it down to start the camera.  Hold it down again to focus and take a picture.
    • Before taking pictures, wipe the lens with a clean cloth as my lens is usually smudged from handling it.
    • There is protective plastic behind the sliding screen.  It will come off eventually.  No big deal.

    Things to Know About the Android OS

    • The notifications take place at the top the screen.  You can drag this down to see more info about the notification or clear the notifications.
    • Hold down the home button to switch between recent applications.
    • Hold down the search button to do voice searches.
    • Touch and hold down anywhere there is a blank spot on the desktop to add shortcuts and widgets to the desktop.  You can swipe between three desktops.  Take advantage of all three.
    • Make sure you use the toggle widget to manage your battery usage.
      • The icons from left to right are: Wifi, Bluetooth, GPS, Sync, Brightness
      • Airplane mode will use the least amount of battery.

    My Desktops


    • The middle screen is where I keep the main apps that I use on a daily basis.  This is also where I have the Power Control widget that is very important for controlling battery usage.
    • The right screen is where I keep shortcuts for directly calling people, mostly my family.
    • The left screen is where I access my music and news and check my calendar.

    droid_dock[1] Accessories

    I received a multi-media dock as a present and I keep it at my desk at work.  I love it.  The phone easily slides in and out and it keeps my phone charged.  My wife has the car dock and she loves it as well.

    If you have the docks then you can't really use protective cases.  All the protective cases for the the Droid seem crappy anyway probably because it is physically difficult to make a decent case for a slider phone.  Anyway, the screen is Gorilla glass which makes it very difficult to scratch.



    • Bump - this application is great for exchanging photos and contact information.  You can even bump iPhones.
    • Barcode scanner, Google Goggles - take pictures of barcode and QR codes or with goggles you can take pictures of  stuff and it will figure out what it is.  You can even download new applications to your phone by taking a picture of the 2D barcode.
    • Google Voice - replaces my old cell-phone number and gives me Gmail like functionality for my voice mail.  When anybody calls my Google Voice number, it rings my cell, both my work numbers, and it rings on my computer at home. 
    • Corporate Email - Android has decent support for corporate email with exchange access.  It isn't the complete exchange experience, but it works.
    • FlingTap Done - A nice TODO list app that has some neat features.
    • Google Maps w/ Google Latitude - the maps application is great.  It supports street view, and with latitude, you can see where your friends are at.  Now, when my wife meets me at the restaurant, I know when she'll arrive.
    • Tracks - record the GPS locations of your jogs, walks, car rides, etc.
    • Music - with all the internet based music apps, you don't really need to put music on your phone.  I like Last.fm and Slacker radio.  Pandora is starting to have too many comercials.  Also, you can easily buy songs from Amazon MP3 or just listen to 30 seconds of all the "Hot" songs.
    • Podcasts - I use Google Listen for my podcast needs.  Ironically, the search function isn't that great.
    • Newsrob - Although I prefer to use Google Reader on my laptop to keep up with my favorite blogs, this app does the job when I'm on the go and it stays in sync with Google Reader.
    • USA Today and NPR News - good news apps.
    • Google Talk, Facebook, Swift - these apps let me IM, keep in touch with friends and tweet.
    • OpenSudoku, Shortyz (cross word), Robot Defense (tower defense), Devilry Huntress (bejeweled), Labyrinth Lite, Totemo are all fun puzzle/strategy games.
    • Nesoid and SNesoid are great emulators for some retro Nintendo and Super Nintendo gaming.
    • SchottGunn and The Schwartz Unleashed turn your phone into a light saber and a shotgun.
    • Flixster Movies - goto app for when we feel like going to the movies.
    Posted by JarrettV on January 22 at 12:12 AM

© Copyright 2024