March 2009 Blog Posts

Ok, the storyline:  A web site creates a temporary file to work with, then is supposed to delete it, because maybe space is low on the drive or whatever.  There are times where the file will still be locked from our work when we try to delete it.  Perhaps we did something like: {\rtf1\ansi\ansicpg\lang1024\noproof65001\uc1 \deff0{\fonttbl{\f0\fnil\fcharset0\fprq1 Envy Code R VS;}}{\colortbl;??\red48\green95\blue182;\red227\green213\blue193;\red46\green83\blue209;\red1\green0\blue1;\red0\green0\blue0;\red37\green146\blue65;}??\fs20 \cf1\cb2\highlight2 File\cf3 .\cf4 WriteAllBytes\cf0 (\cf6 {\b "newFile"}\cf0 , \cf1 File\cf3 .\cf4 ReadAllBytes\cf0 (\cf6 {\b "oldFile"}\cf0 ));}--> File.WriteAllBytes("newFile", File.ReadAllBytes("oldFile")); And it hasn't released the lock on "oldFile" when we get to the next statement.  Oh man,...

So, lately I had the dilemma of having done a bunch of preliminary SQL work in 2008 Express, then needing to port my results over to a staging SQL 2005 server at work.  I casually backed up the 2008 database and lo and behold, couldn't restore it!  SSIS wasn't set up, and I had to gets stuff done ASAP!  I searched on Google, and all I got were either "use SSIS" or "it can't be done."  In other words, those who've done this before haven't shared with the rest of us. So a proc I wrote came in handy......

My wife's been getting on my case about having a gazillion different hard drives with everything and our mothers on them all around the house.  I mean, come on everybody, she just wants her pictures in one @%$!# spot!  She also "misused" Picasa, and now has a bunch of duplicates on her laptop (she doesn't read my blog, so I ain't worried she'll read that). So, out shopping for Little Liam last weekend, and we decide to pop into Circuit City's closing-its-doors blowout sale.  I grabbed her a 500 GB Western Digital external drive and, when we got home,...