May 232013
 

I was completely unaware of the SQL Server “ghost records” until recently I’ve started using a table in SQL Server database to temporarily store and then delete generated PDF documents as part of a nightly job. Because of a large amount of data being processed (inserted and then deleted) few days later our DBA realized that the database data files started growing in a rhythm [... read more]

May 072013
 

After quite a long time there is a small update on the Google DataTable .NET Wrapper library. For those who are new to the library please check the two previous posts: How to use the Google DataTable .Net Wrapper Library What’s new in Google DataTable .NET Wrapper v3.0.0 What is new? First of all I would like to thank Tom Ziesmer who has substantially contributed [... read more]

Mar 152013
 

Software Development is so many things; to have a good start creativity, passion and methodology have to be a perfect match. While the creativity and the passion are subjective and personal, the methodology is something that can be learnt, developed, enhanced and shared. Like mathematics, it can be seen as an universal language. Principles When developing software there are some best-practices and principles that should [... read more]

Mar 102013
 

In one of my earlier posts I tried to describe what kind of attributes a leader should have to be successful, and in this post I would like to go a big further and try to define what should make an IT project a success. Wikipedia says that In project management a project consists of a temporary endeavor undertaken to create a unique product, service [... read more]

Mar 062013
 

Only few years ago I was not such a big fan of Object-Relational mapping tools (ORM), but now I have to admit that when starting a new project I’m always thinking whether it makes sense to use it or not. Compared to “traditional” coding techniques, Object-Relational mapping often reduces the amount of code that needs to be written, but I would add as well that [... read more]

Feb 232013
 

Recently I have participated to a couple of discussions about whether the triggers or stored procedures should be used or not in a “real” project, so I decided to write this post to express my point of view. This said, I warn you, there is no a “right” answer, but most probably a “pro” and “cons” about anything written in this post. An old problem [... read more]

Feb 172013
 

When choosing Juniper certification exams based on career advancement goals, there are a couple of things you need to keep in mind. The first is that Juniper exams are sequential in nature. In other words, you must work your way through exams from the associate level up in order to build your expertise and meet prerequisite requirements for more advanced testing options through the organization. [... read more]

Feb 082013
 

I am migrating some old posts to this blog, so I though it would be good to migrate this one too. This post has been originally written in February 2010, but still actual and valid. Today I run into a problem of finding out when was the last time a specific Stored Procedure (SP) has been changed. Obviously, there are different ways to find out, [... read more]

Feb 022013
 

If you, like me, are using Subversion as your primary Version System and want to embed the SVN revision number directly in the assembly, but don’t know how, this post will try to explain it. What do you need? Before proceeding any further, you would need to download the following two packages (free!) MSBuild Community Tasks Subversion 1.7.8 (Windows 64/32-bit) I assume that you are [... read more]

Jan 262013
 

Since 2001 Syncfusion provides the broadest range of enterprise-class software components and tools for the Microsoft .NET platform, so it’s not a surprise that as a Software Consultant several times in my working career I had to deal with their libraries and components which usually were reliable, good quality and easy to use. That said, this blog post is not about their components, as there [... read more]

Jan 172013
 

When exposing a WCF service and hosting it on IIS6, most probably you are going to get the error shown in the image below, where the address of the WSDL location is not properly exposed to the end clients. This post is specifically concentrating to the solution of the problem in case the HTTPS protocol is used, as it has it’s own specific problems. As [... read more]

Jan 102013
 

Recently I started working on my side-hobby-project on the linktotweet.com web site, and one of the functionality I want to offer to site members is the possibility to track the statistics, and more precisely the location of their visitors. In other words, I need to translate the IP address to an actual location. While this is almost a trivial task for whoever is using the [... read more]

joehnckfred@mailxu.com eschmann@mailxu.com