Rodan Sotto's Tech Blog

Front-end Job Interview Questions will serve as a measuring stick for how much (or should I say how little) I know about HTML, CSS, JavaScript, and jQuery. UX Crash Course: 31 Fundamentals is a good resource to catch up / refresh on UX fundamentals. Read More

I use the below SQL script to debug a stored procedure in chunks, replacing or adding into it the rest of the stored procedure code until every code checks out fine.  Since I use transactions, changes are temporary and it rolls back the transaction at the end.  I also used the error handling in SQL Server to catch and print the error line, error... Read More

Here is part 2 of this topic as promised.  It will cover consuming web service using HTTP POST and using jQuery AJAX.  If you missed part 1 of this topic, click here. But before I start, I forgot to mention in part 1 that when you set up your web service as part of a web site, like when you deploy your web service in a virtual directory of a we... Read More

My last post regarding web services was June 13, 2013 and I ended it with an expectation of a sequel.  Fast forward to today, web services have now been regarded by Microsoft as legacy technologies and recommends using WCF services instead.  Then again, with Web API available why use WCF services if you are only using HTTP for these services?  T... Read More

Schemas Data Organization Using Schemas best explains with clear examples what schema in SQL Server is.  Important things to note are: Schemas were first introduced in SQL Server 2005. dbo in pre SQL Server 2005 was used as the default database owner but now it is used as the default schema. Schema is analogous to n... Read More