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

Posted in: Technical Track

In your hands, the new edition of Log Buffer is smiling and it wants your undivided attention, because it is full of selected simmering yet cool blog posts from around the blogistan of database arena. Enjoy the Log Buffer #226.


Kyle Hailey is exploring I/O histogram values in Automatic Workload Repository.

Charles Hopper tells us what is wrong with the quote – Addressing TM Enqueue Contention

Richard Foote blogs about some random notes in his sweet style.

Woohoo, Jonathan Lewis is writing another book. What a good news of 2011.

Marco blogs about a HowTo of XML partitioning and multiple XMLIndex structures.

SQL Server:

Vishal discusses the sys.database_principals which contains all users/roles in the current database.

SQL Server “Denali” is the code name for the next version of SQL Server. James Serra blogs about the releases of CTP1 of Denali and promises to blog more.

Chris Webb says that most of the time when you’re using dimension security with SSAS, you’re slicing a hierarchy vertically.

The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. Ryan Adams has more.

Andy Lohn gives the TSQL Tip of the week and that is how to copy a table structure.


MySQL Connector/Net 6.3.7, a new version of the all-managed .NET driver for MySQL has been released. This is a maintenance release to our existing 6.3 products and is suitable for use in production environments against MySQL server 5.0-5.5, as per Reggie Burnett.

Henrik Ingo touches the Galera clustering for MySQL first time and is pretty excited about it.

Nicholas Goodman evangelizes the single biggest advantage of enabling SQL Access to CouchDB Views.

Kristian Nielsen tells us the tale of the bug lp:798213 and document it.

Giuseppe Maxia blogs about the less known facts about MySQL user grants.

Happy Summer!!!



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 *