Determining Oracle Materialized View usage
We have some materialized views but are not sure they’re being used after index and schema changes were made to improve performance. Enable auditing: AUDIT...
Recent Posts
Creating a new developer box
I was issued a new laptop, HP 840 G1, so needed to set up a proper development environment. The first time I set it up I manually downloaded and installed m...
Funny Oracle error message
Oracle has an “Early Adopter” version of SQL Developer, a tool I have “become accustomed to” at a prior job where they couldn’t/wouldn’t pay for developers t...
Quick graphic model of a DB
Found a quick way to generate a DB entity model diagram with Oracle’s SQL Developer. Here is a description of how to do it, but in short: Open up the Data ...
Two Hard Things…
There are only two hard things in Computer Science: cache invalidation and naming things. -- Phil Karlton Long a favorite saying of mine, one for which I ...
Learning experience with git push
TL;DR, #1: merges in all branches in a directory/local repo will be pushed regardless of the current branch when push is done, #2 use a new clone “every” tim...
Connecting to MS SQL Server with NTLM on Linux
A MS SQL Server instance can be configured to use NTLM authentication for connections so that it goes against Active Directory for authentication and authori...
The most unusual place you’ve written code
This piece asks about the most unusual place you’ve written code. My most unusual place was in PowerPoint at FL280 and in a Lincoln. I had an interview ass...
Injecting code via xsd into a jaxb object
Found a cool feature of jaxb/xjc, -Xinject-code. With example xsd from prior post, look for ‘ci’. The code should probably be wrapped in a CDATA element. [s...
Making a JAXB object extend a “real” class
Finally got the magic incantations correct to have a generated jaxb extend an existing class. http://confluence.highsource.org/display/J2B/Inheritance+plugi...