I've taken certification examinations from Microsoft, CompTIA, ISACA, and SANS. None of them show the questions answered wrongly. From a testing perspective, you are unlikely to get the same question...

I think we're arguing semantics and that's because I misread your post to imply you favor a domain user account. We're both trying to say the same thing: pick the...

I think a good balance is what CompTIA did on the Security+ exam. They'll show you the focus areas you missed questions. For instance, I believe the language is, "You...

Article?

One of the resources I like to follow to see what recruiters (at least the ones at Microsoft) are thinking about with respect to candidates:

Technical Careers...

Having a certification, if nothing else, shows a willingness to:

a) Either learn the material on the job or study to learn the material.

b) Be measured by a "standard," regardless of...

Then there probably is no trust relationship... meaning that there isn't a way to do this without jumping through a whole lot of hoops. You'll probably want to verify with...

This is the same thing as using the -L command. It has the potential to miss SQL Servers, especially if any of them been set up for hiding or if...

Sugesh Kumar, the link I provided goes to the Microsoft KB article. I have also included the KB article # in parentheses (922804) as a reference as well.

There is a hotfix for SP1 that allowed a change in behavior and this hotfix should be rolled into SP2. However, it requires SQL Server to be started with a...

Windows authentication is more secure. If you're using Kerberos authentication, you also get mutual authentication... the client is able to verify the SQL Server really is the SQL Server and...

If they are not coming from trusted clients, you can't without duplicating user accounts on the client machine and the SQL Server machine. Creating a domain user account won't do.

As...

This one depends... remember the Principal of Least Privilege: assign only the rights needed. If the SQL Server doesn't have a requirement to access network resources, a local user account...

Most firewalls are configured to prevent NetBIOS-based communications. It is unlikely that a network engineer is going to undo this sort of protection without strong justification... there are ways of...

Take a look at the SQL Server 2005 Upgrade Advisor: Microsoft Download Location.