Francisco,

I haven't seen may good cases, but a few interesting ones were check constraints on tables. Trying to be sure that an IP address was valid, or that a...

I'd agree that MySQL and others will start to integrate other languages into the RDBMS engines, but I don't think SQL will die. For what it can be used for,...

Check the netstat command from a command prompt. Be sure that there is a listener running for your server on that IP. Also, this could be because the SMTP service...

If that gives you problems, be sure you close the object browser in QA. It uses it's own connection.

20 isn't that many. You might spend more time figuring this out than just installing.

Lumigent, ApexSQL, LogPI, all have transaction log reader products.

I don't believe that you can do this.

We got lost in the employee shuffle at Microsoft when our old contact moved on and it took awhile for a new one to appear. I spoke with him last...

Why was it poorly worded? The snapshot agent is an agent needed for replication and the security that should be assigned is important. Reducing your attack surface is something that...

Red Gate software has a low cost compare tool, advertised in the footer, which is highly rated and there is a review on the site. ApexSQL also has one.

You should probably schedule the reindexes for very, very low use times or setup the application to try reconnecting after a few minutes.

The DTS copy Objects task might work. If you don't have a direct connection, create a small db, copy just those procs in it and send the (small) backup to...

Mike,

Apologies, a typo in the filename. It's fixed.

Bob is correct. The question is testing how you accomplish a task, which is what many examinations or interview questions will do. If you got this in a pre interview...

Sorry, that's the best answer of those that are available. You can always attach the errorlogs to the email that will contain the sqldiag output. The answer is correct, perhaps...