Not exactly .NET related, but very current info. After an MSDE user installs XP SP2, can't remote connect to their MSDE.

Here's info on how to come up with a script that we could mail to them.

839980 - How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2

netsh firewall command info

basic syntax:

netsh firewall ?
netsh firewall set portopening ?
netsh firewall set portopening tcp 1433 SQL1433

netsh firewall delete portopening tcp 1433


some other syntax for the current subnet or a custom network subnet

netsh firewall set portopening tcp 1433 SQL1433 ENABLE SUBNET

netsh firewall set portopening tcp 1433 SQL1433 ENABLE CUSTOM 10.0.0.0/255.0.0.0


Just a good summary of process identity and the various options for ASP.NET and IIS.

(doesn't speak too much about IIS6, which is where I need the help - can't find NetworkService account when trying to add to DCOMCNFG)

317012 - Process and request identity in ASP.NET

Also found these articles about IIS6, machine accounts, groups, etc.
IIS Insider

IIS 6 and built-in accounts

Web page references ServicedComponent, which must be signed.

Building the ServicedComponent object fails, cuz the COM interop wrapper assembly is not signed. (it's generated using tlbimp by the IDE, so no .snk file is specifiied)

Fix: project properties, there's a spot to put the KeyFile for the generated wrapper file.

313666 - PRB: "Assembly Generation Failed" Error Message When You Try to Build a Managed DLL Without a Strong Name

This question always comes up - how to use DataView and RowFilter or Select() method to get a distinct set of rows from a DataTable.

Although not natively supported in .NET 1.1, here's a helper class that accomplishes this with a brute force approach.

326176 - HOW TO: Implement a DataSet SELECT DISTINCT Helper Class in Visual C# .NET

If my WinForms login dialog is set to CenterScreen start position, I want it to center on the main monitor, not spanning the dual monitor margin.

EnumDisplayMonitors( ) can help.

Google Groups: View Thread "dual monitors and running the application"

Thanks to The Screen Savers (glad they're back) for these sites.

Hundreds of streaming audio radio sites from SHOUTcast

Capture them (including auto detect of start/end of songs) to separate MP3s with RipCast

I think there are probably other profilers [any for free?! :) ], but stumbled across this one today.

Update 09/10/04 - here's one that shows memory object graph, call graphs, etc. Very cool.

Download details: CLR Profiler (v2.0)

-----

.NET Memory Profiler - Find Memory Leaks and Optimize Memory Usage in Programs Written in C#, VB.NET or any other .NET Language

Update: Sure enough, more searching found this free one.

Application Profiler from gotdotnet.com

I can't get this to work however on my dev machine. A comment in the download area asks about compatibility with .net 1.1 I get error about MSVCR70.DLL not found.

...and still one more - from SourceForge.net
This one seems to be strictly a performance profiler (% time in functions, elapsed time, etc)

NProf - the .NET profiler

This works "out of the box", but does not have memory consumption details.

Thanks Eric! Good site for looking up the proper signatures for Win32 API calls from .NET.

Setup as a wiki, so users contribute and fill in the missing pieces.

pinvoke.net: the interop wiki!

Ugh - not knowing A THING about Crystal Reports that comes with VS.NET, I stared at the field length of the column forever, wondering why the last char was being chopped off.

String fields are one character less than their defined length

So I added a couple extra chars to the column in the DB, refreshed the report source against the new table, and walah (sp?) !!