Tag: DBA Lounge

Become a Published Author

In this post I provide some tips and advice on how to become a published auther for Oracle, MS SQL Server, and MySQL

Read More >

About MySQL 5.6

I am very excited and thrilled to use the latest release of MySQL 5.6 in production. This is probably the most notable and innovative release from many years, if not ever. I this post I take a detailed look at what is new in MySQL 5.6 and why I think its the best version of MySQL to date

Read More >

DBD::Oracle 1.57_00 Is On Its Way to CPAN

DBD::Oracle version 1.57_00 is on its way to CPAN. This release is small, but should make some Win32 users happy:

Read More >

How to Troubleshoot OEM 12c Cloud Control Auto-Discovery

OEM 12c Cloud Control looks daily for new targets, placing them in a queue for admin promotion to managed objects. Details and troubleshooting info follow.

Read More >

How to Reduce Errors When Managing a Database

Want to reduce the possibility of making errors when managing a database? Hear Pythian founder Paul Vallee give an over view of Pythian’s FIT-ACER check list and see how it helped Pythian reduce errors rate from 1/year of services delivered to 1/ 6.3 years of services delivered.

Read More >

Pushing Your Code TODOs to GitHub Issues

Wouldn’t it be cool to be able to scan your code for all TODOs and FIXMEs and generate GitHub issues out of them? Well, I thought so too, so:

Read More >

Setting Up a Home Learning Lab

Thanks to virtualization and cheap, powerful hardware there are a lot of cost effective options available today for setting up a learning environment on your own. In this blog post I will make suggestions on how you can cheaply build yourself an IT Playground, I’ll also talk about some mistakes I made along the way to hopefully save you from adding a few grey hairs.

Read More >

REGEXP_REPLACE: Auto-Translate SQL Literals to Bind Vars

In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.

Read More >

Hadoop FAQ – But What About the DBAs?

Do DBAs have a role to play with Hadoop clusters? If so, what is that role and what skills they need to get there. I provide the answers to these questions in this post.

Read More >

The Easy Way of Finding Similar SQL Statements

As we all know proper use of bind variables in SQL statements is a must to make transaction processing applications scalable. So how do we find the queries that don’t use bind variables and have to be parsed each time they are executed? There is number of ways, but this article is all about the most effective way I know. If you have a better one – let me know please!

Read More >