Tag: DBA Lounge

Be Careful When Revoking UNLIMITED TABLESPACE

In this post I go through some tips and advice when revoking UNLIMITED TABLESPACE in Oracle, and look at how to form the experts.

Read More >

MySQL Community Dinner at Pedro’s 2013

Pedro's Restraunt

Once again, Pythian is organizing an event that by now may be considered a tradition: The MySQL community dinner at Pedro’s! This dinner is open to all MySQL community members as many of you will be in town for the MySQL Conference that week.

Read More >

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 >