Josh Holmes - Sometimes respectable passionate technologist…

I went shopping for a new laptop for my brother this past weekend. It was nuts – Circuit City didn’t have the display model for the one that we wanted to buy and they would not open the box to let us look at the one that we were interested in. My brother didn’t care, but I was a touch perturbed by it all. It’s the little things that really make a difference to a real road warrior and they wouldn’t let us check those things. It turns out that I was right to want to check – it was set up as a left handed laptop. What I mean by that is that the power was on the right hand side where it’s in the way of the mouse and the USB ports and the like were on the left hand side where you have to run cables from the mouse all the way around the rest of the box to plug it in. This would be great if me or my brother were actually left handed but we are not.

I don’t know of other people think the same way that I do about that, but it drives me nuts when I see that type of setup. I think that laptop manufactures should put left handed or right handed on the box so we know when they put all of the ports on the sides of the box. The laptop that I’m using right now (Fujitsu T4020 Tablet) has a USB on the left and one on the back. The one on the back is obviously for the mouse. The power is also on the back. This means that it can be ambidextrous. I guess that’s one of the differences between a $550.00 laptop (what my brother bought) and a $2000 tablet (what I bought).

I wonder if the manufacturers consciously think about these issues…

I’m still alive – I’m just swamped! I’m working full time onsite with a huge deadline on Friday and trying to organize a conference (http://dayofdotnet.org) this week. I could drop either of those tasks and still have a busy week. I don’t know where I’d be without the help of John Hopkins and Jason Follas on the conference and with John’s help at the client.

I did squeak out to hear a fantastic talk from Dustin Campbell at Ann Arbor .NET Developers Group on the top 10 developer tools that everyone that uses Visual Studio needs. I even picked up a few last night. ILMerge was new to me. I learned a lot about CodeRush last night as well. I’m an avid fan, but I still learned a ton…

More next week – after things calm down.

Diabetes is a topic near and dear to my heart. I have had close family suffer from it and a few pass away because of it. In fact, I’m a high risk, due to family genetics, of developing Adult Onset Diabetes (Type II) as both of my uncles on my mother’s side developed diabetes in their 40s. My grandmother and several of her brothers and sisters are also suffering from it as well.

 

 

All that being said – Scott Hanselman (http://www.hanselman.com/blog/TeamHanselmanAndDiabetesWalk2006.aspx) is walking to raise money for the fight against Diabetes.

 

 

Please visit and see if you can help out this very worth cause that definitely affects someone that you know. 

This was fun. It’s a completely different database and set of circumstances than last night’s fun and frivolity.

I finished an application, zipped up the folders and sent it off to a client. In this application there is a desktop app that talks to a web service that talks to a SQL Server 2005 Express database. Sounds fairly simple, right? Right.

Well, the client unzips it all to a directory, sets up the virtual application for the web service and starts trying to run the desktop portion. It starts up, pulls up all of the lookups that we have in the database and it all looks good. Now, I’m on the phone and elated at how smooth this is going. At this point, the client tries to create a new record which is going well (wow, even a little drop down calendar and oooh look at that, it’s all of the types of records that I could create so I don’t have to type there… wow… and more gushing) until they try to save… At this point, there is a wonderful error that pops up –

“Failed to update database ‘database name.mdf’ because the database is read-only.”

Crud! After getting them to check the file properties and other such things, I called Patrick Steele, who has been working with me on this project, to see what he thought about it. It’s been a long day, especially after last night’s SQL Server Express issues, so I’m not thinking all that clearly. Patrick, after running through some of the same questions that I had so I’m feeling a little better about my thinking, has the thought that it might be a security issue and that the ASPNET user might not have permissions to write to that directory. Sure enough, since the ASPNET user doesn’t have permissions the database loads in read-only mode. Fix that and the database and the app work just fine.

Yesterday I had to make a quick change to a SQL Server 2005 Express database that I’m using for an internal to SRT Solutions tool. I decided that the easiest way to do it was to leverage the auto-connect feature of SQL Server 2005 Express by just FTPing the mdb down, making my change and ftping it back up. This has worked a number of times in the past. Not this time. I got a “login failed for user ‘USERNAME'” when I tried to run the application. That was infuriating. I spent the next 4 hours or so working with the SQL Server Management Studio Express (Enterprise Manager lite for Express) assigning, unassigning permissions, users, attaching, detaching, backing up, restoring and everything else that I knew to do. I kept getting “User could not login to user’s default database” and general login failures. My personal favorite that I saw yesterday was “Could not attach, DatabaseName is not a primary database file. (Microsoft SQL Server, Error: 5171)”. Now, I’m usually pretty good with googling the answers, but this time I’m really coming up short.

All of this is proving to me that I’m a programmer, not an administrator. I’m digging the new functionality in SQL Server 2005 but I’m not going to be the one to administer the databases that I write code for.

Long story short – I raised the white flag. I IMed Jason Follas and asked him if he knew what was going on. He figured out that it had something to do with the master file that SQL Express was using for the auto-connect. He found this forum topic. Here’s the relevant snippet:

“When you first run SSE this way, it makes a local copy of master etc. in C:\Documents and Settings\<your user account name>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS.  That’s why it’s so slow the very first time it loads under a new user profile.  It may even timeout the first time you ever use it under a given profile.

Based on your description, it’s very possible something went bad in those files for some reason.  So, I would first make a backup and then delete the SQLExpress directory under C:\Documents and Settings\<your user account name>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data.  That will get rid of the local copy of master, etc.  Then, reboot. ”

Well – Lance (the author of the post and author of SQL Server 2005 Express Edition Starter Kit) was absolutely right. I killed the master files (after copious backups) and rebooted the machine. It’s working like a champ now. On reboot, it regenerated the master files needed and started right up.

Thanks Lance and Jason. 

In case you missed it on Day of .NET‘s web site – the cutoff for the call for papers is this Wed.

Day of .NET has a new logo thanks to Kerry Colligan.

Check out TechEdBloggers.net

Patrick Steele is doing the tutorial session on NUnit and how it works.

Dave Donaldson doing the main session and is talking about writing quality software with VSTS.

Jim, I will get
you back for tagging me… J

 

Four Jobs I’ve Had…

·                 
Bailing Hay (Grew
up on a farm in Arkansas)

·                 
Security
Guard

·                 
Morning radio show
host

·                 
Software
consultant

Four
movies I can watch over and over…

·                 
The
Professional

·                 
Ronin

·                 
It’s a Wonderful
Life

·                 
Rosencrantz &
Guildenstern are Dead

Four TV
shows I love to watch…  (Disclaimer – similar to Jim’s, I watch a lot of TV with my
kids)

·                 
Myth
Busters

·                 
Get
Ed

·                 
Danny Phantom

·                 
English Premier
League Soccer

Four
places I’ve been on vacation…

·                 
Hot
Springs, AR

·                 
Zurich,
Switzerland

·                 
Buenos
Aires,
Argentina

·                 
Philadelphia, PA

Four
favorite dishes

·                 
Biscuits and
Gravy

·                 
Ham and Cheese
Omelet

·                 
Argentinean Steaks
– they cook them different there. It’s tender and melts in your
mouth…

·                 
Any meal with my
family

Four
websites I visit daily:

·                 
http://www.live.com

·                 
http://my.msn.com

·                 
http://www.techeblog.com  

·                 
http://www.geekswithblogs.com (well at least one of
the blogs under there…)

Four
places I’d rather be

·                 
Anywhere with my
kids

·                 
Anywhere on my
motorcycle

·                 
Golfing
Anywhere

·                 
Skiing – I’ve never
been but I’ve wanted to for a while

Four
bloggers I’m tagging

Jeff
Julian

Keith
Elder

Darrell
Hawley

Patrick
Steele