Bad SQL Redesigned
The Assignment Last week we looked at various techniques for combining tables. As an example, we took an assignment “to gather the hours reported on timecards for each employee over a two week pay period.” We saw...
Read MoreMonth: June 2009
6 Lessons Learned From Bad SQL
Posted by Steven Alexander | Jun 21, 2009 | Algorithms, SQL |
Here are some interesting variations of SQL syntax. The simple example I chose is probably ill suited for any actual program, but that makes it more interesting. The Assignment We want to gather the hours reported on timecards...
Read MoreAnalyze Peoplesoft Process Instances With SQR
Posted by Steven Alexander | Jun 14, 2009 | Algorithms, Peoplesoft Specific |
We built and enhanced a real-time dashboard that alerted us to problems with Peoplesoft process instances. The next challenge is to investigate processes that fail, or processes that succeeded yet dissatisfied our co-workers...
Read MoreReal-Time SQR Process Monitor Dashboard 2
Posted by Steven Alexander | Jun 7, 2009 | Algorithms, Peoplesoft Specific |
Last week we wrote a real-time application in SQR. Yes, in SQR, the batch programming language. That should have been more thrilling than it turned out to be. Let’s try to make it more interesting, accessible, and informative....
Read More
Recent Comments