For performance reasons you might want to. For instance, if you have several sets of drives and you know what data you want to segregate because they get hit concurrently,...

It is pitch black. You are likely to be eaten by a grue.

>

How To Use IPSec to Provide Secure Communication Between Two Servers

This is the basics on how to setup an IPSec policy. The example they use is...

It's not a Microsoft design issue, per se. NTLM's limitation is due to security reasons and I think it a holdover from IBM's LAN Manager protocols. Kerberos is an Internet...

This is a topic that's not really going to be answerable in a forum post. But basically here's what you do.

You determine the minimum rights the web application needs. Where...

You can use the system stored procedure sp_addlogin for a SQL Server-based user. You can use sp_grantlogin to grant access to a Windows user or group.

I'll take the parking, but I still consider myself fairly young. Just barely on the other side of 30. When I broke in, I broke in young.

In that case you're running into a double-hop issue. NTLM (NT 4 domains) doesn't allow it and you can get around it in Kerberos (Active Directory) by configuring delegation. Basically...

Wow, this does bring back memories. I used to run BBSes that ran the various incarnations of trade wars. Matter of fact, I broke into the industry writing Doors for...

It's not impossible. The catch is what context the web application runs under. You probably have the web app running where anonymous connections are allowed (your users aren't being prompted...

Unless it's a security related function or stored procedure (like sp_addlogin), Profiler will give you the exact command issued. You have to toggle SQL statement instead of SQL batch, however,...

As Scott has indicated, there isn't a hitch. sp_addlogin was built with the functionality to specify the SID for cases like you've mentioned. In fact, you can get the password...

Agreed. Typically you wouldn't want to use the local system account because it has administrative rights (actually a bit more). This is not necessary as of SP3. However, there are...

We've got our database backups going to a stand alone server which has also our tape devices. It reduces overall load on our SAN and prevents the issue that you've...

Technically CacheMiss events don't belong to any database, and that's probably the reason why. It's looking in the master database at the syscacheobjects table. Hence it won't actually hit the...