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

Feb 17, 2012 / By Fahd Mirza

Tags: , , ,

With the weather taking extremes turns, technology is providing the much-needed warmth through the blogs. This Log Buffer Edition is sizzling with few of the hand-picked blog posts in Log Buffer #259.

Oracle:

Love Day has passed but love is still in the air and has been captured by Vanessa in a scintillating post.

Tuning is in the eye of the beholder… Memory is memory right? Glenn Fawcett has a brilliant post.

Temporary tablespaces are shared objects and they are associated to an user or whole database (using default temporary tablespace).  Riyaj sheds light from the RAC angle.

Jonathan Lewis shares an interesting little conundrum about subquery factoring that hasn’t changed in the recent (11.2.0.3) patch for subquery factoring.

Are you finding queries to identify free space, the size of segments or details of extents in your database are very slow? Martin answers.

Nial Litchfield does a fine product review post.

SQL Server:

Thomas LaRock ponders deeply over The Internet, where facts go to die.

Michael Swart expounds over careful hashing. Cryptographic hashing functions like MD5 or SHA-1 are examples of one-way functions.

Kevin Kline informs us that we might be in luck.

Crazy Ballmer’s Database Hut is having the fire sale of the century! Brent Ozar blogs.

So, what is the BI Semantic Model? Chris Webb answers.

MySQL:

Jonas Oreland can’t help to think of austin powers when seeing one billion queries per minute.

Ronald Bradford shares his MySQL security essential presentation.

Andrew Morgan writes down about 1 Billion queries per minute and much more on MySQL Cluster 7.2 GA.

Mikael Ronström talks about scalability enhancements of MySQL Cluster 7.2.

Anders Karlsson thinks that SQL_MODE is useless…

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>