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

  • My Verisign SSL Certificate Application Experience

    I do have an idea about SSL, certificates and related security concepts but in my previous works, it was someone else (client IT) who did the preparation, request and installation of SSL certificates until lately when I had to do it myself. I also had experience with trial and self signed certificates but still some…

  • Spread Firefox | Download Day 2008

    Firefox 3 now available Download and help set a record Download Day is here! Set a Guinness World Record Enjoy a Better Web Sounds like a good deal, right? All you have to do to help us set the record for the most software downloaded in 24 hours is get Firefox 3 now – it’s…

  • Privacy in sending email to mailing list (BCC)

    I think most people should know this already although I'm not quite sure about that so posting anyways. Most often than not I receive emails being sent to mailing lists where the the individual recipients don't really know each other or even if they do they might not necessarily want the other recipients of their…

  • Browsing Security with NoScript

    While working (or actually just playing around) with the infamous SQL injection attacks seen around lately I think it should be worth mentioning that being a developer browser and your own PCs security security is also important  or as important as securing your web servers and databases. [more] Since the some (most) of the variants…

  • Link: Testing SQL Stored Procedures Using LINQ

    Just ran into this interesting article on MSDN Magazine about using LINQ to test stored procedures. It would be a bad idea to test stored procedures using other stored procedures too (eg. insert SP then verify presence of inserted value using select/load SP) so traditionally we do it using ADO.NET object (conn, commands) to build…

  • Code Generation with MyGeneration

    I had the chance to grab and have a short look at MyGeneration for a few hours over the weekend and I should say I'm quite impressed with the features that it has. [more] In one of my previous companies we developed our own custom code generator to fit the company's standard process/way of doing…

  • Link: SandCastle removed from CodeProject (temporarily I hope)

    Due to popular outcry against having a non-open source project on the site, Microsoft has pulled Sandcastle from CodePlex. According to Anand, Microsoft is considering either moving the project to MSDN Code gallery or republishing the project with the source code. In the mean time you can download the May CTP from Paulo Santos' mirror.…

  • Replacing Recursion with a Stack

    I've been wanting to write about this for a long time and googling didn't return popular hits back then but just had time to write this but sharing nevertheless. In a number of programming interview guides (most notably that of Joel Spolsky) it has been mentioned that one of the ways (note: only one and…

  • sp_executesql error with DDL statements (preventing SQL injection)

    One of the requirement for an application I'm currently working on is for the end user of a web application/site to be able to create objects in the database. There are a number of objects that must be created or manipulated but for the sake of simplicity let's take for example creating a table with…

  • TSQL SubQuery requires a Table Alias

    Subqueries are essentially a query (or queries) inside another query. That is for example a SELECT statement inside another SELECT statement. There is already enough information available in the internet and written materials about subqueries including their common uses, when and how to use them (see bottom of post) and I will not elaborate on…

Got any book recommendations?