I just put together on “meetup.com” the first Pensacola MUG meeting. The first meeting is scheduled for August the 5th at 7:00 pm at the Panera Bread right outside the entrance to Cordova Mall.Read More >
That’s right. MySQL now has a user group in Paradise. I am always looking into connecting with other MySQL professionals, to share the laughs and tears, and to enjoy what we love working with every day, MySQL. I have always wanted to bring us all together, and I thought that this would have a good chance of doing so.We will be having our first meeting in Mellieha, and please RSVP to me personally via email, westerlund (at) pythian.com if you want to attend.Read More >
Small local user group meetings have their own beauty because of the special intimate atmosphere. We expected somewhat higher attendance but it seems that people were already in the holiday mode. The presentation itself went very well and I liked my pace since I didn’t have any time pressure. I’ve done this presentation before in 45 minutes and this time it took slightly more than an hour but I was able to spend additional time on few more complex topics and explain the underlying concepts making sure we all are on the same page. I also enjoyed the questions during the presentation — always a pleasure to know which parts are more interesting to the audience and questions is one of the best indicators. Another one is when people take notes. All in all — it was a very encouraging hour. Thanks to every one who attended!Read More >
I finished uploading the backup presentation that I did last Monday at the Boston MySQL User’s Group. I cover the basics of backup/recovery and disaster planning. Total time is about an hour and three minutes. It was a lot of fun and the Bostonians seem to appreciate it.Read More >
The latest news — there is a new web site — ashmasters.com. This is the place where you can leave your comments and questions about ASH and ASHMON. Wondering how you can query ASH data? There are some ready to use queries. Have a cool idea how to use ASH and query ASH data? Share it there and have it added to the ASH Masters queries toolkit.Read More >
Ever wished the listener.log file was a table in the database? Wish no more! About three years ago, I sent this recipe in an email to my co-workers. Just recently, Shakir re-sent it after using the method in an emergency. Since it seems to have proved its value, I now offer it to our readers. Have a look.Read More >
I recently imported the contents of an Oracle 8i database into an 11g database. After following the instructions for a typical setupI set up a database link to a remote SQL Server database, and called it SQLSERVER.. It turned out that dg4odbc has “hard coded” the quotes and this will need to be changed in odbc.ini. I should have looked more closely at the installation instructions — yes, the example shows QuotedId=Yes.Read More >
The latest release of DBD::Oracle is now ready and can be found at: CPAN DBD::Oracle. It is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles as open source/free software, under the auspices of The Pythian Group.
The release has been fully tested with the latest version of DBI (1.601). A list of the changes and/or fixes in this release are included.
I try to do a decent job of advocating for caring about good backups and business continuity strategies in my 7 Deadly Habits article. But this one beats them all, have a look for yourself, it too funny.Read More >
I gave this talk covering the different types of memory, how to monitor memory, and how to optimally use it with Oracle at the UKOUG, I have since received requests to post the slides online. Instead of just posting the PowerPoint I took some time to give the presentation again (internally here at Pythian) and this time we recorded the session and are posting it in a variety of formats. This is a bit of a departure from the typical Pythian Goodies, in that it is scripted, and there is a lot of content here in the whitepaper.Read More >