Thoughts and dreams for a better world… one smile, beat, code at a time

  • more sql performance tips

    As most of you know the general rule in performance tuning is ….. “measure, measure, measure” and “measure again” But it doesn’t hurt to give out some warning signs from time to time. And here goes two: [more] 1) be careful in doing anything fancy on JOIN predicates (that is the condition in the “ON”…

  • adding custom SSIS transformation to visual studio toolbox fails

    Just very recently I encountered an issue in deploying a custom SSIS component assembly where I cannot add a custom SSIS transformation to the Visual Studio toolbox. It turns out to be a relative “no-brainer” error if only the clues were more straightforward. Basically after deploying the assembly I could not find my component listed…

  • blog site update

    I have recently consolidated some of the sites I maintain into one of my hosting accounts. (will post about the provider soon – so far so good) And that includes this blog. Along with this move I have also updated to the latest version of BlogEngine.NET – guilty of not being up to date for…

  • SQL Business Intelligence Developer Needed (Manila, Philippines)

    We are currently looking for a SQL BI Developer Professional to work with us on exciting, high-profile/scale projects. Feel free to contact me or visit http://www.lwsmedia.com/contact.htm. Looking forward to work with you. [more] Company Profile: Agilone LLC Norwalk, CT USA, Los Gatos CA USA , Istanbul, Turkey  and Manila, Philippines Companies who can effectively understand,…

  • Register for Visual Studio 2010 Beta Exams (.NET 4.0)

    Time for (free) Beta Exams again Information can be found from here http://blogs.technet.com/betaexams/archive/2010/03/17/register-for-tools-utilities-2010-beta-exams.aspx Register via http://register.prometric.com For easier reference, exams available are listed below (along with PromoCode) Exam 71-511, TS: Windows Applications Development with Microsoft .NET Framework 4 – 511BC Exam 71-515, TS: Web Applications Development with Microsoft .NET Framework 4 – 515AA Exam 70-513:…

  • DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component “Fuzzy Lookup” (60) failed with error code 0xC0202009 while processing input “Fuzzy Lookup Input” (61)

    Encountered this error in one of recent tasks involving SSIS Fuzzy Grouping and Lookup. [Fuzzy Grouping Inner Data Flow : SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component “Fuzzy Lookup” (60) failed with error code 0xC0202009 while processing input “Fuzzy Lookup Input” (61). The identified component returned an error from the ProcessInput…

  • Safety settings on this machine prohibit accessing a data source on another domain

    Encountered this message many times with sites using PivotTable component of OWC11 (office web components) “Safety settings on this machine prohibit accessing a data source on another domain” This is a browser restriction (at least with IE). Before resolving this, make sure you are accessing a trusted site. Resolution: 1. Add site to the zone…

  • Philippine broadband connections affected by damaged pan Asian cable

    From SMART/PLDT: Telecom services provider Smart Communications said a pan-Asia cable cut early Wednesday caused adverse disruptions in its international and broadband services. In a statement, Smart stressed the disruption affected its international voice and SMS services. Its Smart Bro and Smart Bro Plug-It services are also affected by the cable cut, which was reported…

  • 24 hours of high quality sql server training for free

    The Professional Association for SQL Server or popularly known aka PASS, one, if not the most popular and biggest group of SQL Server professional in world will be having 24 hours of PASS – a series of online web meetings with the best speakers in the industry [more] Join us online on September 2, 2009*…

  • Free Web Hosting for Filipino Developers

    If you are a Software Developer, Filipino (by nationality or by heart), looking for a little space for hosting your site or blog or simply for testing and practice purposes I might be able to offer you a few MB (starting at 200 MB, in my experience this is more than enough) and one unlimited…

Got any book recommendations?