CLR via C#
by Jeffrey Richter
This is the one i'm reading at the moment. So far it's great! Richter's style is conversational while still precise. The passion he has for software development is clearly evident in his writing. I find that each topic is explained in the way that someone might do if they were helping you out at work. They start simple, and then progress to the advanced features. The examples are decent and "real-world" which is nice, since it can often be hard to see how object graphs made up of cars can apply to your actual code.
Head First Design Patterns
by Elisabeth Freeman et al
This is an excellent book! It reminds me of fun educational books I read before the age of 10. And why should a software development text be boring!? To contradict my statement above, they use example class hierarchies made up of things like ducks, with interfaces like flyable and quackable. However, the depth of the examples surpass the silliness and the examples present poignant issues to do with implementing object design concepts properly.
More to come..
Solutions to frustrating computer problems - includes Windows networking, .NET programming, LaTeX formatting, MySQL, and other PC issues!
Followup to Visual Studio debugger issues on a UNC share
a.k.a. 'I want to develop .NET projects on a remote drive!'
Will not be too detailed - doing this from memory.
1. Ensure the site's .webinfo or .csproj file contains the path to the HTTP path to the UNC share.
e.g. You have it on \\192.168.1.2\w$\dev\projects, where the webroot is pointing to \dev
The path in the above files should be http://192.168.1.2/projects/
2. Open up your .NET security configuration tool (in control panel). This should work for 1.1. and 2.0.
3. Go to Runtime Security Policy; Code Trust.
4. Under Local Intranet, add a new code group.
5. Call it dev server or whatever.
6. Select URL, and enter file://192.168.1.2/w$/dev/projects/*
7. Select Full Trust.
8. Save, and be sure to RESTART visual studio.
9. Success will be evident if VS doesn't complain about the project existing in a non-trusted area.
Leave me a comment if you need any more info/help.
Will not be too detailed - doing this from memory.
1. Ensure the site's .webinfo or .csproj file contains the path to the HTTP path to the UNC share.
e.g. You have it on \\192.168.1.2\w$\dev\projects, where the webroot is pointing to \dev
The path in the above files should be http://192.168.1.2/projects/
2. Open up your .NET security configuration tool (in control panel). This should work for 1.1. and 2.0.
3. Go to Runtime Security Policy; Code Trust.
4. Under Local Intranet, add a new code group.
5. Call it dev server or whatever.
6. Select URL, and enter file://192.168.1.2/w$/dev/projects/*
7. Select Full Trust.
8. Save, and be sure to RESTART visual studio.
9. Success will be evident if VS doesn't complain about the project existing in a non-trusted area.
Leave me a comment if you need any more info/help.
SQL Server 2000: Column values as arguments to table-valued functions
Short answer - impossible. Apparently the issue has been fixed in 2005.
So basically in sql 2000, you can't do this:
SELECT email
FROM [tb_Email]
WHERE
@job_type IN (SELECT * FROM [dbo].[CsvToIntTable](job_type))
where tb_Email.job_type is a field containing data like '1,2,3,4'
and CsvToIntTable returns this data separated into rows.
The server will return an error like so:
'job_type' is not a recognized OPTIMIZER LOCK HINTS option.
Bugger!
So basically in sql 2000, you can't do this:
SELECT email
FROM [tb_Email]
WHERE
@job_type IN (SELECT * FROM [dbo].[CsvToIntTable](job_type))
where tb_Email.job_type is a field containing data like '1,2,3,4'
and CsvToIntTable returns this data separated into rows.
The server will return an error like so:
'job_type' is not a recognized OPTIMIZER LOCK HINTS option.
Bugger!