Author Archives

Missing Windows in Oracle SQL Developer Data Modeler

LewisC’s An Expert’s Guide to Oracle Technology
Well, I have been using Oracle’s new SQL Developer Data Modeler (OSDM) for a couple of months now. I’ve upgraded to beta 2. I have to say I really like it. I have given some feed back and the response …

SQL DML Ebook Available, Free Online

LewisC’s An Expert’s Guide to Oracle Technology
Ok, I figured out how I am going to do this. I am making my book available three ways: print, ebook and html.
For print, you can get it on amazon or through my e-store. It’s $14.95
For ebook, you can g…

Foreign Keys in a Data Mart

LewisC’s An Expert’s Guide to Oracle Technology
I am soliciting opinions here. First, though, some back story.
Way back when, when I was first moving on the track to data modeler and architect, I was responsible for designing schemas and application…

Cloud Computing Defined

LewisC’s An Expert’s Guide to Oracle Technology
I’ve finally done it. Everyone seems to be having difficulties defining just exactly what cloud computing really is. I have it down to a single sentence:
Cloud computing is using the internet to access…

Learn SQL - The Guide to DML

LewisC’s An Expert’s Guide to Oracle Technology
My SQL book is now available for print. You can see it on my CreateSpace e-store. The book is SQL DML - SQL Starter Series Book 1. This is a book for beginners. It takes someone step by step through TC…

Oracle Book Survey From Packt - Get 40% Off EBooks

Packt is a publishing company. I will be reviewing one of their books here in the near future. They are doing a survey and anyone who responds can get 40% off any ebook in their inventory. I just wanted to pass this along. The survey is only 9 quest…

First Ebook Coming Soon

Well, I pretty much have the first book written. It is a SQL newbies guide called SQL Starter - DML. In it, I give the details about DML. I plan to follow on with two more in the starter series, Intro to Relational Databases and SQL Starter - DDL.
I…

AVG and ZoneAlarm Are Giving it Away!

LewisC’s An Expert’s Guide to Oracle Technology
AVG
Last week, AVG suggested to some users that user32.dll was a trojan and offered to delete the file for them. Know what happens when you delete a key dll like that? Kerblooey, that’s what.
AVG has s…

Favorite Interface to Amazon AWS?

LewisC’s An Expert’s Guide to Oracle Technology
I am familiar with several different interfaces to AWS. The three I am most familiar with and have used are Elastic fox, Cloud Studio and amazon’s command line interface. I’ve also heard of a paid GUI …

Top 10 Tips For a DBA

LewisC’s An Expert’s Guide To Oracle Technology
So you want to be a DBA? A DBA’s day is busy and difficult. Like a wizard’s, only you don’t get to hang around with dragons and elves. For those of you thinking about becoming a DBA, here is a list of …