my commentary on things
Development
A little SQL makes the world a better place
Apr 25th
A couple of weeks ago a colleague of mine raised a problem they encountered transforming some data to a required output format. The problem was to take a table of traveller itinerary information and produce a summary of the cities they included as a comma separated list. Although I couldn’t think of the solution right away the problem reminded me of similar things I had come across in the past. This problem has now been rattling around in my head for long enough so this afternoon with a little ANZAC Day spirit I sat down to conquer it.
The More >
SQL reports tells us where to go, part 2
Feb 11th
In part 1 of this 2 part blog I introduced the SQL 2008 R2 Map report control, and ran through a quick example of one of the Map types. In this post we will take a look at another of the Map types, the Bubble marker map which is used to display point data.
To illustrate this map type I will need some point data, so I decided to record the locations of some of the traffic lights (signals) I spend time waiting at on my way to work. I recorded the time spent at the lights and my level of frustration More >
SQL reports tells us where to go, part 1
Feb 8th
Last Sunday I delivered a brief talk at the Readify barcamp on the new Map control in the SQL 2008 reports toolkit. I thought it would be a good opening topic for my new blog here on my unused Second Square domain.
So what is this Map thingy anyway?
The November CTP on SQL Server 2008 R2 introduced several new features to the SQL core and support features. One of these features was the version 3.0 of the Report Builder tool, which is a standalone report creation tool for SQL Reporting Services that you can get here. Along with the new Report Builder came More >