rayrayrayraydog's questions

I have been researching the Resource Governor in SQL 2008 and SQL 2008 R2. I gather that I can only really use this to limit the CPU and memory used by certain sessions. It seems strange to me, though, because if I use a governed session to create a block on another table/session, doesn't using Resource Governor make the situation much worse?

Let's say that my query in the default pool (allowing 100% CPU/Memory) would execute in 10 seconds while holding blocks in 3 tables because I've done a poor job of optimizing it.

Now let's say I am governed to 10% CPU and 10% Memory and I run the same query. It would take much longer to execute because of Resource Governor. It follows that it would block for that much longer, right?

I would really want to avoid that problem by configuring Resource Governor to not allow my session to block objects in the first place, and give me an error message. Is that not possible?

Let me know if that makes any sense at all.

Users of a website hosted by our organization occasionally send complaints that our registration confirmation emails are infected with HTML/Redirector.C. They are always using an MS Exchange Server with the MS Forefront for Exchange AV add-in. The thing is, I don't think the detection is legitimate. I think the issue is that the link in the email we send causes a redirect. I should point out that this is done for a legitimate purpose. :) Has anybody run into this before?

Naturally, Microsoft provides absolutely no good information on this one: http://www.microsoft.com/security/portal/Threat/Encyclopedia/Entry.aspx?Name=Trojan%3aHTML%2fRedirector.C&ThreatID=-2147358338

I can't find any other explanation of HTML/Redirector.C on the Internet either. If anyone knows of a real description for this virus that would be greatly appreciated as well.

Is anyone else having problems with the iPad IPSec (Cisco) VPN configuration?

I've configured a Cisco VPN connection to a PIX 501 firewall on a 32GB Wifi Apple iPad. This is done in Settings -> General -> Network -> VPN -> Add VPN Configuration -> IPSec tab. When everything is set up properly and I attempt to connect I just get a popup that says "Enter your user authentication" with no fields to enter either piece of info, and just OK and Cancel buttons.

I've read about similar problems with the VPN client built into Mac OS X and the iPhone 3GS but never with the iPad. Does anybody know a solution? I'm not afraid to change the configuration of my PIX 501 if that's necessary.

We are working to get a large (inherited) VMware ESX 3.5 environment with multiple SANs under control. We first need to create a diagram / Excel spreadsheet / whatever that explains what VM is stored where. This is a rather time-consuming task to complete by just using the VI client to copy down everything. Is there a good script or tool out there that can do this for us?

I would like to see: VM Name, LUN, Actual file-name/location of VMDK/VMX, Power State, Host

Any ideas?

We've recently upgraded our TFS server to TFS 2010 from 2008. We've been researching a couple new add-on checkin policies we want to install. The only problem is that all documentation I can find on adding new policies to the server appears to be specific to TFS 2008 or earlier. Those steps involve adding new keys in the registry which do not exist on our 2010 TFS server. Does anybody know where the process to install new checkin policies on a TFS 2010 server so they can be applied to Team Projects is documented?

Thanks!