dusty_machines http://christofr.com/blog christofr.com Thu, 14 Feb 2008 22:18:04 +0000 http://backend.userland.com/rss092 en DOS Batch Script to Delete Files in a Directory older than x Days Here's a clever little batch script I found at work, by setting a few parameters near the top of the file, you can run this batch file whenever, to clean up a directory. Typical usage would be to delete all .dmp files in a given directory which are older than 30 ... http://christofr.com/blog/2008/02/14/dos-batch-script-to-delete-files-in-a-directory-older-than-x-days/ Error 14426: A log shipping monitor is already defined - How To Fix! I've been trying to set up log shipping between two boxes running Sql Server 2000 - but everytime I got to the last step, I'd get the above error. This is actually really simple to fix! On a previous attempt, running the Log Shipping wizard, the wizard had finished uncleanly, not ... http://christofr.com/blog/2007/10/16/error-14426-a-log-shipping-monitor-is-already-defined-how-to-fix/ Lightning Quick .NET Profiling Here's a super-quick tip for evaluating the time-hit of a section of .NET code. You'll obviously want to use profiling tools once your application has taken shape, but I've been in the situation many times where you want to quickly evaluate several code options. Simply use the System.Diagnostics.Stopwatch class to record the ... http://christofr.com/blog/2007/09/12/lightning-quick-net-profiling/ ASP.NET & C# - Merge DataTables based on Common Value Want to do the equivalent of an sql inner-join, on two .NET DataTables? I wrote the code below some time ago, you can use it to effectively merge two datatables. Use the static method, Merge, like so.. DataTable ANewMergedTable = DataTableMerger.Merge(DataTable1, DataTable2); This method will (a) see if any columns in the first datatable ... http://christofr.com/blog/2007/08/30/aspnet-c-merge-datatables-based-on-common-value/ How To Fix: Provider: Named Pipes Provider, error: 5 - Invalid parameter(s) found Are you coming up against this error, when connecting to SQL Server? An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote ... http://christofr.com/blog/2007/08/24/how-to-fix-provider-named-pipes-provider-error-5-invalid-parameters-found/