Click here to Skip to main content
15,891,633 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,732     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: 54,517     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: 186,269     Bookmarked: 289   Downloaded: 1,604
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: 63,089     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: 446,318     Bookmarked: 225   Downloaded: 2,841
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: 633,046     Bookmarked: 216   Downloaded: 4,693
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: 53,425     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: 104,466     Bookmarked: 42   Downloaded: 787
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: 51,091     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: 135,057     Bookmarked: 64   Downloaded: 1,987
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: 299,230     Bookmarked: 146   Downloaded: 9,322
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,915     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,943     Bookmarked: 8   Downloaded: 622
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,900     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: 338,635     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: 47,064     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,667     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 !!