Wednesday, May 30, 2012

How to filter sql profiler on database name

Open Microsoft Sql Management Studio
Tools -> SQL Server profiler
Use the Tamplate "TSQL_SPs"


On Event selection Tab -> Column filter


How to copy complied DLL to released version by post-build event command line


Click on the project and choose properties , then on the Build Events run following command on Post-Build event command line:

copy /y "c:\Project\bin\Project.dll" "C:\inetpub\wwwroot\bin\"

PS: you have to run visual studio as administrator to have copy privilege.

Monday, May 14, 2012

Clearing History of Remote Desktop Connection

To remove the history of RDP (MSTSC) you have to access registry in following address:
  HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client\Default


shortcut to acess remote desktop connection is MSTSC