Designing UI applications

"Everything is best for something and worst for something else.
The trick is knowing for what, when, for whom, and why." —Bill Buxton


I was involved in Windows based application development for some time and it was seriously lacking a good user interaction guideline doc. I have read lot of books and articles but they are not quite up to the standards. Check this out from Microsoft...

UI Guidelines

Handy sql script to find lost quries

I always forget to save the quires that I'm executing against sql server and want to recover them without writing them back, here's a handy script which I use for this

select objtype,p.size_in_bytes,[sql].text
from sys.dm_exec_cached_plans p
outer apply sys.dm_exec_sql_text (p.plan_handle) sql
where [sql].[test] like '%Something goes here%'
order by usecounts desc