tag:blogger.com,1999:blog-27535574057317212442024-12-19T16:23:09.008+13:00Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-2753557405731721244.post-87236475908260335132013-05-13T11:17:00.002+12:002013-05-13T11:17:21.205+12:00

Traditionally when we’ve dealt with hierarchical data in SQL we’ve need to jump through a few hoops to query it. Usually we’d set up a our data table with a parent Id reference, and to query it we would use a temp table and populate it in a recursive loop. This isn’t very efficient. The new HierarchyId data type introduced in SQL 2008 simplifies querying this data hugely. Let’s start with a

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com1tag:blogger.com,1999:blog-2753557405731721244.post-46870260376071184602012-08-20T11:23:00.003+12:002012-08-20T11:23:19.934+12:00

At the end of last year I did a bit of work with the Kinect SDK.  I built a Kinect plugin to control Microsoft Power Point presentations.  I wrote up my notes at the time, but I've just realised that I never posted a blog about it. Although this was written months ago, and I know that the Kinect SDK has been updated since then, most of this information is still relevant

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com1tag:blogger.com,1999:blog-2753557405731721244.post-79576509797598161112012-05-23T14:56:00.002+12:002012-05-23T14:57:59.232+12:00

I've just learnt the hard way that when you change a field value on a MS CRM 2011 form via JavaScript it doesn't automatically trigger any onChange event which is wired up to that field. To manually trigger any onChange event you do the following Xrm.Page.getAttribute('myfieldname').fireOnChange(); or better yet, if you use a custom library to simplify your read SetAttributeValue =&

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com0tag:blogger.com,1999:blog-2753557405731721244.post-90135290646375610362011-10-25T17:34:00.003+13:002011-10-25T17:41:45.029+13:00

Here we’ll look at how to calculate a map coordinate from a screen coordinate in an isometric game. First we’ll need to look at some definitions and assumptions about our isometric system. Coordinate Systems Tile Array Map We are calculating coordinates in two coordinate systems.  The first is the Map coordinate system.  Imagine this as a square map drawn on paper.  This is

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com0tag:blogger.com,1999:blog-2753557405731721244.post-7189767288877468002011-09-09T11:13:00.000+12:002012-05-23T14:58:18.209+12:00

MS CRM stores date values internally in UTC date format, so when I was programmatically creating appointments earlier this week I was getting weird date issues. The solution is really simple I figured out the following method for setting the dates in the entities. Basically you grab the difference between the current local DateTime, and the current UTC DateTime like this: Code Snippet

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com0tag:blogger.com,1999:blog-2753557405731721244.post-73167972746631581112011-08-11T15:35:00.000+12:002011-08-11T15:35:25.824+12:00

I hate having the clutter of extra background apps sitting in my taskbar in Windows 7, and MSN Messenger is a good example of this.  A messenger app should sit out of the way in the notification tray when it's not in use. I found out that you can do this if you set the compatibility mode for the Messenger app to Vista, it will not take up space in your taskbar unless you're actually using

Buzzrickhttp://www.blogger.com/profile/13197035266403196557noreply@blogger.com0