URI in a Database

This vendor’s application has been a headache for me for over a year now. We are getting close to upgrading, but there are some issues. One is why data in the new version is missing. I finally got the vendor to give me a¬†query in the new version which was enough for me to figure… Continue reading URI in a Database

SQL Server Alias Naming Breaks Convert Function

The vendor installs the application which includes creating the database and schema (SQL Server 2008 R2). The schema defined a certain column as varchar(128) that the application code expects to return an integer. If one of the entries for a client is a non-integer value, then HTTP 500 Internal Server Error failures prevent users from… Continue reading SQL Server Alias Naming Breaks Convert Function

Oracle 11g

The highest revision of Oracle database supported by Blackboard for CE/Vista is 10g. Wondering if other Bb clients have noticed Oracle 10g leaves Premier Support on July 31, 2010. The first year of Extended SUpport fees are waived, so July 31, 2011 we’ll have to start paying extra money to Oracle unless Blackboard starts supporting… Continue reading Oracle 11g

We Need a 4th Vista DBA / Technical Support

Work for OIIT! Become our 4th DBA / technical support person for our team. Located in Athens, GA (college town, UGA football) $, benefits, generous leave, rare snow we love open source PDF of GeorgiaVIEW DBA position Check out the PDF (right) for more information. Sorry for the convoluted route to the application… Click this… Continue reading We Need a 4th Vista DBA / Technical Support

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… Continue reading Finding Sessions

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… Continue reading User Interface v. SQL Reports and Tracking

Fun With Oracle Environment Variables

This is more or less for the next time I lose all my brain cells from not working over the weekend…. Critical Oracle variables: ORACLE_HOME ORACLE_SID Pretty much any script that deals with Oracle needs the value of these. Cron doesn’t have these variables, so use export VARIABLE to provide them to the shell. Also,… Continue reading Fun With Oracle Environment Variables