You click Save, the server records your changes, but the response never reaches your browser. The screen can’t confirm the save. Clicking Save again seems reasonable, but that’s awkward if it creates a second copy of what you just saved. In reliability work I did for an existing community application, recovery had to account for […]
The ongoing conversation
Category: Database
Making Data Look Right Without Changing What It Says
In an orienteering mapping project, I wanted to review a GPS track and geotagged photographs against an existing map. No surprise: they didn’t line up neatly. I could move the track, but would the new position mean I had corrected a location, or just changed where I drew it? The mismatch alone couldn’t answer that. […]
Transforming mostly static data to date ranges
I recently had to transform a set of data from typical date & measurement to a more compact date range & measurement format. The data in this case was very static: as the date incremented, the measurement was much more likely to be remain the same than it was to change. So storing the starting […]
Decoding SQL’s Decode
I came across a SQL function I was not familiar with: decode. I looked it up and immediately replaced it with a CASE statement (in addition to other code cleanup). I’m afraid I don’t understand the existence of Oracle SQL’s decode() function: decode(expression, search, result [, search , result]… [, default] ) seems functionally equivalent […]
Spikes, Slopes, and SQL
So you have data you’re tracking every day. Maybe a lot of data. Maybe tracking it a lot of ways. You might even have graphs of the data over time, so that you can spot trends and anomalies. And then you find that you’ve got too many graphs… It’s time to let the data tell […]
SSRS Drillthrough Reports for Mobi Reports Pro
The short answer: use Globals!ReportFolder in the middle drillthrough reports to fully qualify the target ReportName in any Action. The tech involved in this problem, although probably you know this if you reached this page: SSRS is a database reporting solution for Microsoft SQL Server—you can turn data into graphs! Mobi Reports Pro is an iOS […]