Click here to Skip to main content
15,848,407 members

Articles by S. M. Ahasan Habib (Articles: 11, Tip/Tricks: 6)

Articles: 11, Tip/Tricks: 6

RSS Feed

Average article rating: 4.86

Database Development
SQL Server
3 Feb 2013   Updated: 3 Feb 2013   Rating: 5.00/5    Votes: 11   Popularity: 5.21
Licence: CPOL    Views: 28,112     Bookmarked: 13   Downloaded: 0
Please Sign up or sign in to vote.
Database script execution with testing
21 Oct 2013   Updated: 27 Nov 2013   Rating: 4.70/5    Votes: 17   Popularity: 5.66
Licence: CPOL    Views: 53,957     Bookmarked: 19   Downloaded: 260
Please Sign up or sign in to vote.
In this article I explain how can we identify duplicate rows from database table and clean them up. I also cover duplicate XML nodes inside XML type fields having the same problem and a solution.
Programming Languages
C#
16 Dec 2013   Updated: 18 Dec 2013   Rating: 4.79/5    Votes: 157   Popularity: 10.47
Licence: CPOL    Views: 182,939     Bookmarked: 289   Downloaded: 1,600
Please Sign up or sign in to vote.
In this article I will explain one by one of those hot and sexy features with code example. In some section I use question(Q) and answer(A) pattern so that audience can understand better.
30 Jun 2013   Updated: 1 Jul 2013   Rating: 4.82/5    Votes: 24   Popularity: 6.65
Licence: CPOL    Views: 62,579     Bookmarked: 45   Downloaded: 305
Please Sign up or sign in to vote.
I explain how to use System.Lazy class with support of lazy initialization of object
1 Dec 2013   Updated: 6 Jan 2014   Rating: 4.93/5    Votes: 181   Popularity: 11.10
Licence: CPOL    Views: 442,858     Bookmarked: 225   Downloaded: 2,840
Please Sign up or sign in to vote.
In this article, I explain with transaction related theory and code sample, how in various scenarios we can use TransactionScope with various options for managing real life transactions.
Web Development
ASP.NET
12 Mar 2013   Updated: 31 Dec 2013   Rating: 4.82/5    Votes: 129   Popularity: 10.16
Licence: CPOL    Views: 622,636     Bookmarked: 216   Downloaded: 4,688
Please Sign up or sign in to vote.
In this article I demonastrate a very simple and straightforward way to inject controller dependency to ASP.NET MVC framework with constructor.
29 Apr 2009   Updated: 29 Apr 2009   Rating: 4.82/5    Votes: 13   Popularity: 5.20
Licence: CPOL    Views: 52,945     Bookmarked: 38   Downloaded: 678
Please Sign up or sign in to vote.
Custom JSON serializer for the Entity Framework
17 Jan 2013   Updated: 21 Dec 2013   Rating: 4.85/5    Votes: 31   Popularity: 7.16
Licence: CPOL    Views: 103,066     Bookmarked: 42   Downloaded: 786
Please Sign up or sign in to vote.
In this article, I tried to explain step by step, how Nhibernate second level caching can be implemented
19 Jun 2013   Updated: 9 Dec 2013   Rating: 4.97/5    Votes: 24   Popularity: 6.86
Licence: CPOL    Views: 50,471     Bookmarked: 32   Downloaded: 0
Please Sign up or sign in to vote.
I explain in this article what type of challenges may face when any one start migrating their production server.
11 Feb 2013   Updated: 25 Nov 2013   Rating: 4.90/5    Votes: 27   Popularity: 6.93
Licence: CPOL    Views: 131,297     Bookmarked: 64   Downloaded: 1,974
Please Sign up or sign in to vote.
In this article I will demonstrate how to read a large CSV file chunk by chunk (line basis) and populate DataTable object and bulk insert to database.
HTML
11 Nov 2013   Updated: 12 Nov 2013   Rating: 4.88/5    Votes: 104   Popularity: 9.74
Licence: CPOL    Views: 297,020     Bookmarked: 146   Downloaded: 9,321
Please Sign up or sign in to vote.
This article will help beginners to understand how knockout will work with ASP.NET and communicate client-side server side and the usefulness of the responsive UI design.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.87

Database Development
SQL Server
21 Oct 2013   Updated: 3 Nov 2013   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: CPOL    Views: 38,555     Bookmarked: 8   Downloaded: 109
Please Sign up or sign in to vote.
I will explain here how to use table variable and over come cursor limitation
18 Feb 2013   Updated: 18 Feb 2013   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 17,733     Bookmarked: 8   Downloaded: 621
Please Sign up or sign in to vote.
I will explain very simple way to execute multiple script files (*.sql) from a directory.
Programming Languages
C#
14 Oct 2013   Updated: 14 Oct 2013   Rating: 4.38/5    Votes: 6   Popularity: 3.40
Licence: CPOL    Views: 16,720     Bookmarked: 3   Downloaded: 92
Please Sign up or sign in to vote.
I will demonstrate a generic factory method which will create object from interface type parameter from an assembly (either current or provided) with the help of reflection
SQL
13 Oct 2013   Updated: 14 Oct 2013   Rating: 4.85/5    Votes: 56   Popularity: 8.44
Licence: CPOL    Views: 336,185     Bookmarked: 34   Downloaded: 0
Please Sign up or sign in to vote.
From SQL Server 2012 version, when SQL Server instance is restarted then its auto Identity column value is jumped based on identity column datatype.
Web Development
ASP.NET
3 Feb 2013   Updated: 18 Feb 2013   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 46,694     Bookmarked: 14   Downloaded: 0
Please Sign up or sign in to vote.
.NET exe file run inside asp.net and catch exception from .exe.
1 Feb 2013   Updated: 1 Feb 2013   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 50,127     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
.NET TransactionScope and its default Transaction Isolation level issue.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Architect
Bangladesh Bangladesh
How do I describe myself to you? How can I explain that this is true?
I am who I am because of you! My work I love you !!