Tips en tricks met de Visual Studio Debugger 10 January 2010 Peter-Himschoot Een tijdje geleden heb ik een webcast opgenomen met Microsoft rond beter debuggen met Visual Studio 2008. Abstract: “De Visual Studio debugger is een tool die door ontwikkelaars nog te weinig wordt gebruikt. In deze sessie tonen we hoe u hem als professional kunt gebruiken en leren we nieuwe techni... [More]
Project Management: Planning a project with Team System 2010 08 January 2010 Peter-Himschoot .NET Development, VS2010, Team System Project management has changed. Changed towards SCRUM based project management where you start by building a list of User Stories, also known as the backlog... This list of user stories allows you to plan the project by selecting the highest priority user stories, adding them to an iteration, planni... [More]
The Missing Linq to SQL Spatial 03 January 2010 Diederik-Krols SQL Server, Spatial This article provides hints and hacks on how to use the SQL Server spatial data types -Geography and Geometry- in Linq to SQL. The data provider has a problem with serializing and deserializing the SQL UDT's. If you ever tried to use these data types in a Linq to SQL (or Entity Framew... [More]
Converting Spatial Coordinates with Proj.NET 01 January 2010 Diederik-Krols In my previous article I expressed some disappointment in the usefulness of the Map Projections in SQL Spatial Tools on CodePlex. There's not much you can do with these in a real-life application. Fortunately there's also Proj.NET on CodePlex, a flexible advanced point-to-point coordinate conversion... [More]
God mode for windows 7 01 January 2010 Peter-Himschoot I love windows 7, but now I love it even more. Remember these game cheats, called god mode? There is one in windows 7 as well. Thanks to http://windows7themes.net/windows-7-enable-secret-godmode.html Simple create a folder called GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} Now you can a... [More]
Tuning SQL Server Lookups to a Linked Server 31 December 2009 Diederik-Krols SQL Server In SQL Server, if you join a local table with a table on a linked server (e.g. a remote Oracle instance) you should be prepared for horrible performance. In a lot of scenarios it makes a lot more sense to tell the remote server exactly what you need, store that data in a temporary table, and join lo... [More]
Happy new 2010! 27 December 2009 Peter-Himschoot Good health, lots of fun @ work, great time @ leisure. What else?
Displaying spatial data in WPF: from SqlGeometry to PathGeometry 26 December 2009 Diederik-Krols WPF, SQL Server This article explains how to visualize spatial data (e.g. from SQL Server 2008) in Windows Presentation Foundation without using 3rd party components or proprietary formats. We'll build a little form that allows us to enter test data in the Well-Known Text format (WKT) - manually or via copy/paste, ... [More]
SQL Spatial Tools: Map Projections 25 December 2009 Diederik-Krols SQL Server, WPF SQL Server Spatial Tools on CodePlex contains useful extra functions for the SqlGeometry and SqlGeography data types, as well as a new data type for affine transformations (to scale, translate, and rotate) and a handful of Map Projections. This article describes how to use these projections and visu... [More]