Skip to main content

Posts

AutoNumber Reset in SQL 2005

This post is pretty much just a note for myself, but it might help someone too.  When appending rows from an Access Database table to a SQL Server table of the same structure, sometimes SQL will not retain the ID's for AutoNumber fields.  This can be a big problem for our ParaPlan application.  In Access you can compact and repair to reset your autonumber fields back to 0 or 1 obviously.  However, I never really figured out how to do that in SQL 05 until now. To clear a table's records and reset the autonumber in SQL 05, just use the following syntax in a query on SQL db: "truncate table dbo.drivers"

Pandora Sidebar Gadget for Vista

I just love it... click here to download

Interior Painting Gets Started!

Allie and I are so far very pleased with our paint color and the work being done here by JB Paint Company.  We are using Benjamin Moore Paint from Gragg's and Frank (Allie's Dad) got us a nice deal on top of the internet special.  The color we (i mean Allie) chose for pretty much everything is Monroe Bisque.  We had several other options but went with this after Allie and I compared them by actually painting samples on our walls.  Here are a couple pics of how it looks! The previous owners were K-State'ers so the lavendar you see in the dining room will soon be replaced by this awesome Blue Spruce. The color is this basic nice soft yellow-tan and we really like it!  and yes...i am a tool.

The RockBand Video Game

For us 30-'somethings'...this thing rocks for parties... Burgers/Dogs and RockBand in Lenexa Kansas last weekend.... All girls killin' it at Jodi's birthday party... \ Tim Shroba (aka Tommy Lee) Brian, Tim and I had a somewhat video-worthy version of... Weezer's 'Buddy Holly'...whatever

EnGraph On The Road Again

I just arrived in Kennett Square, PA where I will be upgrading Kendal-Crosslands Communities from ParaPlan Lite Access to ParaPlan Lite SQL.  I am excited to finally meet Steve Cooper, the director of KCC, because he has been a ParaPlan user since 2004.  His recommendations and testing of our system has been invaluable to me.  I am really looking forward to the two of us bouncing around ParaPlan ideas this week. Carl and Anne are currently in Oberlin, OH training new ParaPlan clients as well. ParaPlan is growing and the future is very bright!

Simulating A Right-Click From The Keyboard

I have been doing quite a bit of LogMeIn (IT Reach and Rescue) lately and sometimes my mouse right-click does not work to get context menus.  Therefore, if you ever have this issue, just select the icon or item you need and press [Shift] [F10].  I am sure Tim could have told me this, but he wasn't here :)