Welcome to TechNet Blogs Sign in | Join | Help

August 2005 - Posts

Wednesday, August 31, 2005 10:53 AM

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
Posted by johnbaker | 0 Comments
Sunday, August 28, 2005 4:14 PM

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 remove
Posted by johnbaker | 1 Comments
Sunday, August 28, 2005 9:26 AM

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, a loss of either the
Posted by johnbaker | 3 Comments
Wednesday, August 24, 2005 1:10 PM

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.
Posted by johnbaker | 0 Comments
 
Page view tracker