SQL SQL Server – Find Stored Procedures User Can Access Writer #1, 2011-10-25 http://msdn.microsoft.com/en-us/library/ms190310.aspx Returns a report that has information about user permissions for an object, or statement… Continue Reading
HTML Checkboxes Writer #1, 2011-05-16 Occasionally, you discover something that you have been doing wrong for a long time. Sometimes… Continue Reading
PHP and jQuery – Reduce Long String to Preview Length and Reveal Full Text OnClick Writer #1, 2011-05-142023-06-15 Goal: Reduce long string to specified length for end-user preview. Reveal entire string when clicked. … Continue Reading
JSON Returning NULL When Special Characters Exist in Result Set Writer #1, 2011-04-25 Nearly 24 hours of my life lost and I just figured this out. Maybe I… Continue Reading
Finding Duplicate Records In Database Writer #1, 2010-07-082024-06-12 SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK) FROM table1 GROUP BY COL_TO_CHECK HAVING COUNT(*) > 1 ORDER BY COUNT(*)… Continue Reading
C# Database Connections and Queries Writer #1, 2010-07-06 Create connection string:SqlConnection conn = new SqlConnection(“Data Source=DATASOURCE\\\\SQLEXPRESS;Initial Catalog=DATABASE_NAME;Integrated Security=True”); try { conn.Open(); SqlCommand sql… Continue Reading
Droid ConnectBot – Unix SSH on the go! Writer #1, 2010-06-24 Connect Bot I probably don’t need to sell any develpers on the advantages of being… Continue Reading
PHP Ternary Operator – The "IF-Else" Shortcut Writer #1, 2010-06-22 A ternary operator is a quick shortcut to bypass the multi-line if-else statement. It is… Continue Reading
PHP explode and trim the results? Writer #1, 2010-06-22 php.net – where I posted this Overview This is something that I used to use… Continue Reading
JavaScript stripslashes Writer #1, 2010-06-19 Sometimes you have to add slashes to javascript text. PHP has it built in, javascript… Continue Reading