Oracle weirdness

These are a few differences between Oracle & SQL Server:

• The byte order for guids is different:

0c5f13c3-7063-4b2d-8e58-de9d689bd3b1
becomes
c3135f0c63702d4b8e58de9d689bd3b1

• use "" instead of [] for reserved words. Oracle cares about case when you do this
• use || instead of + to concatenate text.
  


• 
  when searching for a literal _ (underscore) as part of a LIKE search, construct the LIKE statement this way:
  
  SELECT * FROM snuser WHERE username LIKE '%sn\_%'  ESCAPE N'\'
  
  
  this works for both Oracle and SQL Server.
  

webinfo files

When trying to load a VS.NET web project, you get this error:
"Unable to open web project '~name~'. The file path 'C:\InetPub\wwwroot\~name~' does not correspond to the URL 'http://localhost:/~name~'. The two need to map to the same server location. HTTP Error 500: Internal Server Error"

Make sure there is a webinfo file named ~name~.csproj.webinfo:

<VisualStudioUNCWeb>
<Web URLPath = "http://localhost/Keith/Keith.csproj" />
</ VisualStudioUNCWeb>

Can't build project in DEBUG mode

Today, I got this strange error when trying to compile the Portal project:
Unexpected error creating debug information file 'C:\Documents and Settings\kharris\VSWebCache\KHARRIS\obj\Debug\SchoolNet.Portal.PDB' -- 'C:\Documents and Settings\kharris\VSWebCache\KHARRIS\obj\Debug\SchoolNet.Portal.pdb: The process cannot access the file because it is being used by another process.'
I have no explination for it, but when I closed VS.NET and deleted the KHARRIS folder from VSWebCache, everything worked -- cool.

Also, deleting files was painfully slow. As it turns out, this happens when you have a lot of files in the recycle bin. I emptyed it and reduced the Recycle Bin file size to 1%.

So, I have a blog

My friend Jack started a blog last week and it got me interested. While his site will undoubtedly be more interesting and abundent in worthwhile content, this site is just a computer geek blog -- more of a repository for things I want to remember.