August, 2005

  • Renaming SA in SQL 2005

    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...
  • How to: Rename a Stand-Alone Instance of SQL Server 2005

    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...
  • SQL Server 2005 Mirroring - "I lost my witness your Honor!"

    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,...
  • SQL TechNet Events in NC, AL and GA this month...

    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...