SQL Server PerfMon counters for tracking Windows memory

In part 1 of this series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through significant PerfMon counters for tracking Windows memory. In this screencast, you'll learn the maximum numbers to watch for when using PerfMon counters as a method to avoid memory pressure in your SQL Server system.
http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1302600,00.html

Silverlight - Getting Started
The Silverlight Community site at http://silverlight.net contains samples, tutorials and quickstarts for Silverlight. You can find detailed developer information at http://.microsoft.com/silverlight and http://msdn.microsoft.com/silverlight.

Some great blogs from the development team behind Silverlight can be found at:
http://blogs.msdn.com/jstegman/
http://blogs.msdn.com/mharsh/
http://blogs.msdn.com/webnext/>/li>
http://blogs.msdn.com/brada/
http://weblogs.asp.net/scottgu/

The Channel9 site for Silverlight can be found at http://channel9.msdn.com/tags/Silverlight.

How to find out if a trigger was fired by a delete transaction?
A popular method is to compare the counts of the inserted and deleted virtual tables to see if they match. Here is a simpler method: use the Columns_Updated function. When a trigger is fired by a delete transaction, Columns_Updated() always returns the varbinary value 0x. The following check will verify that the trigger was fired by a delete:
If Columns_Updated() = 0x

SQL Browser account

I had set up a new SQL Server and used the same domain user account for SQL Service and SQL Browser.The account is added to the SQLServer2005SQLBrowserUser$[ComputerName] local group. Later noticed setup set “Deny access to this computer from the network.” local policy right to this account.Now no other server that is using same account can talk to newly installed SQL server. Why exactly it has been done this way?
Since SQL Browser is a service listening to unauthenticated UDP messages, the goal was to make the service running account as restrictive as possible. This has been documented in the BOL: http://msdn2.microsoft.com/en-us/library/ms181087.aspx

How To: Relocate the MIIS 2003 Database
This How To guide describes the process of relocating the MIIS 2003 database, named MicrosoftIdentityIntergrationServer from a computer that is running Microsoft® SQL Server™ 2000 to another computer that is running SQL Server 2000 with all critical data intact. Specifically, you will perform the following tasks:
• Stop the MIIS service, backup the MIIS 2003 encryption key and MIIS 2003 database.
• Restore the MIIS 2003 database to another server hosting Microsoft SQL Server 2000 Enterprise Edition.
• Uninstall and reinstall MIIS 2003 to point to the new server hosting the MIIS 2003 database.
More:
http://technet2.microsoft.com/WindowsServer/en/library/244b15d1-6363-42f0-b853-a62591b3fb021033.mspx?mfr=true

Can you have federated and non-federated sites in the same WSS site? If you set up WSS on the default site in IIS with one application configured as a federated token based app, does that mean that all other sub-sites have to be federated as well?
Options are:
1. Create a new web site that can be used for the non ADFS enabled sites
2. Install WSS which will install to the default web site. Create a second web site and configure the second site as a WSS site in sharepoint central administration. Now uninstall WSS from the default web site. At this point you can install other ADFS as well non ADFS enabled apps to the default web site.

Is the object always deleted from the metaverse when the last connector is disconnected (even if I am using ShouldDeleteFromMV to explicitly say leave object in the metaverse even if the last connector has disconnected)?
Yes, it is. A MV object requires a connector as justification for its existence. The sync engine removes automatically all MV objects without a connector. This is independent from the configuration of the object deletion rule.

How to monitor https traffic? Is there any IE plug-in available?
Look into:
http://www.ieinspector.com/httpanalyzer/index.html
www.parosproxy.org
http://www.fiddlertool.com

Is there a way to export MIIS flow errors to file to have a closer look?
You can use CSExport, there is a parameter to only export objects that show an error, '/:fe. CSExport is in the bin directory under the MIIS install folder. So if you ran 'CSExport AD ADErrors.log /f:e' from that directory, it should create XML file that only shows errors. Of course you would need to further parse this if you were interested in only the DNs.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mmsdev/mms/hologram_xml.asp

Looking for a script to get the security process for “Delegate Control” on specific OU’s, to enable users within those OU’s to reset account passwords?
Good starting point could be, sample scripts for managing Active Directory organizational units:
http://www.microsoft.com/technet/scriptcenter/scripts/ad/ous/default.mspx?mfr=true

You receive an "HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials" error message - Support article.

when you try to access a Web site that is part of an IIS 6.0 application pool
This behavior may occur if the following conditions are true:• The IIS 6.0 Web site is part of an IIS application pool. • The application pool is running under a local account or under a domain user account. • The Web site is configured to use Integrated Windows authentication only. In this scenario, when Integrated Windows authentication tries to use Kerberos, Kerberos authentication may not work. To use Kerberos authentication, a service must register its service principal name (SPN) under the account in the Active Directory directory service that the service is running under. By default, Active Directory registers the network basic input/output system (NetBIOS) computer name. Active Directory also permits the Network Service or the Local System account to use Kerberos.
More: http://support.microsoft.com/kb/871179/en-us