This has been an issue for years. Portable CD/DVD burners? It just comes down to properly securing data. If you give your janitor a network account and permission to view...

Being a student as well as a software developer right now I am in a position where I need to be careful about this very issue on a frequent basis....

Very nice article.

Another thing you can do if the password generator is a command line application is use xp_cmdshell to run the application and output the results to a table....

Performance is all about perception. I like to use typed data sets to collect several database changes and submit them to the database all at once on a single connection...

Great article! I usually keep my stored procedures granular so they can be reused easier. To use the example from the article, I would implement it this way:

Create Proc usp_GetOrderTable...

I think you're on the right track. In truth, the only hard-and-fast rule should be "Be Consistent". If you are deviating from common standards it is good to document them...

You also have to consider how the success is measured. If you're a company looking into offshoring/outsourcing then you need to look carefully at the companies you might partner with....

"Can you see any of the school systems in the US or even other countries coming up with contracts and outsourcing IT to India (or some other country)? Any universities?"

Yes

Performance doesn't matter if you're not returning the correct results. You can't sacrifice accuracy for performance or your program will be worthless. In the case you mention, "var1 IS NULL"...

You would only be worried about the SmallDateTime type in the data access code which, as I said, should be auto-generated. You re-run your code generator, rebuild the solution...

I don't see a big problem with this. About all you need to do to fix it is change to datetime in the table and the stored procedures that...

Don't expect that to work unless you are prepared to move; even then, you'll probably have to. The common argument is cost-of-living. I am in the same boat but I like...

Something important to note about government-published unemployment rates is that those numbers do not include people that have given up. Not to dredge up the work visa thing but there...

Re: QA

One component of agile methods that is absolutely critical is Unit Testing. You can't develop at the speed of thought without constant, reproducable testing. A test-first methodology actually eliminates the...

The whole point to agile development is that we know that requirements are going to change midstream (probably many times). That's fine because the customer can change the priority of...