Daily Archives: May 10, 2005

I am a SQL Server luddite

I use SQL Server nearly every day and I know nothing about it. Two months ago I saw Rod Paddock running stored procedures line by line in SQL Query. I never knew you could do that. (highlight the lines you want to execute and hit run.)Today I was trying to do a query that was case sensitive. I guess in all the years I have used SQL, I have never needed a case sensitive search. So I didn’t know that I had to have my field as a varchar so that I could cast it to varbinary in order to do the comparison. (See Michael Kaplan’s post on an even better way to deal with case sensitivity!)

It is really pathetic (and kinda scary) to know that there are thousands and thousands of people like me who end up being responsible for doing all of the SQL Server work, but we are too busy learning our development tools to *also* be a pro at the database tools, too. Oh, to have Roman Rehak spend just *one* day a week working with me. Heck, I’d take one day a *month*. Boo hoo. I know that looking at my database would probably give him a coronary anyway, so maybe it’s better this way. Actually it would be better not to have someone wiht a public blog look at my db anyway. That way they couldn’t humiliate me as readily. Of course, maybe I could bargain with him using my ADO.NET 2.0 deck and demos for his PASS talk!!



http://www.AcehAid.org

Code Camp D.C. Deck and Demos

Thanks to everyone who attended my Web Services Security and ADO.NET 2.0 sessions. I have had so much awesome feedback on the security session which I really appreciate.  The ADO.NET 2 talk is also one of my favorites. I could go on for days with that one as well.

If you are looking for the slides for the sessions and the demos from the ADO.NET talk, they are all posted on the MAD Code Camp site (that Andrew created using the ASP.NET 2.0 Clubs starter kit!!) for download as well as on my own site, on the presentations page.

Keep spreading the word that security does not have to be a mystery!!!

http://www.AcehAid.org

What I learned from Jeff Richter [today] about exception handling

[I wrote this while at Devscovery]

When I FIRST learned about exceptions 3 years ago, I was told that exception handling was for handling exceptional situations. Jeffrey tells us that this is a myth and is just wrong. Exceptions are when a method cannot perform its expected behavior. There may be many reasons for this. There are plenty of exceptions to allow you to handle much of what comes along.

Of course, performance came into question since it more expensive to catch and exception than to test for it. A good example of this is looking at catching a DivedbyZeroException vs. testing for zero and not wasting the resources used by the exception. This is a matter of balance. If the possibility of a zero being passed in is a rarity, then the exception won’t be hit very often, yet an if statement would be hit 100% of the time.

Jeffrey is on a mission to get the word out on this because the myth has been alive for way too long. I realize that based on this myth, I do more error handling than exception handling in my code. Of course, this is especially important for component developers, who may not know how their components are being used down the road.

Of course, I learned a lot more than just this about exception handling. I won’t be able to look at my old code in the same way again and will probably end up going through and making some serious revisions.  

I have been at Devscovery for two days now and am learning so much. I am jumping around into different tracks and getting a fantastic smorgasbord of information. It would be nice to just have every session lined end to end and attend them all. Or just have them zap it all into our brains. Like any conference, picking and choosing is always hard. But having to constantly choose between deep internals with Richter, serious asp.net with Jeff Prosise, hard core debugging with John Robbins and the many other great topics and Wintellect presenters is really just a big pain in the butt.

Sara Faatz has done an amazing job of putting together a top-notch and intimate conference. Sara is also our marketing guru for INETA and her contributions there are beyond amazing.

Thom Robbins explains Team System and shows off VS2005 at Vermont.NET

Our Microsoft D.E., Thom Robbins, drove up from NH yesterday to present at the VTdotNET user group. It’s a longish drive, so happily it was a beautiful day and he had lots of geek toys to entertain him on the way up.

Our pre-meeting preamble was a little longer than usual, because there is so much going on (starting .NET Newbie sessions in June, considering doing a Code Camp, a few conferences in our area, etc) so Thom didn’t get started until 6:45. Also, because there were so many new people at the meeting, I asked everyone to go around the room and do their 10 second elevator pitch. It took less than 10 minutes and I think was a really valuable exercise.

Then we let Thom go to town. The first and most important thing he did was explain all of the SKUs for VS2005 and Team System. I know there is so much confusion and misunderstanding about that, so it was really important to get that cleared up. There aren’t any huuuuuuge development companies here, outside of IBM. Although there are  large companies, like Goodrich (but not with a large group of developers) and IDX which probably has a few hundred developers, none that fit into the typical Foundation Server model, as far as Thom was able to explain. There are a lot of small consulting shops (3-10 employees) and also gobs of indies like me. The rest represent develoeprs who work at non i.t. companies.

There are a handful of people inthe group who have already been either playing with the Beta (and even Beta2) and even someone who is already working on a serious application. Thom went over the IDE and showed lots of new enhancements, and given the short time, highlighted a variety of different things – many new features in ASP.NET (master pages, personalization and membership, the SqlDataSource and ObjectDataSource components) as well as things like Edit & Continue, Code Snippets and partial classes. People who had already been playing with the beta were able to ask Thom pointed questions about things that they were having trouble with. I tried really hard not to say “ooh show them this, show them that” but apparently was not able to control myself quite enough.

It was nice that local Susan Wisowaty was able to make the meeting. She is now working as one of the D.C.C.s but unfortunately is doing this in the midwest and has to travel a lot. Thom is an excellent presenter. I know that even I was watching him as much to learn from his presentation style as much as I was trying to absorb what I could about VS2005.

If Thom didn’t have to make the drive back after the meeting, I’m sure we would have been happy to let him show off VS2005 for as long as he liked! I hate making him drive up to VT, especially when he just drives up just for the meeting and then has to go back, but we really love having him present at the group so everyone truly appreciated his being there.

I think with all of the new stuff coming down the pipes, we could easily have 2 meetings a month. Maybe I’ll have to make a bargain with the devil to get the MSDN events to come back to Burlington.



http://www.AcehAid.org