Monthly Archives: February 2012

Mongodb and datalogging

Download the binary  from http://www.mongodb.org, for example http://downloads.mongodb.org/win32/mongodb-win32-i386-2.0.2.zip.  Open the zip file, copy the inside directory to C:\ and rename the directory as mongodb2.  Create a data directory default is “C:\data\db”.  Put a copy of the command prompt in c:\mongodb2 and … Continue reading

Posted in Uncategorized

First amongst many

If your SQL query returns a list, but each item in the list is represented several times because of another item in the query AND YOU WANT the second item, you could try to return just the FIRST of the … Continue reading

Posted in Uncategorized

Here a schema, there a schema, everywhere a bad schema

This sql query will create a temporary table that will contain the whatever (gradebook_translation_pk1) for any schema that does not mean Academic Affairs standards. It seemed necessary to put the upper and lower bounds on separate lines. We join the … Continue reading

Posted in blackboard, sql

outta space – again

We ran out of space on ANOTHER server again.  I wrote a script to remove entries in the tomcat\temp directory, but that was just for ‘my’ snapshot server, and hadn’t had time to extend that to the others.  So we … Continue reading

Posted in blackboard, powershell, Uncategorized

textboxapp

Dropbox is pretty handy for documents, projects – and you can use it for notes.  There are a number of applications that will accumulate notes, as in a log.  You can even do it with Twitter, but something i am … Continue reading

Posted in Uncategorized

golly, it just … popped up

It is easy to add a messagebox to powershell.  You can use ShowUI, but you can also simply create a com-object and make a Popup. $a = new-object -comobject wscript.shell $b = $a.popup(“This is a test”,10,”Test Message Box”,0) This will … Continue reading

Posted in Uncategorized

powershell modules

Write a powershell script.  Change the name to name.psm1.  Save it in a folder called “name” (per Jaykul, a module is BOTH a file and a directory.)  And the directory is…? You can provide the full path to the directory … Continue reading

Posted in Uncategorized