# Tuesday, March 14, 2006
SQL Server 2005 Express Issues

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


Development | SQL Server
Tuesday, March 14, 2006 2:07:29 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Monday, March 13, 2006
Day of .NET Call for Abstracts
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
Monday, March 13, 2006 6:31:22 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

New Day of .NET Logo

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


Day of .NET
Monday, March 13, 2006 3:28:58 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

Keith Elder, .NET Pimp

Keith Elder used to be one of the biggest PHP advocates around. Now, he runs a site called http://www.dotnetpimps.net where he is the foremost .NET Pimp. He pointed out on his blog that he’s put up and article on why he made the conversion. More at http://dotnetpimps.net/blogs/theelder/about.aspx.


Articles | Development
Monday, March 13, 2006 3:11:11 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Friday, March 10, 2006
TechEd

Check out TechEdBloggers.net



Friday, March 10, 2006 2:48:21 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Wednesday, March 08, 2006
Quality Code at AADND tonight

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.


User Groups
Wednesday, March 08, 2006 5:18:32 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Monday, March 06, 2006
User Group Structure and Positions

When I was at the Rockford, IL .NET Users Group we spent a lot of time afterwards talking about the formation of a user group and best practices. We talked about the idea that they should structure the group so that one person is not having to do all of the work. It’s not sustainable to have one person running the whole show. I just got an email from Chris Hoffman asking me to repeat some of that information. 

 

The basic structure that we are using for three different groups (Great Lakes Area .NET Users Group, Ann Arbor .NET Developers Group and Ann Arbor Computer Society) is as follows:

 

4-5 elected officials – elections once a year.

President

This is the coordinator of all of the different people. Their two basic tasks are to makes sure that everyone else gets their work done and to run the meetings.

 

Vice-President

The basic task of the VP is to take over when the President is not able to make it. We also use the VPs as an extra body on any of the tasks that need to be done such as helping to coordinate marketing, pizza, venue and so on.

 

Treasurer

The Treasurer is the one that maintains the bank account.

User groups have expenses. Those can come in the form of paying for venue, pizza, web hosting, swag to give away and lots more. You can get money for these expenses through paid membership, sponsors, donations or some combination of the three. At all three of the groups that I’m involved in, there is a voluntary $20.00 membership. On top of that, they all have free venue so we are able to cover the expenses with that membership. Two of the groups also accept sponsorships so they can make money that way as well. The treasurer takes the money in and writes the checks so make sure this is someone that you trust. Not that the user group will ever make enough money that it’s worth embezzling but still.

 

Secretary

This secretary’s job is to record minutes at any of the board meetings and such. They are also responsible for running the elections. They should get familiar with Roberts Rules of Order before running the elections. That not required but it’s definitely good because it gives the whole process order and a sense of officialness.

 

At AACS (Ann Arbor Computer Society) we also have a Quartermaster who is responsible for physical things like getting the projector ready and the like. It’s their responsibility to make sure that the room is ready for everyone.

 


Then there are the appointed chair positions. The president has the power to create and appoint chair positions on an as needed basis. The reason that these are by appointment rather than by election is that it makes it easy for administration after administration to reuse the same chairs so there is some continuity between the years. The two chair positions that all of the groups have are:

 

Program Chair

This is the hardest job of the whole group in my opinion. It’s this chair’s job to ensure that there are speakers for every meeting. This person coordinates with INETA if it’s a .NET Users group, scan search engines for local speakers, contacts friends and family and begs and pleads for speakers. It’s a good idea to have a well connected person in this position when the group is starting up because it will make the job easier. As time goes on, the group will gain a reputation and it will be a touch easier because you’ll have some number of speakers asking to come speak + the INETA gigs so you really only have to find 4-5 presenters a year.

 

Web Master Chair

This is the person responsible for the web site. Plan on using Community Server, Dotnetnuke or some other portal style framework because it will make life easier.

 

 

Other chairs that have been created by various groups

 

Publicity Chair

Responsible for mailing out the meeting announcements, getting the group into MSDN flash and other community calendars and so on. Publicity is essential to growing the group. First you have to get the word out to get people interested in it. Second, until you get burned into people’s brain, people will intend on coming but forget about it unless there’s a reminder sent out.

 

