The post will be brief. This will search for a specific keyword in the desired database. It will search for the specific keyword stored in the columns content for all the tables in the database. This is currently buggy because it will only work for text/char datatypes. Please refer to my comments be... [More]

Ok this article will probabyly reveal two things about me. 1) That I'm addicted to anything that is related to Starcraft 2) My developing methods. 3 Types of Programmers: Zerg, Terran, Protoss http://blog.mathgladiator.com/2010/12/3-types-of-programmers-zerg-terran.html I think of myself as a T... [More]

I haven't posted anything for a while because I've been working on the ultimate developer system, or so I think it is . I wanted a system that was under $1000 that could support multiple VM's at one time and also I could VPN into it. I guess you can say the following is my specs, but I wanted to sha... [More]

When working with departments that have sensitive information, you'll need to be cautious of what you store in your local system especially when it's in a laptop. Of course rule of thumb would be to never store that information in your system, but it's really difficult to avoid when you work remotel... [More]

The following are my favorite cheatsheets (this page will be updated frequently):   jQuery 1.4.2 Cheatsheet (woorkup.com) link, pdf: jQuery-Visual-Cheat-Sheet-1.4.2.pdf (350.34 kb) jQuery 1.4 Cheatsheet (labs.impulsestudios.ca) link, pdf: impulse_studios-jquery_cheat_sheet-1.0.pdf (436.00 kb... [More]

As my passion for programming continue to grow, I've always wanted to know what is considered best practices in C#. I found this article/document: http://dotnetspider.com/tutorials/BestPractices.aspx Programming can be done by anyone who puts their head into it, but coding the applications for the... [More]

This is an RSA animation called Smile and Die narrated by Barbara Ehrenreich. She explains the allusion of false optimism and how this way of thinking would lead to failure or even disaster. This clip was inspiring to me and I always think about it when I'm working on a major project. It's best to l... [More]

In some cases you'll need to transfer parameters/values from one web page to another. If you using C#, http://www.dijksterhuis.org/encrypting-decrypting-string/ shows you how to encrypt and decrypt your message with a password. When I first used this code I had issues with the decryption method. Ma... [More]

Here is a sql server function that will remove any special characters and keep the alpha/numeric value.     CREATE FUNCTION fn_cmk_no_special_char(@text_value NVARCHAR(4000)) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @final_text NVARCHAR(4000) DECLARE @length AS BIGINT DECLARE @c... [More]

When working with flat files, some files would need some fillers. I created this SQL function that will capture the character value, desired length, filler character, and the justification.   CREATE FUNCTION fn_fix_length_filler( @TEXT NVARCHAR(4000), @TOT_LENGTH BIGINT, @FILLER NVARCH... [More]