It would not be a bad idea to have some of these questions thought out before your next interview! I was discussing this with my wife a couple of...

It's the only way to be sure that the business rules will be enforced -- put it all in the database. Take a clue-by-four upside the head of anyone...

Oh, man! That guy is frightening! If that's where the industry is leading, I'm getting back into photography and letting my wife support me!

Juan, you can pick up the SQL Server 2005 Developer Edition for around $50(US) or less, and it's not time-expiring, so it lasts forever (but you can't use it for...

This was a major part of my last good SQL Server job. I was formatting data then spitting out a file for uploading to a mainframe. The first...

I took a risk on my laptop and got burned. I was among the legion running as admin, which is a mistake in and of itself. But the...

Yeah, I'm aware of 2000 going out of support. The box that I'm migrating from is kinda shaky, so the migration is going to happen. Plus, it'll free...

I don't trust anyone with my backups. Period. Full stop. They were using a backup agent when I arrived (they had not had a DBA prior to...

Your safest way would be to restore master & msdb first. msdb has all of your jobs and DTS packages, it would be easy to forget restoring it once...

All that bonding does is it shows that in the past you appeared to be a trustworthy person. As the investment adverts say, "past performance is no indicator of...

Couldn't a lot of this could be solved using the crypto features in 2005? Encrypt the salary column, the SSN (assuming it's not your PK), the bank account or...

This is kind of trivial, but....

If you change your date fields to smalldatetime, you save 8 bytes per record (4 bytes per storage value for smalldatetime vs 8 bytes per...

I'd kinda like to see your personal standards document. Sounds like an article in the making...

Two ways come to mind immediately. The first would be to script out the database and re-run the script. The second would be to use the sp_MSforeachtable to...

Always good to review the basics. I noticed that the .\ usage in figure 7 was no different than if I click the ... button without it. Am...