A few years ago, I gave a session on Oracle’s Data Vault. An attendee from that session and I happened to be seated at the same table for lunch last Thursday when I presented at Utah Oracle User Group Fall Symposium. He asked if I’d ever found a way to encrypt a column from the prying eyes of the
SYS user. I said yes, and he asked how. It was a bit more than could be explained at lunch and promised to put it on the blog.
Heading out to speak on Comparative SQL between Oracle and MySQL at the Utah Oracle User’s Group Fall Symposium. I’ll look forward to meeting old and new friends. Also, I’ve got a couple promotional copies of my Oracle Database 11g and MySQL 5.6 Developer Handbook to give out at the end of the session.
While staging to rebuild the Oracle DB Console (Oracle Enterprise Manager – OEM), I needed to check something in my MySQL instance and ran into the following error after changing the machine’s
hostname for that OEM test. The message basically says that MySQL Workbench can’t resolve the connection.
The dialog error provides an excellent note, which lists the actual error as the first thing to check. The dialog follows:
Somebody asked how to solve a problem with the
=AVERAGEIFS function and non-contiguous ranges. The solution requires a combination that uses a group of
=SUMIFS function divided by an equivalent group of
Somebody posed a question about starting and stopping the database from within the OEM tool as the
SYSTEM rather than the
SYS user. There’s actually a simple trick to do that, you connect to OEM as the
SYSTEM user but when you startup or shutdown the database, you reconnect for those tasks as the