tag:blogger.com,1999:blog-27535574057317212442024-03-09T06:22:03.286+13:00Buzzricks BlogBuzzrickhttp://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:00Handling Hierarchies with the SQL HierarchyId datatypeTraditionally 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:00Kinect SDK Development
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 relevantBuzzrickhttp://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:00Changing CRM form properties in Javascript doesn't trigger onChangeI'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:00Isometric Coordinate Calculation TutorialHere 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:00Creating Entities with dates in MS CRM 2011MS 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:00Getting MSN Messenger out of the Taskbar in Windows 7I 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