Log Buffer #226, A Carnival of the Vanities for DBAs
Jun 24, 2011 / By Fahd Mirza
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.
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.