La Place
WebUtility Class (System.Net)
using HTML Encode and Decode helper methods in console applications without adding reference to System.Web dll
Enable page rendering using highest mode available in IE
<meta http-equiv=”X-UA-Compatible” content=”IE=edge” >
Source: msdn.microsoft.com
TFS Command to check pending changes for all users
From the Visual studio command prompt
tf status itemspec /user:* /recursive
Enable CLR SqlServer script
EXEC sp_configure ‘show advanced options’ , ‘1’;
go
reconfigure;
go
EXEC sp_configure ‘clr enabled’ , ‘1’
go
reconfigure;
— Turn advanced options back off
EXEC sp_configure ‘show advanced options’ , ‘0’;
go
SQL: If Exists Update Else Insert
Performant way of Insert/Updating the data in DB
Page 1 of 7



