Tuesday, January 29, 2008

What A Rough Day!!

That was yesterday!! It was a very bad one in terms of productivity. We literally spent the whole day trying to access one instance of SQL Server from other system on the network. But in vain. Microsoft does provide a Knowledge Article on what changes to make to enable remote access but even after that we were left high and dry!

My aim was to understand how data flows in a 3-Tier architecture. But without database connectivity, building the DAL itself was impossible. In the end we decided to proceed with local databases instead of Remote access and try and meet some of the fast approaching deadlines.

Today, was a fruitful one! Referring to msdn and my MCTS prep book I was trying to build one small module and that too with the proper architecture. Some of my team-mates were initially averse in building separate layers for Business Logic and Data Access but I pressed and convinced them. For the time being at least.

The best part was after a days work, of the three Unit Test Cases I had written for this module, I was successful in 2 of them at the first shot. And the third case which failed was debugged in no time, thanks to the proper segregation of business logic and data access from the presentation.

The coming days are going to be more exciting as I hope to learn more about Disconnected classes for data access in ADO.NET. Will surely post a few useful tips around the weekend!! Hopefully!

Till then, Happy Programming!

Happy New Year!!

Wishing all a Very Happy New Year!! Though we are already a month into it!!

Well, its been quite a while since I posted anything here. DO NOT think that my inactivity at this blog means that nothing is happening at the tech front! In fact, a lot has been happening and I really haven't had the time to write things down. Also, the buggers at my company have now blocked all access to blogger. Forget about posting, I can't even visit this blog anymore from my company to refer to some links and ideas that I had posted here!!


Anyway, this week we have kicked off with development for our project so a lot of exciting times lie ahead. Lots of things to learn and share with you all :). Also I hope to kick off development of my own trial project in 3 weeks time or so. Lets see where that ends up. I seem to have lost all motivation to work on that idea anymore. i also got a new idea which seems to be fairly simple but attractive. I just hope that it doesn't end up being another Wild Goose Chase!

Expect some useful posts soon....till then ...... Happy Programming!!