|

*Dynamite Coding Skills Winner – Online Data Push by Evandro de Paula

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.
 

About Safari Books Online

Safari Books Online is an online learning library that provides access to thousands of technical, engineering, business, and digital media books and training videos. Get the latest information on topics like Windows 8, Android Development, iOS Development, Cloud Computing, HTML5, and so much more – sometimes even before the book is published or on bookshelves. Learn something new today with a free subscription to Safari Books Online.
|

6 Responses to *Dynamite Coding Skills Winner – Online Data Push by Evandro de Paula

  1. Pingback: DYNAMITE CODING SKILLS Challenge Winners Selected! « Safari Books Online's Official Blog

  2. Pingback: DYNAMITE CODING SKILLS Challenge Winners Selected! « Safari Books Online's Official Blog

  3. Pingback: Dynamite Coder Submission – Online Data Push by Evandro de Paula - Affordable Web Developer - Just another WordPress weblog on Affordable open source web development.

  4. Pingback: 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. Pingback: 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. Pingback: Press Release: Safari Books Online Announces Exciting “Learn Something New Team Challenge” « Safari Books Online's Official Blog