We gave the SQLSaturday event and infrastructure to PASS. I'm sure they'll announce it at some point today or tomorrow.

http://www.sqlservercentral.com/blogs/steve_jones/archive/2010/02/02/sqlsaturday-bequeathed-to-pass.aspx

We are hoping PASS will continue to grow this into even...

Gsil,

You get double points for helping that individual.

You need to decide what you want to capture. Then create a table store the info. (user, time, table, etc.)

Here are a couple examples on building a trigger:

http://www.sqlservercentral.com/articles/Administration/auditingyoursqlserverpart1/917/

http://www.sqlservercentral.com/articles/Triggers/triggersforauditing/2143/

http://www.sqlservercentral.com/articles/Triggers/auditingtriggers/579/

Also, a ref: Setting Up Windows Service Accounts.

Ultimately, no, there is no way to prevent a domain admin from accessing SQL Server. If the client owns the physical box, then they can get to everything. Not sure...

LOL, I was working at the nuclear station, about 40 miles from my house. Was a good opportunity as a grad student, so I did it. Loved it.

Got promoted, offer...

You would have to scan the trace information for deletes. You could use a trigger to capture delete info and drop it in another table.

I used to drive 110 miles each way for a job. Did that for about 6 months.

Tempdb is a database, like the others ones on your system. If it grows, it needs that space to grow. It does not shrink back down once a process is...

Not sure you can read the error log with T-SQL. It's just a text file, so you can scan it with FIND, TAIL or other command line utilities. The downside...

That's an interesting thought on the partitioning. I would think it would be an issue. If you go to SSDs, I think you want to use the entire drive as...

You're certainly not forced to pay for an upgrade, but why would you expect someone to upgrade a tool for free?

Will the database still be correct for testing if you have orphaned rows?

Typically you truncate the children, then the parents. That way your relationships are intact.

I don't believe you can do this with the mdf as well.

ALTER LOGIN (http://msdn.microsoft.com/en-us/library/ms189828%28SQL.90%29.aspx) doesn't map to users. the ALTER USER (http://msdn.microsoft.com/en-us/library/ms176060%28SQL.90%29.aspx) is what you use to connect the login to the user.