Free Trial
|

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

Posted on September 30, 2009 by Safari Books Online

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.

This entry was posted in Contests, Challenges and Sweepstakes and tagged , , , , , , . Bookmark the permalink.

|
Facebook Twitter RSS feed