Posted by & filed under Content - Highlights and Reviews.

Screen name: Evandro de Paula
Title/Functional role: Consultant
Project title: Online Data Push
Time to complete : 09/08/2009 – 11/21/2009
Project details: The purpose of the project is to substitute a Batch Data Push SQL 2005 SSIS based solution, which was very poor designed (no transaction control, no start from stop, scalability issues, etc.), for a Online SQL 2008 SSB based solution, which will provide a huge business impact because data will be available right the way. Moreover, the solution will: a) easily scale up and out by using a “DispatcherRouter” database to decouple initiator and targets and through changing SSB configuration, such as, “max_queue_readers” ; b) reduce the amount of downtime for maintenance because the SSB queue will be keeping the messages; c) performance will me better because process one message is more efficient than process millions at one time, having to control threads, buffer, etc.; d) a stop at point X > restart from point X approach can be employed.

Resources used: I have read the “Pro SQL Server 2008 Service Broker” from Apress and the case of MySpace.

Parties involved:
First, I played the role of Software Developer during “Proof of Concept” phase, which was very important to help customer to be more comfortable/familiar with the technology nuances. Then, I was the Software Architect during Design and Planning phases. In addition, I was assisted by a more experienced Software Architect to review the whole solution plan and a Database Administrator to intermediate communication with the security team.

What do you read?:
Usually, I do found books from Microsoft Press and Wrox very high quality. However, I do not have any specific author to stick on, I focus more on subjects.
 

Tags: apress, coder contest, dynamite coding skills, Evandro de Paula, Microsoft Corporation, Pro SQL Server 2008, Safari Books Online,

Trackbacks/Pingbacks

  1.  DYNAMITE CODING SKILLS Challenge Winners Selected! « Safari Books Online's Official Blog
  2.  DYNAMITE CODING SKILLS Challenge Winners Selected! « Safari Books Online's Official Blog
  3.  Dynamite Coder Submission – Online Data Push by Evandro de Paula - Affordable Web Developer - Just another WordPress weblog on Affordable open source web development.
  4.  Innovative Tech Professionals and Coder Challenge Winners From Around the Globe Honored at Safari Books Online Event in Sebastopol, California « Safari Books Online's Official Blog
  5.  Innovative Tech Professionals and Coder Challenge Winners From Around the Globe Honored at Safari Books Online Event in Sebastopol, California « Safari Books Online's Official Blog
  6.  Press Release: Safari Books Online Announces Exciting “Learn Something New Team Challenge” « Safari Books Online's Official Blog