MVP Summit – 2008

I am back from MVP Summit 2008 that took place in Seattle last week. It was an absolutely amazing experience and I was overwhelmed by the sheer amount of information that was offered during the summit. From the Toby’s welcome note to speech by Sean O Driscoll to the break out sessions that took place in Building # 43 @ Redmond Campus to the key notes by Ray Ozzie and Steve Balmer, it was an enlightening experience.


I would like to point out to a news article posted by Seattle times here. I will be looking forward to attend next years summit that is scheduled for March 1-4th, 2009.


I will blog shortly about Connected System SDRs.

MVP Summit – 01

Hey all.. I am at the WSTC and waiting for the Welcome note and hence the official start of this years summit here @ Seattle, Washington. I reached Seattle yesterday morning and will be heading back to Singapore on Friday 18th of April. I will be blogging about this event for next few days and keep you all posted on the most exciting and the best of things experienced @ this years summit.
Now, a little bit of update on weather in Seattle. It was rather cold and wet in Seattle yesterday but today is one of those bright sunny days (well, so far atleast) you wish you would have every day.

User group event: Web 2.0 in Enterprise


<dotNetBulls/> hosted their first technical event on 11th of March, 2008. Topic for this event was “Web 2.0 in Enterprise” and it was hosted by Linda Chong, from Microsoft. Linda Chong works for Microsoft in the capacity of Architect Evangelist and she has 12 years of extensive experience on management, consulting, evangelism, architecture design/review, pre-sales engagement and systems integration in the areas of SOA, Web 2.0, e-business/e-commerce and enterprise application integration (EAI). Event started with Hammad Rajjoub introducing <dotNetBulls/> and speaker.


Linda started off with talking about Software + Services and Web 2.0 and where it stands today and then moved towards Microsoft’s Silverlight and its applications in local/international market. It was a successful event that saw a conference room filled with geeks, snacks (thanks to SDC) and guest speaker engaged in technical dialogue for more than an hour.


User Group Event on VSTS


<dotNetBulls/> hosted their second technical event on 27th of March, 2008. This was a special event that saw two top speakers from Microsoft Corporation hosting a tech-talk on Application Life Cycle Management, Agile Tools and Visual Studio Team System. Both the speakers were visiting Singapore for “Heroes Happen Here” event that marks the launch of Visual Studio 2008, SQL Server 2008 and Exchange 2008.


Norman Guadagno, Director of Product Marketing for Visual Studio Team System talked about application development life cycle management and how VSTS allows integrated, extensible and end-to-end ALM (Application Lifecycle Management).
Stephanie Saad, Group Manager in Visual Studio Team System at Microsoft, talked about how agile development tools in VSTS can be used to deliver Agile Solutions.


Event was a success amongst its participants who were delighted and enlightened to hear from top experts on the topic that’s very important and extremely relevant to their professional work. Stephanie showed some cool demoes on VSTS and audience absolutely liked it. After the demoes there was an open QnA session where audience asked various questions on the use of code metrics, automated builds, annotations etc.


ODP Bug (or so I think)


I found out that ODP.Net for Oracle 10g behaves in strange way for Oracle Parameter that are passed on to oracle command. It always expects parameters to be added in the same order as they are originally available on stored proc in db.


So, if a sp (stored proc) expects two parameters, first being “pId” and second being “pName” and you use the following code:


oraCommand.Parameters.Add(new OracleParameter(“pId”, OracleDbType.Int64, “10001”,
ParameterDirection.Input));
oraCommand.Parameters.Add(new OracleParameter(“pName”, OracleDbType.Varchar2, “John Doe”,
ParameterDirection.Input));


It works fine since the first parameter is of type Int64 (as expected) and the second parameter is of type Varchar2. However if you reverse their orders ODP wouldn’t work.


oraCommand.Parameters.Add(new OracleParameter(“pName”, OracleDbType.Varchar2, “John Doe”,
ParameterDirection.Input));
oraCommand.Parameters.Add(new OracleParameter(“pId”, OracleDbType.Int64, “10001”,
ParameterDirection.Input));


This will raise an exception that would say “Invalid number or type of arguments passed ….etc etc”. Now this is a strange behavior because we always (at least in terms of ADO.Net ) expect that parameter names will be binded against the stored procs parameters. But this doesn’t happen in the world of ODP.Net. And if you pass parameters in right order, parameter names doesn’t even matter.


I don’t know if its just my bad assumption or bad ODP design or a bug for that matter. It definitely caused me a whole lot of annoyance and wasted my time. I actually ended up adding a unit test and passing each and every parameter manually to sp and then running it against new provider. Since I was adding those parameters manually I added them in the same order as that of sp and hence a successful insert. But as and when I resorted to xml file containing field definitions, it always failed. I even ended up creating excel sheets with formulas to compare parameter types and values because that’s what I thought were most likely to go wrong. Bad day I guess!


I really think its a bad design atleast. API should be intuitive and inline with general design of framework (in our case ADO.Net).