NOEXPAND and WITH SCHEMABINDING

Note to self. If I see another error involving NOEXPAND check these

1) Make sure server is running SQL 2005
2) Make sure the view has WITH SCHEMABINDING in the DDL (i.e. I need to check my upgrade scripts, … in reverse order)

Bookmark and Share

SQLite and Excel as DataSmithing Tools

Tom Gleeson aka Goban Saor has an interesting perspective on how well SQLite acts as a general table store which can then be used in OLAP and Excel. He describes the SQLite as the “MP3 for databases”, and I think he comes pretty close to the mark on this.
What’s there to stop anyone from [...]

Configuring SPA-2000 for MyNetFone

Here’s the configuration page if my memory fails me in the future
https://www.mynetfone.com.au/media/support/downloads/sipura-spa2000/config/config.html

var addthis_language = ‘en’;

Almost Perfect

I came across Almost Perfect via Hacker News, a candid first-hand account of the rise and fall of WordPerfect.
It is so interesting to see how WordPerfect was blind its impending death. I am not singling out WordPerfect here, rather as a theme how corporations are all blind to their eventual death. The singular theme [...]

JavaFX experiment

I was having a lot of problems getting the simplest test case below to run without throwing an odd exception:

import javafx.stage.Stage;
import javafx.scene.Scene;
import javafx.scene.layout.*;
import javafx.ext.swing.SwingTextField;
import javafx.ext.swing.SwingButton;

Stage {
title : "MyApp"
scene: Scene {
width: 200
height: [...]

JavaFX Custom Cursors

Setting custom cursors with JavaFx is relatively straightforward, but for one little catch. Your image has to be 32×32. If you want a 16×16 icon, simply leave the rest of the image transparent.

import java.awt.Toolkit;
import javafx.scene.Cursor;
import javafx.scene.image.Image;

public class ColorChooser extends Cursor
{
public override function impl_getAWTCursor(): java.awt.Cursor {

[...]

JavaFX Introspection

Just sharing some code snippets for deserialization of JavaFX objects.

function getValueType(obj:Object,name:String):String
{
var context:FXLocal.Context=FXLocal.getContext();
var objectValue:FXLocal.ObjectValue = new FXLocal.ObjectValue(obj,context);
var cls:FXClassType = objectValue.getClassType();
var varType:FXType = cls.getVariable(name).getType();
println("{name} {varType}");
if (varType instanceof FXSequenceType)
{
[...]

Ego-Trip Programming

It’s Saturday morning and I’m bored.
I might go create something whose sole purpose is to praise me.

while 1:
print "I praise Chui, who created me for the purpose of praising him."

var addthis_language = ‘en’;

JavaFX binding in sequences

I had a Group of circles, i.e.
var circles:Circle[];
var group:Group = Group { content: [circles] };
strangely, I couldn’t get newly inserted circles to render.
It turns out that you have to bind group.content to ensure that changes in circles are reflected in group.content.
Here’s a test routine.

import javafx.scene.*;
import javafx.scene.paint.*;
import javafx.scene.shape.*;
import javafx.stage.*;

var lines = for (i in [1..10])
[...]

SQL Server ARITHABORT

Just a reminder to myself. The next time I see an ARITHABORT error, try these
1) SET ARITHABORT OFF
2) Change SQL Server compatibility from SQL 2000 to SQL 2005

Tags: mssql

var addthis_language = ‘en’;

Applet for Submitting Screenshot

Submitting screenshots through the web takes several steps more than it ought to. Firstly we have to paste it into mspaint.exe, save it to disk, only to then fiddle around with the File upload to look for the file again.
Another way to do it is via a signed applet. Unfortunately, the signed applet is unable [...]

A list of people doing interesting work on the JVM

Andrew Haley Zero, Shark – llvm code generators
Gary Benson RedHat. Zero and Shark
Volker Simonis – SAP JIT group, how to build HotSpot
Pekka Jato – JIT compiler for Java
Jevgeni Kabanov Class reloading using serialization to patch runtime instances
I’m sorry if I missed your name here. Please leave a comment here if you wish to be [...]

EvServer – a scalable Etherpad clone

Something to read later.
I first heard of Etherpad on IT Conversations. Etherpad enables users to edit the same text area, using serialized javascript functions to transmit diffs.
Marek implemented a scalable etherpad clone using Erlang and RabbitMQ. All in six afternoons.

var addthis_language = ‘en’;

Sales Copy

A long sales copy that doesn’t read like one – Harry Wong

var addthis_language = ‘en’;

4GL Patterns #13 – Read Only Fields

Some data dictionary mark certain fields as being read-only. Why should fields ever be read-only? How do they get edited in the first place?
Possible justifications:

The field represents a permanent record, i.e. it behaves more like a document than a database field. A field can be set at record creation time and no-other.
The field represents an [...]

Database Patterns realized with AribaWeb

Take a look at aribaweb.org (viaTheServerSide).
AribaWeb is a 4GL RAD for web applications running on a Java stack.
It uses an approach described in data dictionaries as a database pattern to generate metadata-driven UI.
The Ariba toolset seems reasonably mature from the screencasts, although one has to be wary because a lot of the AJAX work [...]

JavaFX redux

Having spent a few weeks experimenting with JavaFX, and creating several examples, here is an assessment of whether JavaFX succeeds in it’s objective of being a graphics DSL. Bear in mind that I am evaluating it in terms of it’s ease in being a graphics DSL – if it makes my life easier, it succeeds. [...]

Visualizing Sub Prime Losses with JavaFX

Click on image above to launch via WebStart
Drawing rectangles is pretty straightforward in JavaFX. I decided to add a little bit of animation so that the pieces of the puzzle “fall” into place. This is done by applying ParallelTransition which combines ScaleTransition, RotateTransition and TranslateTransition.

var addthis_language = ‘en’;

Taxi Driver MBA

More here:
“A taxi driver must also have scientific methods,” he said. I was surprised and I got curious: “What scientific methods?”

var addthis_language = ‘en’;

Launching JavaFX script via a jar file

Steps:
1. Use javafxpackager to create the .jar file (it will be created in the dist directory). Make sure the dist directory is empty, or you’ll find your jar file growing bigger each time.

javafxpackager -appClass fisheye -src .

2. Launch the jar file, and don’t forget to include the path to the JavaFX libraries

java [...]