Grant Fritchey (9/23/2011)

---

GSquared (9/23/2011)

---

Grant Fritchey (9/23/2011)

---

Based on a long history...

Password Safe is an open source product.

Can you define what unresponsive means? Are you sure it's the server and not your client?

The inability to process a login usually means there are DDL triggers in place or...

Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv

BenWard (9/23/2011)

---

If you understand what the server is ACTUALLY doing you can anticipate such problems and think about it before you run it.

People seem to forget that every tool, every...

Yes and no. You have the right idea, but the problem is that UserA is inside SQL Server. When you execute the CLR, you should still be inside SQL Server,...

Excellent list of...

You can, but I wouldn't. Is there some reason you wouldn't want to use something like KeePass/Password Safe?

Thanks for the repost. I'll check those out.

We did a few things at various companies.

At one, once a year we sent a team offsite (random admins/DBAs/Devs) and gave them backup tapes, media for software, and a blank...

Do you have login triggers?

Chris is correct. First you need security and stopgap controls. After that, there are lots of ways to track things. Here is a series I wrote on what worked for...

You should be able to log ship to a higher version. Backup/restore definitely should work back a version or two (http://msdn.microsoft.com/en-us/library/ms186858.aspx). It's just a restore, though if you switch over,...

Set the default during setup or later in the server properties. Master comes from the startup parameter. Everything else comes from stored values in master.

Jason is correct. Rebuilding on the primary will rebuild on the secondary.

There's no magic in log shipping. It backs up the transaction log and restores it. You can configure log...