Have you ever come across a requirement to disable all triggers in current SQL Server database. Here is how you can achieve that. Disable: exec sp_msforeachtable @command1 = 'Alter table ? disable trigger all' Enable: exec sp_msforeachtable @command1 = 'Alter table ? enable trigger all' Enjoy! ... [More]

While working on a recent project I came across a requirement to get all values from a column as a single comma separated string. I thought it worth sharing how I achieved that. Here is a sample (I hope this will help you) declare @table table (CityName varchar(50)) insert into @table val... [More]

Firstly, few words about Lazy loading, it's a design pattern in which you don't load/initialise objects until they are needed. Have a look at following example     public class Curry    {         public int CurryId { get; set; }    ... [More]

I've seen many developers not taking full advantage of jQuery's rich library, so I decided to write about little but useful functions jQuery provides. Today, I’m going to introduce you to :has() selector, according to jQuery description "this selects elements which contain at least one eleme... [More]

Well, it's not many days passed Microsoft launched IE9 and they are already talking about IE 10. Does that shows Microsoft's eagerness to re-claim browser market share, I believe Yes. I'm not sure if all that energy and effort Microsoft is putting into IE is going to pay-off because they have badly... [More]