Effective Thoughts

Alternatives to using Outlook IMO, nothing really stacks up...especially Office 2003.

Reading a collection from a .Net .config file

http://www.gotdotnet.com/team/fxcop/ FxCop is a code analysis tool that checks .NET managed code assemblies for conformance to the Microsoft .NET Framework Design Guidelines. It uses reflection, MSIL parsing, and callgraph analysis to inspect assemblies for more than 200 defects in the following areas: Library design Localization Naming conventions Performance Security FxCop includes both GUI and command line versions of the tool, as well as an SDK to create custom rules.

Good book for developers Good book for administration Not released yet but this book looks intreguing All Sharepoint books Good Sharepoint BLOG Sharepoint Admin Guide Sharepoing Server Help Sharepoint FAQ Sharepoint Community

http://wks.uts.ohio-state.edu/basic_unix_guide/unix_guide.html

findstr /M /S "PROFILE_PRIBUSINESS" *.* >> PROFILE_PRIBUSINESS.txt

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/secmod98.asp http://www.microsoft.com/technet/security/tools/mbsahome.mspx

http://developer.irt.org/script/window.htm

Some resources to draw info on SQL Server memory usage, locks, fragmentation, etc. This is my favorite SQL Server tuning site: http://www.sql-server-performance.com/ SQL Server Perf Mon SQLServer: Access Methods - Page Splits/sec: Number of page splits occurring as the result of index pages overflowing. SQLServer: Databases - Data File Size (KB) SQLServer: Databases - Log File Size (KB) SQLServer: Databases - Log File Used Size (KB) SQLServer: General Statistics - User Connections: Number of users connected to the system. SQLServer: Locks - Average Wait Time (ms): The average amount of wait time (milliseconds) for each lock request that resulted in a wait. SQLServer: Locks - Number of Deadlocks/sec: Number of lock requests that resulted in a deadlock. SQLServer: Memory Manager - Total Server Memory (KB): Total amount of dynamic memory the server is currently consuming Many, many others… Queries View Blocks SELECT spid, blocked, waittype, getdate() AS 'Time' FROM master.

SELECT 'DROP INDEX ' + object_name(id) + '.' + name AS Hypothetical FROM sysindexes WHERE indexproperty(id, name, 'IsHypothetical') = 1

SelfSSL

http://www.isapirewrite.com/

ALTER DATABASE DB_Restore_To SET SINGLE_USER GO RESTORE DATABASE DB_Restore_To FROM DISK = 'C:\MSSQL\DB_Restore_From_Full.BAK' WITH NORECOVERY GO RESTORE DATABASE DB_Restore_To FROM DISK = 'C:\MSSQL\DB_Restore_From_Diff.BAK' WITH NORECOVERY GO RESTORE LOG DB_Restore_To FROM DISK = 'C:\MSSQL\DB_Restore_From_Tran.TRN' GO ALTER DATABASE DB_Restore_To SET MULTI_USER GO

http://www.codeproject.com/dotnet/vbnet_c__difference.asp

http://www.smallbizpipeline.com/161501340

http://blogs.msdn.com/michael_howard/archive/2005/04/04/405246.aspx