*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.