Andrew Friedl

Analyst/Consultant/Coder

How to drop a CLR assembly from SQL Server

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

Xml, Zip Files and Downloading from the Web

When I first started programming (on punch cards) I was required to specify my data sources within cryptic JCL statements. These days there is data everywhere you look. Downloading and unzipping data from "the web" was unheard of "way back then" however it is a common programming task these days. This brief example gives you the code necessary to get started. Continue reading

Writing posts from a single WordPress category

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

Updated books pages

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.

Read and transform csv, fixed, OleDb, and SQL data easily.

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

An SFTP test server you can run on your desktop

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

WordBase Word Database Software Released

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

Affiliate htaccess

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

“It is a universal truth that the loss of liberty at home is to be charged to the provisions against danger, real or pretended, from abroad.”

~James Madison

Copyright © 2011. All Rights Reserved.