Friday, April 29, 2005

Microsoft Outlook Alternatives

Alternatives to using Outlook

IMO, nothing really stacks up...especially Office 2003.

Reading a collection from a .Net .config file

Reading a collection from a .Net .config file

Wednesday, April 27, 2005

FxCop .Net code analyzer

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.

LINKS: Sharepoint Portal Development

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

HOWTO: *nix Primer

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

HOWTO: Search from CmdLine using FINDSTR

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

HOWTO: Deploy ASP.Net in a Secure Fashion

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

HOWTO: Control browsers with JavaScript

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

HOWTO: SQL Server: Reporting on performance

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..sysprocesses (nolock)
WHERE blocked <> 0

View a whole lot of info on processes
SELECT *
FROM master..sysprocesses (nolock)

View process info sorted by memory usage
SELECT *
FROM master..sysprocesses (nolock)
ORDER BY memusage DESC

How to monitor SQL Server 2000 blocking


Stored Procedures (system)
Sp_lock
Sp_who
Sp_who2
Sp_monitor
sp_spaceused

HOWTO: Clean out SQL Server Index Wizard hypothetical indexes

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

HOWTO: Self sign SSL Certificates in IIS 6.0

SelfSSL

HOWTO: Redirect http to https under IIS

http://www.isapirewrite.com/

HOWTO: Restore a differential database backup

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

Article comparing VB.NET and C# languages

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