Author: Robert Hamel

Considerations for Converting from Oracle to Other RDBMS Platforms

Oracle software is known for being complex, expensive, and even cumbersome. However, while legacy database management systems (DBMS) like Oracle often hang around well past their best before date – in many cases due to corporate inertia and well-worn habit…

Read More >

Oracle Cloud Infrastructure: Should you consider it for your Oracle database workloads?

Oracle users have had the ability to run database workloads in the cloud for years, but options have always been limited to third-party providers like Amazon Web Services (AWS) – at least, until recently. That’s because Oracle has a second-generation…

Read More >

Weighing the pros and cons of Oracle Autonomous Database

The next generation of managed database services is upon us, offering organizations of all sizes the ability to scale database workloads quickly without forking out huge investments in either hardware or specialized expertise. One of these services is Oracle Autonomous…

Read More >

Low hanging fruit items that alleviate DataOps operational pressures

Data is hard. It has been always hard and it’s not getting easier.  We always have more of it, there are more sources to integrate, it changes all of the time, the quality is questionable and the business wants all…

Read More >

Increase your data visualization/reporting velocity and performance with proper semantic layers

We have all seen it before.  You finally get access to new data sources and want to extract insight from that data. You open your favorite reporting or data visualization tool, connect and start updating the tool’s semantic layer. The…

Read More >

MySQL Conference 2010 – Last day

The morning’s keynotes again were quite good especially the one from Ubunto. I attend another packed Facebook session and one from Ronald Bradford. It was the first time I head him speak and he is very good. I didn’t attend many of the afternoon events because of customer commitments but the remain group at the hotel had a passionate discussion on Oracle role in the MySQL community so its far from over and Oracle has one year to fix it. See you all next year

Read More >

MySQL 2010 Conference – Day 2

We started with the morning keynotes again today and I was a little surprised at the snipping going on. The first session that I attended today were around MySQL partitioning in the beta releases and beyond. The next set of sessions were on IO bottlenecks, MySQL data warehousing and finally Danil’s Security session. Finally there was the Ignite session that just finished a few minutes ago which was quite entertaining with lots of nice rapid fire topics. That’s all for today…Last day tomorrow

Read More >

MySQL Conference 2010 – Day 1

Well the first day has come and gone and I really enjoyed my first day as a newbie. The keynote from Oracle was well received, they touched on the new Beta version of MySQL and the new mysql enterprise which to a trained oracle eye is looking more and more like Grid Control. The end result is providing more instrumentation to help the DBA but I am a little disappointed that a lot of that instrumentation is not actually in the database itself which forces you to buy the product.

Read More >

Book Review of Guy Harrison’s Oracle Performance Survival Guide

This is the first time I have read one of Guy’s books and I was very impressed at the breadth of topics that are addressed and especially the approach that is followed starting from the application design rather than trying to find the elusive fast=true setting that resolves every problem.

Read More >

Simple MySQL Auditing

Simple auditing can save you tons of time while troubleshooting. I came up with some simple stored procedure that will compare two data sets and keep track of the changes historically. It’s loosely based on slowly-changing dimension type 2 in the data warehouse world. This method tracks only changes, so you should be able to keep historical rows forever, unless you are constantly dropping and creating whatever you are tracking.

Read More >
Page 1 of 212