I need to store email attachments, which may be an image,file, or document in sql server. Which datatype should I use for the column? would it be nvarchar(MAX)?

Are there any general guidelines on how to write code that can be properly united tested? The goal for me is to able to unit test as much as possible, and to achieve that goal I am sure I have to design my software in such a way for this ...

It would be great if you could see a list of 'top' members who have participated on debugging. Top could mean many things, maybe have it sortable for things like: - most questions/answers - points awarded - accepted answers

I'm starting a new web app, and I want to build it with flexibility and maintainability in mind. In the past I would just create classes that mapped 1:1 with database tables, and then created another class which was kind of a factory tha ...

If I download a backup of a database and store it on my hard drive, when I go and restore the database, will the restore process create a copy of that file and move it to the sql server folder i.e. /data/mydatabase or will it just reference ...

I haven't done the unit testing thing really but I am curious for those of you with more experience with unit testing, is it really practical to write unit tests for all your classes and methods? Or to be more realistic, should one just ...