Question 1: Does the Witness only monitor the SQL servers or does it handle any transactions? Answer 1: From the link below: “The witness server assists the principal or mirror in forming a quorum. If a witness server is present,...

One of the questions I was asked at an event last week was about doing a side-by-side migration to a new SQL Server 2005 machine from an old SQL Server 2000 machine. Q: Can i rename the new machine to have the same name as the old machine once I...

I had been asked last week if you could rename the SA account. I replied "No you can not, it's protected." Oh how wrong can I be? Apparently very wrong. My illustrious colleague Matt Hester pointed me to a blog that has the exact procedure you need to...

I've done several events this month, Raleigh, Charlotte and Birmingham, AL and will be doing Atlanta on Thursday. If you attended and had any questions that I was unable to answer at the event, please post them here so that everyone can see the answers...