Ryan Garaygay
.NET Developer Notes » remove/delete svn folders
Since I've been using SVN and stumbled upon this technique I've also been using since then This is one of the many (but easiest way) to remove SVN folders (.svn) recursively from a given folder. Effectively "unbinding a folder from SVN" Follow these easy steps: 1) download this registry file : DeleteSVNFolders.reg (313.00 bytes) - see below notes for more … [Link]
.NET Developer Notes » 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: 1) be careful in doing anything fancy on JOIN predicates (that is the condition in the "ON" section) most of the time anything … [Link]
.NET Developer Notes » 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 in the "SSIS Data Flow … [Link]
.NET Developer Notes » 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 a couple of reasons: Anyways, … [Link]
.NET Developer Notes » 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. Company Profile: Agilone LLC Norwalk, CT USA, Los Gatos CA USA , Istanbul, Turkey and Manila, PhilippinesCompanies who can effectively understand, process and take value from their data … [Link]
.NET Developer Notes » BlogEngine.NET 1.6 is Released
For those who haven't updated yet, BlogEngine.NET's latest release came out this February. You can read more details from : BlogEngine.NET 1.6 is Released Feel free to ask if you have some questions about updates (although the folks from BE themselves are probably more equipped to answer) Enjoy! [Link]
.NET Developer Notes » 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/~ 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: TS: Windows Communication Foundation Development … [Link]
.NET Developer Notes » 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 method. The error is specific … [Link]
.NET Developer Notes » 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 (e.g. it is recommended that … [Link]
.NET Developer Notes » 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 to have happened around 10 … [Link]
.NET Developer Notes » 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 Join us online on September 2, 2009* for 24 hours of free, nonstop … [Link]
.NET Developer Notes » 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 size MSSQL/MySQL and probably 2GB/month … [Link]
.NET Developer Notes » Upcoming Blog Topics
Some of the topics to watch out for soon (have been in my queue for sometime). In no particular order. Soon, but if you have issues related to below and might need additional information feel free to contact me. * AJAXControlToolkit ModalPopupExtender, Google Chrome and z-index * delegate/anonymous method cannot be deployed to SQL (SQL CLR) * RedGate SQLDoc (this … [Link]
.NET Developer Notes » Let's Support Earth Hour 2009
Please support Earth Hour 2009. Turn off your lights or reduce energy usage on March 28, 2009 (Saturday) 8:30 - 9:30 PM. Or better yet, know and get involved and take action about climate changes and how to preserve our precious planet. Earth Hour Official Website [Link]
.NET Developer Notes » philippine domains limited one year registration offer
** Philippine (.PH) domains are now available for one year registration (as opposed to being previously available in two-year registrations only). But only for a limited time so grab your .PH domains by clicking HERE now. We are now offering one year domain registrations at $38.00 for a limited time (March 10, 2009 to April 30, 2009). This offer is … [Link]
.NET Developer Notes » define programmer
1) pro·gramÂ&middo~ (n) An organism capable of converting caffeine into code. 2) Semi-sentient being who inexplicably survives an extremely unhealthy lifestyle. Usually found in confined spaces with low lighting, at a computer terminal. 3) One who can read the following example if( !User.IsProgrammer ){ return "Everyone Else"; } Taken from UrbanDictionary [Link]
.NET Developer Notes » Link: IE 8 Release Candidate 1
"Internet Explorer 8 has been designed from the ground up to be enterprise-ready. It helps reduce security risk through features such as a cross-site scripting filter, the SmartScreen® Filter, and safer controls and management of the Microsoft® ActiveX® technologies, platform, controls, scripting, and server framework. And when you download the latest RC1 software, you're automatically registered to access valuable RC1 … [Link]
.NET Developer Notes » TSQL to get SQL Server properties
TSQL script to get common SQL Server properties (edition, instancename et al) SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName~ InstanceName, SERVERPROPERTY('IsClustered'~ IsClustered, SERVERPROPERTY('IsFullTextInsta~ IsFullTextInstalled, SERVERPROPERTY('IsIntegratedSec~ IsIntegratedSecurityOnly, SERVERPROPERTY('IsSingleUser~ IsSingleUser, SERVERPROPERTY('IsSyncWithBacku~ IsSyncWithBackup, SERVERPROPERTY('LicenseType'~ LicenseType, SERVERPROPERTY('MachineName'~ MachineName, SERVERPROPERTY('NumLicenses'~ NumLicenses, SERVERPROPERTY('ProcessID') ProcessID, SERVERPROPERTY('ProductVersion&~ ProductVersion, SERVERPROPERTY('ProductLevel~ ProductLevel, SERVERPROPERTY('ServerName'~ ServerName Taken from: http://sqlserver-qa.net/blogs/t-sql~ [Link]
.NET Developer Notes » My Simple Talk article on ANTS Profiler and Performance
A couple of weeks back, RedGate/SimpleTalk contacted me for a short article about ANTS Profiler. I've been using it for sometime and has definitely been very useful so I won't think twice about recommending it. Here's the link (below) and please do drop by to read it. Feel free to rate/comment Using a profiler to speed (up) application Performance [Link]
.NET Developer Notes » language translation for this site
To be able to share to a wider audience I have placed Google Translation gadget at the upper left side of these pages. I'm a frustrated linguist and I will try my best to write in a way that will likely to produce correct translation but forgive me if I don't. Hopefully soon I can understand your languages too. It … [Link]
