September 2006 - Posts

26 September 2006
.NET: 10 pitfalls of working with TypedDatasets

Over the past one month I have came to conclusion that using TypedDatasets to represent business objects is not a smart idea. Often many people say the same thing but not until I experienced that pain of it, and that said when I came to situation somebody asking me If will reccommend it, I will certainly... Read More...

4 comment(s)

Filed under: .NET, ASP.NET

21 September 2006
SQL Server: FullText's noise words

Last time I blogged about SQL Server Inflectional Fulltext search filters out artiles like "the", "and", "in" etc. This has caused me headaches than fun when a lot of my test cases for searching failed or returns irrelevant results. I just found out thru my boss that I can turned this off by deleting... Read More...

no comments

Filed under: .NET, sql server , seo, Development Process

21 September 2006
The Murphy's Law In Action

When I first read jenny's post on failing IBM xSeries server the first thing that comes to my mind is the Murphy's Law . I am preparing reply to her post but I can't say much except "If something can go wrong, it will" and "If something simply cannot go wrong, it will anyway". Interestingly i bumped... Read More...

4 comment(s)

Filed under: developer's life, Development Process

14 September 2006
.NET: Is there better way to view svn's non-versioned files

Most of the time I find it hard to detect If im missing some files not added on our source control, for instance in "usp" folder that contains hundreds of stored procedures, I would only know I missed something when I tried to load the project next time. Locating nonversioned files in the mid of hundres... Read More...

4 comment(s)

Filed under: .NET, Development Process

14 September 2006
SQL SERVER: Inflectional FullText search filters "in", "the", "of", "and" articles

I was surprised tonight as I was testing the search engine of my project. It uses SQL Server Inflectional FullText search, but also supports boolean and simple search. Its good to see that it filter out these "and", "in" "of", "the", and other articles and returns 0 results when used as the only keyword... Read More...

2 comment(s)

Filed under: .NET, sql server

13 September 2006
.NET: Make code works without UI, my first unit test

My TDD adventure keeps on surprising me dayafterday, I started to lessen the use VS studio debugger and I felt an increased productivity by not having a full build just for testing a single feature in code. With TestDriven.NET plugin installed it was pretty cool. I create a test for a feature, run the... Read More...

4 comment(s)

Filed under: .NET, Development Process, tdd, unit testing

13 September 2006
.NET: SqlParameter default length

An SqlParameter with ParameterDirection.Output has default size of 1 , this can be tricky if you use command.Parameters.AddWithValue(parameter, value) method in .NET 2.0. It was caught on my unit test when I want to retrieve the value of an output parameter, the returnErrorMessage variable must contain... Read More...

2 comment(s)

Filed under: .NET, sql server , ASP.NET

08 September 2006
.NET: <untitled>Test

I've been struggling on these past few days doing some unit testing and tdd. hell yeah im starting to love it and now am still waiting for a new project so i can give it a real taste, bitter eh ;). But first i did a search and Jeremy Miller has always been very helpful to me. Not just on testing but... Read More...

3 comment(s)

Filed under: .NET, patch management , Development Process, tdd, unit testing

06 September 2006
SQL Server: Bit is not boolean

Often we used BIT datatype for representing boolean values, but BIT is not the same as boolean as BIT represents values (1, 0 and NULL). Boolean represents values (True and False). Read More...

6 comment(s)

Filed under: sql server