I don't know that SOX has really done a whole lot to tighten security. That's one of the issues I have with the legislation as written. You can interpret parts...

Aye, that was another point of confusion, since you can have multiple named server instances (and people have installed such).

This, combined with Steve's article, all makes good material for a blog post.

khoshtip, several members of the community have spoken, not to dissuade...

I'm also having issues with my Yahoo account receiving the emails... Haven't gotten the daily newsletter, the database daily, or any notification emails since about Thursday.

Unfortunately, I have to agree with much of what the author had to say. Case in point: Adobe Acrobat Reader ActiveX control 7.0.1 - 7.0.8 is vulnerable to a remote...

When it did the system check did it tell you of any issues? For instance, do you have IIS installed on that system?

The operating system itself may be the cause, but it's not likely. Do you have anything else that points to a problem (SQL Server error logs, Application and System event...

A mission or purpose I feel is noble (that they are actively pursuing). Idealistic? Sure.

There are some pretty extensive rules on what to open and not to open. The first question is how do you connect to the Extranet? Is a tunnel created by...

Active/Active and Active/Passive is older terminology, which Microsoft tends not to use any more in the newer documents. Basically, if you have a two-node cluster, Active/Passive would mean you only...

Can you explain a bit more what you mean? Do you mean they can see say EXECUTE but not CREATE?

In the System event log (OS), what's the error given for why the MSSQLSERVER service failed to start? Could it be the service account password changed (or expired)? You would...

There is using some batch scripting... Keep in mind you can always issue an AT command... that runs under the System account unless the account is specifically configured in Task...

While this can be done in SQL Server, SQL Server and Agent aren't probably the best tools for this. There are tools, some free, which already do this, though. For...

SQL Server Books Online represent some of the best instructional "manuals" for any product in the industry. Here are the downloads for both SQL Server 2000 and 2005. The downloads...