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.
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:
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.
In this post I show you how to get SQL strings transformed in a way that resembles the result of cursor_sharing.
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.
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!
Wouldn’t it be nice if there was a way to flip block and postfix statements with the ease of a single command? Well, I thought so, so I came up with a dirty little script, have a look.
This post should give you some insights into the risk that your databases are in by switching to the bulk-logged recovery model. So, what do you need to do to avoid this risk? Make sure that you run a backup immediately after the transactions you are running under the bulk-logged recovery model complete.
I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (126.96.36.199). A few documents do exist for this process. However I found a few inconsistencies and problems; I think the existing documents I found were written on older versions of OEM and older versions of the tools. I’m publishing my final procedure here with hopes that it helps you, but as always please cross-reference this with the appropriate documentation before doing anything in your own environment.
This one was going to be a cry for help and a request to confirm that I’m not going cuckoo, but I think I figured it out. Still, for giggles, hear this: