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

May 16, 2011 / By Fahd Mirza

Tags: , , ,

When big news is released, the world of modern information shakes – and nowhere is this more visible than with the blogs. Log Buffer is the ideal joint for the shakers and movers of the blogosphere. This edition Log Buffer #220 sheds a spotlight on those hot spots.

Oracle:

Gary Myers blogs about the encouraging women in information technology and mentioned Pythian’s own Gwen Shapira.

Dom Brooks is getting a bit tired of the number of bugs in 11gR2 listed as “Fixed in 12.1″.

Tim Hall is annoyed with Oracle Marketing for not clearing up that Oracle is not for the newbies, especially the products like RAC and Grid Control.

Doug Burns is back to statistics series, and blogs about statistics on Partitioned Tables – Part 6e – COPY_TABLE_STATS – Bug

Jonathan Lewis is in habit of sharing the gems, diamonds and pearls, and yet again shares a little but cute gem.

SQL Server:

Larry Leonard shared a nifty script to help you quantify how useful your indexes are, in the sense of how much they’re used to speed up queries, compared to how much work it is for SQL Server to maintain them during inserts, updates, and deletes.

xp_fixeddrives is a useful extended stored procedure which returns amount of free space available in MB, for all local hard drives. Vishal delves into that.

Thomas LaRock blogs about the best SQL Rally ever.

Do you have a DBA team that consists of more than one dba? Do you have a windows authenticated account that has access to all the SQL Server instances in your farm? If so, you might really want to consider leveraging the Central Management Server (CMS) to do your heavy lifting, John Sterret dishes out a useful blog.

Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters. Jose Chinchilla blogs about the Identifying, inserting and removing spaces in strings regarding T-SQL.

MySQL:

Shlomi Noach encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production, and hence blog about it.

What kind of High Availability do you need? Baron Schwartz (xaprb) answers that in a cool blog post.

Henrik Ingo discusses different ways of doing High Availability in MySQL.

Caspar Clemens Mierau gave a short talk on switching from MySQL community edition (especially 5.1) to MariaDB (currently 5.2.6) at this years LinuxTag in Berlin.

Keith Larson is Taking a look at MySQL Cluster and saving money in the long run.

Happy Immersion into the blogosphere!!!.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>