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

Posted in: Technical Track

With winter and its cold weather starting to set in across most of the world, now is the time when travelers start to think about warming things up. For most, that means flying to hot and sunny destinations. Another way of looking at it, however, is to head out for a different kind of sizzle. There’s perhaps no better way to heat up the chilling months with blogging. Let’s snuggle up in this Log Buffer Edition with hot blog posts in Log Buffer #255.


Oracle:

Steven Chan lets us know that the Critical Patch Update for January 2012 is now available.

What number immediately follows 3,999? Oracle database refuses to answer to Charles Hooper.

Doug has posted about Randolf Geist on 11g Incremental Statistics.

Giri Mandalika presents a nice tip about how to identify a memory mapped file.

Frits Hoogland has produced a gem of a blog post talking about using R and the Oracle trace files.

SQL Server:

Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL Friday? Richard Douglas has the solution.

Quite naturally, Colin Stasiuk still struggles with as a blogger is finding topics that “I” think people would want to read about or don’t know about.

If you were planning on deploying Windows 8 Server for your SQL Servers as soon as it is released, Denny Cherry would plan on rethinking those plans, especially if you plan on using the new Windows 8 file system ReFS (Resilient File System) instead of the NTFS (New Technology File System).

Is Your DBA Lying To You? Thmoas LaRock answers.

Looking at wait types in SQL Server is a great way to get some insight into how SQL Server is operating under the current load. Sankar Reddy blogs.

MySQL:

Nilnandan Joshi is revealing some facts about MyISAM file handling and .MYI file In MySQL.

Tamas Kozak is backing up binary log files with mysqlbinlog.

Balagtas has posted a tutorial which is based on his experience setting up Tungsten Replicator and MySQL-Proxy for a client’s production setup.

Matthew Aslett has just launched a new survey that should be of interest if you are currently using or actively considering MySQL or any of the NoSQL or NewSQL offerings.

MySQL 5.0 and 5.1 available on Solaris 11 and the installation is extremely simple.

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *