While trying to execute an SSIS import package on a customer’s Excel file, SQL Server 2008 SP1 was returning a “truncated” error. Although, the SSIS package was set to ignore these, the execution halted and data was not written to the SQL table. There were a number of posts including David Klein’s and Waxtadpoles regarding SQL 2005 and the “TypeGuessRows” setting in the registry. Their suggestion was to set the value to 0 (zero), in order to force SQL to parse all rows in the excel sheet, not the first 8...
read moreOne of our users suddenly began experiencing a severe draining on his iPhone battery. There are variety responses to this topic, the least of which was to change the iPhones mail retrevial from Push to Fetch. Howver, other iPhone users were not experienceing this issue. So we set out to troubleshoot what was happening. After two days of research, below is our results and the resolutin that worked for us. Constant polling in Push mode The first thing we detirmined was that the phone was constantly polling the exchange OMA (Outlook Mobile...
read moreUPDATED: Jan, 2013 I have been using my Sony HDR-SR12 camcorder for several years now (here is a link to that post). As much as I love this camcorder and storing straight to a hard drive, AVCHD footage presented some workflow challenges with my editing system – Final Cut Pro. And since Sony’s archiving software is Windows only and I work on a MAC, archiving was no picnic either. But the solution I’m currently using is achieving good results for both, so I thought I would share my process for anyone else facing these issues. In...
read moreI’d been waiting for the right combination of features to make the plunge to a high definition camcorder for personal use. I’ve been using the 3 CCD Sony HDR-FX1 for professional use, but it is too large to carry around for personal use. Enter the HDR-SR series. I won’t cover the specs – cause it’s been done…but this version is a 120 Gig internal hard drive. This new camera had everything I was interested in except, a 20x optical zoom and HDV versus AVCHD. The 20x just isn’t happening. I believe due...
read moreAfter performing a clean install of Microsoft Office 2008, Entourage began to give me the following error: “Unable to establish a secure connection to servername because the correct root certificate is not installed.” I followed various post regarding installing our Exchange Server’s certificate. After installing this, I began to receive this error: “Unable to establish a secure connection to servername because the server name or IP address does not match the name or IP address on the server’s...
read more