Academic Liaison Chair

We have a lot of universities here so it made sense.

 

I hope that this helps. Please let me know if I missed something or if you have anything to add.


User Groups
Monday, March 06, 2006 3:12:17 PM (GMT Standard Time, UTC+00:00)  #  Comments [1] 

# Tuesday, February 28, 2006
4 Things Meme

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



Tuesday, February 28, 2006 3:51:02 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Thursday, February 09, 2006
ASP.NET 2.0 Personalization Code
Here is the code from some of my recent talks. I will be updating this code from time to time so check back occasionally.

Thursday, February 09, 2006 3:50:24 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

Ann Arbor .NET Developer Group’s first meeting last night

For our first ever meeting, I was thrilled with how last night went. We had 35 people show up for our first meeting. It was great to see all of the people in the room that I didn’t know. Of the 35 people, I knew about 15 of them. That’s one of the great things about user groups and community is that it’s a great way to meet people.

 

We are following the format that’s proven to work well at GANG where we have a 45 minute tutorial session followed by the 90 minute main presentation. The tutorial session is designed to give the audience the basic background that they might need to understand the main presentation. It also gives our members a good chance to get some speaking experience without as much pressure as the main presentation gives with a longer talk and a more advanced subject.

 

Jay Wren of ADP gave the tutorial session on Introduction to ASP.NET 2.0. Honestly, I was still running errands like getting copies of the eval made and all of that type of thing so I didn’t hear all of it. But what I did hear was very good and as complete as you can be in 45 minutes. It also seemed to be well received. We haven’t compiled all of the evals but it’s a good sign when there are people standing in line to ask questions afterwards.

 

Following that, I gave a session on ASP.NET 2.0 Personalization. See how the tutorial set the stage for this session? I actually stayed pretty close to on time. This is a new resolution of mine is to start staying within my time limits. I usually start answering questions within the time limits and then end up answering questions for a long time. I’m really trying to cut off the questions and have people with questions stay after and ask me offline so that we can cover it in more depth and people that aren’t interested can leave.

 

I enjoy the Personalization talk because there are a good number of GPMs (Gasps Per Minute). My brother, who is not a developer, came to Rockford, IL when I gave this same talk there and he loved it and phrased the term GPM. The code for the session will be up very shortly.  



Thursday, February 09, 2006 3:48:36 PM (GMT Standard Time, UTC+00:00)  #  Comments [0] 

# Wednesday, February 08, 2006
Design Guidelines Coming for The UX experience...

I found this via Bill Baldasti

 

I’m fascinated by design guidelines. They are intended to ensure that your user has a good and consistent experience with the rest of the applications on the given platform.

For example, the Designed for Windows for Pocket PC for Software Applications guidelines, which you have to follow to be Pocket PC Logo Certified, specify that you cannot have an exit button but must smart minimize nicely and that your application must come back to the exact same state when it’s reopened.

There is also a set Guidelines for User Interface for Developers and Designers that Microsoft has been pushing for a long time.

Even thought it’s a ways from releasing, Microsoft is already starting to build and promote the Windows Vista UX Guidelines. Being fascinated, I downloaded the guidelines. It came down as a 14 meg zip file that unzipped into 825 files. Wow!

It’s going to take some time to dig into this and really digest it. The good news is that they broke it down to a simple top 12 rules list. I’m not going to re-list those here, you can go read them on your own. However, some of these things should apply right now in your current work, like #10 which is clean up the UI including make sure that you use labels, organizing your menus and the like in a task oriented manner and so on. Or like #12 which is reserve time for development time for “fit and finish” work. That’s just good common sense that we should all be following.

Of course, now that you’re all excited about the glass aspects of Vista, they say that you should only use it “judiciously”.

 

It’s going to be interesting to see what happens with the guidelines and the UX experience. Personally, I’m excited by it all. I’m ready to start looking at the Ribbon control in Office 12.



Wednesday, February 08, 2006 2:30:09 AM (GMT Standard Time, UTC+00:00)  #  Comments [0]