only My site

Monday, October 29, 2007

Web Dev Tools

Fiddler Tool
Fiddler is a HTTP Debugging Proxy which logs all HTTP traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP Traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language.
Fiddler is freeware and can debug traffic from virtually any application, including Internet Explorer, Mozilla Firefox, Opera, and thousands more.
http://www.fiddlertool.com/fiddler/

Internet Explorer Developer Toolbar
http://www.microsoft.com/downloads/details.aspx?familyid=e59c3964-672d-4511-bb3e-2d5e1db91038&displaylang=en

HTTP Analyzer tools
http://www.shareup.com/HTTP_Analyzer-download-34678.html

HTTP Watch
http://www.httpwatch.com/download/

Wednesday, October 24, 2007

T-SQL - Tips for Developers

--To list the DB Names
SP_HELPDB
--To rename DB
SP_RENAMEDB
--User Def Table list
SP_TABLES
--User Def Table list with wildcard filter
SP_TABLES '%Attr%'
--Lists all the SPs uses the table object
SP_DEPENDS tableName
--SP Proc full list
SP_STORED_PROCEDURES
--SP Proc list with wildcard filter
SP_STORED_PROCEDURES '%SomeText%'
-- to get the table structure information
SP_HELP tableName
-- to get the SP code
SP_HELPTEXT spName
--Utility to take the class property name
select 'Namespace.Class.' + syscolumns.name objectname
from sysobjects,syscolumns,systypes
where sysobjects.id = syscolumns.id and
syscolumns.xtype = systypes.xtype and
syscolumns.isoutparam = 0 and
systypes.xusertype in (56,61,62,108,167,231,239) and
sysobjects.name = 'TABLE_NAME'
order by syscolumns.colorder

Saturday, October 6, 2007