how_to_blog+=2;

How to only publish the runtime files of an asp.net application using CruiseControl.net.

jcallico@callicode.com — Tue, 18 Aug 2009 05:00:00 GMT

Since the buildpublisher task copies all files on the source directory, including the .cs files, a custom MSBuild script is needed to take advantage of the _CopyWebApplication option which will only copy the runtime files. An additional step is required to copy any other required assembly on the bin directory since only the application's main assembly is originally copied when using the _CopyWebApplication option.

How to unzip all files in a given folder/directory.

jcallico@callicode.com — Mon, 03 Aug 2009 05:00:00 GMT

Using the FOR command and an unzip program, like the free 7-Zip, all the files in a given folder can be easily unzipped (using C:\Temp in this example):

for /f "tokens=*" %%G in ('dir /b "C:\Temp\*.zip"') do "C:\Program Files\7-Zip\7z.exe" e -y "C:\Temp\%%G"

How to drop all foreign key constrains in a SQL 2005 database

jcallico@callicode.com — Tue, 27 Jan 2009 05:00:00 GMT

Today I needed to delete all foreign key contrains in a SQL 2005 database in order to be able to sync it using the Visual Studio Data Compare Tool. I found a script doing almost what I needed but after running it I noticed that it also dropped indexes and defaults in all the schemas. I made some changes to accomplish the following:

1- Drop foreign key contrains only.

2- Filter by schema.

3- Don't execute the drop statements automatically just print them.

How to enable CURL for PHP on Windows

jcallico@callicode.com — Tue, 08 Jan 2008 05:00:00 GMT

These are the steps that worked for me:

Uncommented the line "extension=php_curl.dll" in php.ini file.
Copied libeay32.dll and ssleay32.dll to C:\WINDOWS\system32.

Note that these two dlls can be found on the PHP folder under the dlls folder. Adding this folder to the Windows PATH variable should also work.

You can use this simple test script - which retrieves and displays yahoo.com homepage - to verify that CURL is now working:

$ch = curl_init("http://www.yahoo.com/");
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_exec($ch);
curl_close($ch);
?>

More ...