Just change to delayed start in services.msc. Or, for a more complex solution, disable the SQL services and write a batch that starts the services in correct order after looking...

I'd love to use an iPad to monitor SQL Server, if only for the irony, and to shove iPad access to the domain down security's throat.

After a year of using this in production (see my post in Nov. 2008) and comparing results with the Performance Dashboard report on missing indexes, I don't see any advantage...

I backup local then move the backup file using Teracopy for exactly the reasons mentioned in the first reply. You can do it all via Agent and xp_cmdshell. More IO,...

Yeah, I've read the waits and queues article. It's part of what I used to write a proc that returns intelligible descriptions for many of the more common waits (I'll...

Great util!! One little improvement I made... I added this to the front of the SELECT (just before the first column) to make the create statements, that way you could...

Who said developers have full access to production? Doing a select * only takes read access.

Thank you all for your replies. I have "coached" the offending developers and will periodically...

They only have write access on Dev. If they do it on their Dev boxes and bring them to a crawl, I don't care. It's Production and test environments I'm...

They will honestly to a select * with no where on huge tables and just let it run, pulling all rows and columns.

The logon trigger is actually an interesting...