Automating Salesforce Data Imports with Powershell
If you're a programmer and you're doing lots of Salesforce Data Imports, at some point you'll get fed up of messing around with Apex Data Loader and CSV files and look for better options. You might be doing incremental migration and so want to re-run and evolve the migration as the target system evolves. Or you might just want to get the migration automated for scheduling reasons.
Setting up S#arp Architecture 1.6 for VS 2008
The latest S#arp architecure is 1.9 something, rapidly heading towards 2.0, and all targeted at VS2010.
Save DataTable to SQL Server
A couple of times now, I've needed to save in-memory ADO.NET DataTables straight to SQL Server as new tables. Its handy sometimes, if you're importing data from other sources. Nick Tompson had posted some code on the social.msdn forum to do this, and here I've stripped out the features I didn't need and adapted it to use StringBuilders:
Quick Elmah setup
Elmah is great. Its an error logging utility that you can drop into a .net app without changing any code. You just drop the DLL in the bin folder, and make a few web.config changes. OK, these days you can achieve the same thing with ASP.NET Health Monitoring, but Elmah is nice and easy, and the web pages it provides to inspect the error log are cool.
Quick Log4net setup
Log4net has lots of options and different ways it could be configured - these are notes written to myself so that I can get it working quickly.
Reading a CSV file into a DataTable
If you don't share my opinion that CSV should be banned by an international convention, it might be because you've never had to write code to read a CSV file.