Lately I have been spending my evening hours developing stored procedures, scalar and table value functions for SQL server in C#. It’s a definite plus to be able to create all the string functions that are “missing” from TSQL and simply add them in. One of the tasks that might accompany your CLR for SQL Server development is the need to completely remove an assembly from a database on your server. Continue reading
A question often asked by WordPress authors is how to write out one or more posts from a single category of posts to a page on their website – preferably using a short code. While there are a number of individual plugins that address this functionality I submit that you can’t get more bang for the buck than to use the free Kazoo Templated Content plugin. Continue reading
I’ve updated the books pages to reflect the most popular books being sold by Amazon. Check them out under the books menu. Each page was created using the Kazoo plugin using a small inline template and the wp_feed template tag.
I just thought I’d wish everyone a happy post Mayan apocalypse.
Whenever I find myself reading data from fixed width text, csv files, delimited files or other data source I almost always find myself performing data transformation and validation at the same time.
Wouldn’t it would be nice to have a .NET assembly that allowed you to read data from all the usual sources and easily perform complex data transformations at the same time? Well now you can. Continue reading
A few months ago I was working on a file transfer client that required SFTP. I quickly learned that one of the challenges of building an SFTP client is finding an SFTP server you can test your code against. If you have faced this problem or might be facing this problem in the future then you will want to have a look at TinySSFTP. Continue reading
If you’ve ever thought about adding or removing content based upon who or what (as in major search engine) was “viewing” your content then the WP-Bot-Content plugin for WordPress may interest you. Continue reading
Hot off the press is the WordBase 1.0 library for .Net 4.0. WordBase is a C# library that allows you to compile word lists into compressed libraries and have them available for loading and searching. The code provides for compiling sorted lists of words into tightly compressed files. The results are highly compacted word libraries that can be loaded whenever large lists of common or proper nouns (or libraries containing both) are required. Continue reading
Some time ago I was trying out a new plug-in for WordPress on my test site. It turns out the plug-in was not only a waste of time but it created a security hole on my hosting account. Locating the problem and patching things up was not difficult and fortunately the hacker who found the security breach was more interested in posting affiliate links than being destructive.
Thankfully I did not have to restore my sites from the latest backup. The only problem was that there were now hundreds of links recorded on the web all pointing to various folders on my sites that would return now be returning 404 pages. Continue reading