Rants, Raves, and Rhetoric v4

Tag: sql

  • Content Migration Progress Tracking

    When moving hundreds of thousands of courses between WebCT Vista and Desire2Learn, keeping track of what made it through which stage seems like an obvious hindsight thing to do. I added that last bit because we started to notice where things fell between the cracks starting to pile up. The basic process… Through Oracle SQL…

  • Tracking Specific File Use

    CE/Vista Reports and Tracking displays summaries of activity. If an instructor seeks to know who clicked on a specific file, then Reports and Tracking falls down on the job. Course Instructor can produce a report of the raw tracking data. However, access to the role falls under the Administration tab so people running the system…

  • Open Schema

    If Blackboard opens up the schema for Vista 8, then maybe I’ll feel more comfortable sharing the reporting SQL I use. Ron Santos has a good PowerPoint on SQL for reports at Simon Frasier University.

  • Smart Boys

    George and I talked about this some last night. Nature vs Nurture… I tend to think of both as bottlenecks for human development. The debate about which does more to me makes as much sense as debating which is better for a web application: Apache or MySQL? Both are involved and affect the end results.…

  • Truncate Table

    Earlier in the week I picked on a DBA at UGA for wanting to use truncate learning_context. Overheard at the office a developer used truncate and caused those DBAs to recover the data. Ugh.

  • Finding Sessions

    Clusters can making finding where a user was working a clusterf***. Users end up on a node, but they don’t know which node. Heck, we are ahead of the curve to get user name, date, and time. Usually checking all the nodes in the past few days can net you the sessions. Capturing the session…

  • User Interface v. SQL Reports and Tracking

    Blackboard Vista tracks student activity. This tracking data is viewed as a critical feature of Vista. Our instructors depended on the information until we revoked their ability to run reports themselves due to performance issues. Campus administrators can still generate reports (though some still fail). We doubt the solution to this is Blackboard improving the…

  • Dumbfounded By The Numbers

    Chancellor Eroll B. Davis Jr told the Georgia Board of Regents, “We grew essentially by a large university.” The USG gained 10,077 students (my alma mater has ~11,000) in a year. They calculate these fall term to fall term. In the same fall term to fall term time period, in the same same university system,…

  • links for 2007-09-28

    The Power of Inline Views (tags: oracle sql)