Yes you can, look up the MCTS or MCITP certifications. you can specialize with SQL Server. For 2005, the base test was 70-433, and it has a good portion of...

http://www.mssqltips.com/tip.asp?tip=1046

I'll add this to our list.

And, unfortunately, I think some of these companies decide that they'll let some data get stolen, and deal with a few people rather than protecting it because of the costs.

Some...

I don't have much experience, other than as a client, but I'll let you know that we have a bunch of nHibernate here. It made the initial development quicker, but...

We'd like to see you try. This isn't consulting where we do the work, but rather where we help.

If you need to summarize data, you can use COUNT() or SUM(),...

It might be because it partially ran before? Are you sending to a brand new database? That error looks like an error with a naming collision.

Reporting Services (and Analysis Services and Integration Services) are parts of the SQL Server platform. They come for free, but you have to buy and install a SQL Server license.

What are you trying to do with the query? That might help us recommend a view or a stored procedure.

There is relatively little overhead, and as the number of rows grows, the overhead becomes less of an issue. You basically calculate the index size of one row, using data...

I'll have to check on the spell check feature.

This feature should be working. My guess it's an intermittent error or that the file is bad. Please ask the person to resend it.

Didn't test it, and perhaps there are none. In any case, I think it's been a nice debate/discussion of the technique.

Identities alone shouldn't cause Access issues.

However, I can see issues with your trigger when you update multiple rows. That would cause issues.

I didn't think it was a good design, and not sure it really saved space, but I knew it would generate discussion. Lots of people, especially developers, think this way....