.NET Helplinks

Sorting Generic lists:
http://dotnetslackers.com/community/blogs/simoneb/archive/2007/06/20/How-to-sort-a-generic-List_3C00_T_3E00_.aspx

Submit only once

http://www.4guysfromrolla.com/demos/DontSubmitTwice2.htm

Changing the default diff tool in VS2005.

How to change the default VS2005 diff tool to my favorite beyond compare.

http://blogs.vertigosoftware.com/teamsystem/archive/2006/01/23/Using_a_custom_compare_tool_in_Team_System.aspx

Sharepoint links.

Team blog:
http://blogs.msdn.com/sharepoint/

Sharepoint DelegateControl

• http://www.sharepointblogs.com/mrbill/archive/2007/05/24/using-delegate-controls-in-sharepoint.aspx

.NET Framework 3.0 training kit

http://wf.netfx3.com/files/folders/presentations/entry8793.aspx

HTML Email in outlook 2007

Now that Outlook 2007 uses word as it's rendering engine, following link can be handy when you are designing HTML emails targeting Outlook 2007.

http://www.edialog.com/pdf/ED803_Outlook2007_limitations_external_POV.pdf

Getting the size of each table in SQL 2000/2005

Declare @SourceDB varchar(50)
SET @SourceDB = 'GSR'
set nocount on
declare @sql varchar(128)
create table #tables(name varchar(128))
select @sql = 'insert #tables select TABLE_NAME from ' + @SourceDB + '.INFORMATION_SCHEMA.TABLES where TABLE_TYPE = ''BASE TABLE'''
exec (@sql)
create table #SpaceUsed (name varchar(128), rows varchar(11), reserved varchar(18), data varchar(18), index_size varchar(18), unused varchar(18))
declare @name varchar(128)
select @name = ''
while exists (select * from #tables where name > @name)
begin
select @name = min(name) from #tables where name > @name
select @sql = 'exec ' + @SourceDB + '..sp_executesql N''insert #SpaceUsed exec sp_spaceused ' + @name + ''''
exec (@sql)
end
select * from #SpaceUsed
drop table #tables
drop table #SpaceUsed