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 […]

Read article: Decoding SQL’s Decode

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 […]

Read article: Spikes, Slopes, and SQL