iPhone OS 3.0 Initial Impressions

In: iPhone
Written by: Taylor Gerring

10 Jun 2009

I’ve updated to iPhone OS 3.0 build 7a341, which is said to be Final/Gold Master and these are my initial impressions in short form.

Installation

  • Performed full backup and sync in iTunes 8.2 before restoring 3.0 new firmware
  • Update process is very smooth and doesn’t take too long

Springboard

  • Some first-party icons have been refreshed. Messages, iPod, Phone now have a slight diagonal stripe pattern in the background.
  • New Voice Memos App

Read the rest of this entry »

HOWTO: Connect to MySQL in SSIS

In: Google|SSIS
Written by: Taylor Gerring

4 Jun 2009

While Microsoft provided connectors for Oracle, Teradata, and SAP BI for SSIS 2008, there are many other database systems left out of the mix. Fortunately, SSIS is exceptionally flexible in connecting to various data sources and allows other vendors to provide native support. The MySQL team did just that with Connector/NET 6.0, their ADO.NET provider. This tool allows us to use the the ADO.NET connections in SQL Server Integration Services to easily connect to MySQL. This is a walk through on how to connect to MySQL with SSIS 2005 utilizing the Connector/NET 6.0 ADO.NET provider.
Read the rest of this entry »

Common Table Expressions were a new feature added to SQL Server 2005 and provide an efficient way to recursively query relationships stored in a normalized table. We’re going to build on that essential functionality to flatten a typical corporate structure so that all children, grand children, great grand children, etc. roll up into a single, flattened parent, regardless of depth. To graphically visualize this, take a look at the actual relationship we’ll be querying against:
Read the rest of this entry »

Review: mophie Juice Pack air

In: iPhone
Written by: Taylor Gerring

29 Apr 2009

The mophie Juice Pack air is a combination battery extender and hard case for the Apple iPhone 3G. Currently, as to not risk being stranded with no battery, I resort to turning off non-essential services and praying to the almighty iPhone gods for just a few more minutes of power. Despite not occurring every single day, the situation happens just often enough to be annoying. I needed a solution and because I was already in the market for a new case and annoyed at the abysmal battery life while on 3G, I decided to stroll down to the nearest Apple store and check out this new gadget. Read the rest of this entry »

Control Startup Program Order with PowerShell

In: Windows
Written by: Taylor Gerring

14 Apr 2009

If you’re like me and need multiple programs to start upon login, your hard drive is likely inundated with requests, causing a major slowdown as the OS seeks to fill each and every request simultaneously. Furthermore, I have some programs that are dependent upon others, so when they load out of order, I have to shutdown and restart the applications or perform some extra steps to reconfigure the program. An example of this is synchronizing DropBox and ZumoDrive. If DropBox starts before ZumoDrive, it never syncs and hangs in an “Indexing…” state. This matter is complicated by storing my KeePass database on my ZumoDrive. Because KeePass loads before ZumoDrive, it can’t find the Z: location and I have to re-locate the KDB file for it to load.

One solution to this problem is to start the programs manually, which is monotonous. A much better solution is to control the exact startup sequence, giving each program a small delay to fully load before starting the next program. A solution I used in the past for Windows was a batch file. This suffers from a couple of problems:

  1. By default, there is no “sleep” command. You can install the Windows 2003 Administrator Toolkit for the functionality, or resort to a ping delay trick. Both of these are less-than-ideal.
  2. This is 2009. Batch files aren’t exactly cool.

To overcome these issues, I took a gander at my latest favorite scripting language, PowerShell; it handily solves both issues. This is a very easy hack and to accomplish it, there are only a few steps. The only considerations for this project is to ensure that PowerShell v1 or v2 is installed and configured to run scripts locally. With those assumptions, let’s get started:
Read the rest of this entry »

@TaylorGerring


Unless specified otherwise, this website is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
Stop SOPA
Unless specified otherwise, this website is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.