VssReporter is a tool for querying SourceSafe

Great tool that st its simplest, VssReporter is a tool for querying SourceSafe to find out what source files have been changed after, before or between certain date(s).

http://www.codeproject.com/KB/applications/VssReporter.aspx

Tracking open file in VS2005/8 within Solution Explorer

When you have multiple files open in Visual Studio 2005 or 2008 it is useful that as you select the files they are selected in the solution explorer as well. This helps you locate the files easier.

To turn this on or off:

Tools > Options > Projects and Solutions > General

Migrating VS2005 to VS2008

Moving from Visual Studio 2005 to 2008 is a relatively easy thing to do. Basically it involves opening current solutions in VS2008 and converting them. The solutions run correctly with minimal testing (clicking on a few links etc.).

What you need to know

SourceSafe and VS2008
Summary: You need to download Visual Source Safe 2005 Update CTP to get VSS to work with VS2008.
http://blogs.msdn.com/richardb/archive/2007/11/19/vs-2008-users-remember-to-download-the-sourcesafe-ctp.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=FAF41EDD-924D-449F-AEFC-9C86DD499720&displaylang=en

Solution Files and Conversions
Summary: Articles describing what the file conversion process does.
http://geekswithblogs.net/etiennetremblay/archive/2007/11/23/The-difference-between-VS2005-and-VS2008-Solution-files.aspx
http://blogs.interknowlogy.com/billsheldon/archive/2007/08/29/21175.aspx
http://www.west-wind.com/weblog/posts/234883.aspx

VS2005 and VS2008 can co-exist
Summary: Articles on how to get VS2005 and VS2008 to co-exist.
http://blogs.msdn.com/djpark/archive/2007/11/07/how-to-use-solutions-and-projects-between-visual-studio-2005-and-2008.aspx
http://forums.asp.net/t/1231497.aspx
http://msmvps.com/blogs/jon.skeet/archive/2007/11/20/vs2005-and-vs2008-co-existence.aspx


VS2008 can target multiple versions of the .NET framework

There is an easy way to automatically upgrade files without running the conversion wizard for each solution.
http://coolthingoftheday.blogspot.com/2007/11/easy-vs2005-to-vs2008-solution.html

Utility to convert movies to play on iPod

This utility allows you to convert movies and watch them on your iPod:

http://handbrake.fr/?article=download

Microsoft's free Virutal CD Control Tool

This great tool VCdControlTool.exe is used to mount iso files and it's free.

Source: http://spikex.net/blog/2007/02/02/microsofts-hidden-iso-mount-utility/

Setup CruiseControl .NET

Great article on how to setup CruiseControl .NET.

http://ilmatte.wordpress.com/2008/06/01/cruisecontrolnet-tutorial-part-1/

Debug VBS file in VS2005

If you would like to debug a Visual Basic Script (vbs) file in Visual Studio 2005 it can be done quite easily. In the command line editor browse to the directory of the vbs.

Type the following to bring up a Visual Studio debugger:

cscript nameofVBS.vbs //x

Attach:

Setting Up Log4Net For Multi Layered Applications

I am working on a multi layered application with numerous projects. The log4Net config is setup within a console application and I want to log messages from the other assemblies so they are funneled into the original log.

This article explains how to set this up: http://haacked.com/archive/2006/01/13/SettingUpLog4NetForMultiLayeredApplications.aspx

Oracle/PLSQL: Synonyms

Source: http://techonthenet.com/oracle/synonyms.php

A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.

Problems with zip file names in UNICODE

There are problems with zip file names that are UNICODE. Check out this page: http://community.icsharpcode.net/forums/t/4546.aspx

CHARACTERSET and Sql Loader

Good examples:

• http://www.akadia.com/services/ora_sql_loader_utf8.html
• http://www.csee.umbc.edu/help/oracle8/server.815/a67789/ch3.htm#5014

SQL Loader

What is SQL Loader?

Source: http://www.orafaq.com/wiki/SQL*Loader_FAQ

SQL*Loader is a bulk loader utility used for moving data from external files into the [[Oracle database]]. Its syntax is similar to that of the [[DB2]] load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.

Data can be modified as it is insert by using the decode command: http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_modify_data_as_the_database_gets_loaded.3F

Decode is like and if-then-else command.
http://techonthenet.com/oracle/functions/decode.php

ASP.NET Development Server

You might have notice that when you debug with VS2005 and VS2008 ASP.NET Development Servers are created. You can see them in the taskbar. Sometimes there are multiple servers for one project and this is because the project has references to web service(s).

Using PL-SQL REPLACE function

Examples:

SELECT REPLACE(url, 'localhost:1001','localhost') AS Test
FROM cmn_pt_site_map
WHERE url LIKE '%localhost:1001%'

UPDATE cmn_pt_site_map
SET url = REPLACE(url, 'localhost:1001','localhost')
WHERE url LIKE '%localhost:1001%'