I read it each week and I usually find at least one useful link each "issue."

The statement wasn't ill-considered. It's a reflective statement of not only my experience, but also the experience of many DBAs and developers (I was one when I wrote that statement,...

Are you needing to get the SIDs as they change from the OS or make sure that the database users match up to the SIDs already in master? If that's...

Process Explorer from SysInternals will also allow you to do this. It does include the ability to find a particular DLL in use (it's a menu option... shortcut key of...

You can do this by making the second job start as a job step in the first. For instance, calling sp_start_job from the first job itself.

Do you mean the db_ddladmin role?

If that's the role, they can create objects. If they didn't create the object with a different owner, they'll be able to select against the...

I understand well the problem you're trying to solve. However, while throwing a trigger on top of a system table (even if it worked) only masks the problem, it doesn't...

Others have done some testing on this (Robert Marda) and have found they will not consistently fire. On some tables they will not fire at all.

Yes, if you've got tcp/2433 blocked and you switch on Hide Server, you'll need to open up access to that port. That's one of the flaws with the Hide Server...

No, I've never had to as of yet, thankfully. I think contacting the local field office is the typical way most folks start. Another way looks to be via:

http://www.ic3.gov/

Active\Active means two SQL Server instances running. If you want to stick with only one SQL Server instance, it is Active\Passive with respect to SQL Server only (I'm not including...

This forces the instance in question to tcp/2433. As a result, only one instance can be hidden in this manner. What you can do is block all traffic to/from udp/1434...

Yes, the web application code needs to be tightened up. You didn't say what it was, I assume ASP, but... that needs to be fixed for any and all possible...

Some questions to ascertain more about the how:

1) Do you have a web application which is exposed to the Internet?

2) Is SQL Server exposed to the Internet?

3) Is the...

Sure. Check the files in the following directories:

Program Files\Microsoft SQL Server\80\COM

and subdirs

Program Files\Microsoft SQL Server\80\Tools\Binn

Default Instance:

Program Files\Microsoft SQL Server\MSSQL\Binn

Named Instance:

Program Files\Microsoft SQL Server\MSSQL$<Instance Name>\Binn