http://tylerclendenin.com Glass Bricks In Stone Houses Mon, 18 Jan 2010 21:47:35 +0000 http://backend.userland.com/rss092 en Well, a much overdue update to my father's website has been completed. AlanClendenin.com has been launched on GSL Solutions' FrontRunner CMS.  Check it out, I'm rather proud of it. It's the perfect communication tool for my father, who is politically active and needed a website to publish not only blog posts, ... http://tylerclendenin.com/2010/01/alanclendenincom-launched/ I got myself to thinking about versioning content in a content management system.  It seems to me that when it comes down to it versioning of content is integral to the success of long term usability of a CMS.  As any website grows more and more users will need to ... http://tylerclendenin.com/2008/09/thoughts-on-cmss-as-version-control-systems/ I have wondered for a while if there is a way to use SQL Server's BULK INSERT command using BLOB or CLOB data Instead of a local file. The reason for this is that when writing imports, using both Coldfusion and PHP, parsing and importing the data into the database is ... http://tylerclendenin.com/2008/09/sql-server-bulk-insert-using-a-data-field/ Here I am compiling information as a windows user that I needed or should have known while working with Git. CRLF Issues Git by default uses binary mode to transfer files.  On windows to prevent line break issues the option "core.autocrlf" can be used to convert CR+LF to LF automatically. ex. git config ... http://tylerclendenin.com/2008/09/git-for-windows-users/ Follow the banner link below to take the 2008 A List Apart, The Survey for People Who Make Websites http://tylerclendenin.com/2008/08/a-list-apart-survey-2008/ I use this function when writing reports. Use: [sourcecode language='sql'] SELECT time.Date , Count(tab.ID) AS [Count] FROM dbo.TimeDimension('1/1/2007 00:00:00', '12/31/2007 23:59:59', 'month', 1) time LEFT OUTER JOIN TempTable tab ON tab.DateCreated BETWEEN time.Date AND time.DateEnd [/sourcecode] Here is the function. I don't know if there is a better way to do this, if there is can someone tell me. As far as ... http://tylerclendenin.com/2007/07/ms-sql-server-time-dimension-udf/ SQL Server 2000 xp_MD5 at http://www.codeproject.com/database/xp_md5.asp Also works in SQL Server 2005 32 bit SQL Server 2005 [sourcecode language='sql'] DECALRE @Data varchar(MAX) SubString(master.dbo.fn_varbintohexstr(HashBytes('MD5', @Data)), 3, 32) [/sourcecode] Works in SQL Server 2005 32 and 64 bit Solution found at http://www.codeproject.com/database/xp_md5.asp?df=100&forumid=32460&select=1519990#xx1519990xx http://tylerclendenin.com/2007/06/md5-hash-in-sql-server-2000-and-2005-32-bit-and-64-bit/ Hello there, this is my first blog at tylerclendenin.com. To start let me tell you a little about myself. I am a web developer at GSL Solutions. I am the keytar player for the band falterboy. I like manga and anime. My favorite color is green. My favorite band is Nine Inch Nails. What do I hope ... http://tylerclendenin.com/2007/02/my-introduction/