ALL POSTS

Two Database Engines, One Table

Our flagship tool, Support Track, is steadily migrating over to use DBIx::Class to read and manipulate our databases. This is a very useful tool, for many reasons that can be better explained by others. One of these reasons is that, thanks to the magic of SQLite, it lets us write unit test scripts, and other quick prototyping codes, without needing to set up a heavy database server to run against. However, Support Track is powered by Oracle, not SQLite, and while DBIx::Class abstracts most of the differences out of our code, it can’t completely eliminate them. How do we overcome the syntactic differences?

Log Buffer #270, A Carnival of the Vanities for DBAs

As Summer begins in many parts of the world, not only is nature waking up, but many bloggers are also coming out of hiatus and the database blogsphere is seeing new sensational activity. This Log Buffer Edition includes blogging tidbits from Oracle, SQL Server, and MySQL. Enjoy!

Collaborate 2012 as Seen by a MySQL DBA

I spent last week at Collaborate 2012 in Las Vegas, and it was a really great experience in many ways. I am a MySQL DBA and have been working with MySQL for most of my career, so Collaborate didn’t seem like an obvious choice. It turned out that I had so much to learn from Oracle professionals and the Oracle community that could be applied in the MySQL world. For me, an indication of a good conference is when you come back inspired and full of ideas.

Some Fun with MySQL’s History List

Why this article? First, I had fun digging in the code. Then, I was reading about the future improvements for MySQL 5.6 and about some currently in 5.5. Most of them are well covered by people with more expertise than me. So I read, but after a while I became curious, read the code, and performed tests. I was looking at how the new Purge thread mechanism work and its implications. Here’s what I found.

Around the World in a Day: Oracle Apps Upgrades the Pythian Way

Pythian’s Oracle Apps DBA team recently upgraded a client’s E-Business Suite system to version 12.1.3, bringing them into compliance with Oracle’s baseline support requirements for Release 12.1 nearly one year ahead of deadline. We’d like to tell you a bit about this project — not to toot our own horn (though that’s nice too, we are kinda proud), but because it provides an ideal illustration of the power of the Pythian service delivery model, particularly as it applies to large enterprise-class projects.

Log Buffer #269, A Carnival of the Vanities for DBAs

There is no replacement for the documentation of database products. There is no alternative to forums for these technologies, and no alter-ego for database blogs. They create yet another avenue to explore for professionals who need help. This Log Buffer Edition helps professionals locate a few blog posts from across the databases. Enjoy!

What a Difference a Space Makes

I had a very interesting experience in my “RACing up the Miles” session this morning. There were about 70 people in the room, and I hope they enjoyed the session as much as I did. I discussed a wee bit of architecture about RAC and concentrated on a very basic beginner’s primer to management activities with srvctl and crsctl.

And They’re Off….

It’s day 2 of COLLABORATE, and I have no distractions like hockey to tend with today. I have seen a nice balance between new technology and the traditional offerings in the Oracle tech space. These user group shows, in some ways, are the bastion of the technologies which, as “old” as they may be, are still in use and of interest to many attendees.

Page 60 of 248« First...102030...5859606162...708090...Last »