Saturday, November 17, 2012

The Principles of Open Space Conference

Today I attended a technical open space conference and I really liked the concept.

In brief these are the principles of open space conference:

1. Whoever shows up are the right people.
2. Whenever it starts, it starts.
3. Whenever it's over, it's over.
4. Wherever it happens is the right place.
5. Whatever happens is the only thing that could


Tuesday, February 21, 2012

Visual Studio Database (VSDB) Project issue with UDF and Views

In Visual Studio 2010, there seems to be a dependency problem with User Defined Functions (UDF) and Views. The deployment script created by the VSDB project always puts UDF before database Views. Consider this scenario, we have a database function which depends on a database view and we have altered both the function and the view. Now, when a deployment script is created for this database project, the altered function is always placed before the alter view statement. Running this script will fail at alter function statement because the dependent view was not altered yet. I could not find any settings in VSDB project to change the sequence order for the build, meaning build my database View first and then the UDF. The only workaround I found was to alter my database View in the pre-deployment script.