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

From Movember to UKOUG, Pythian is stomping the grounds with massive thuds. This Log Buffer #297 collects various great blog posts from across the database world once again. Enjoy the Log Buffer Editions.

Oracle:

Andre Araujo posts about the union of MoBros, all of them DBAs :)

Are you in UK and got penchant for MySQL or Oracle, UKOUG 2012 is the place to be, confirmed by Ben Mildren.

Bobby thought that an invisible index was never queried, but that it was only maintained as the table was modified.

Andrew Reid is having a go at Ora-01090.

Nicolas Gasparotto is blogging about Integration Network WorkCenter and Statistics.

SQL Server:

Brent Ozar is having a wow moment after the PASS Summit 2012.

Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012.

Chris Webb is giving an example of Microsoft making a big BI-related announcement at the Sharepoint Conference and not PASS, and so ensuring that no-one in the Microsoft SQL Server BI community hear about it.

Wes Brown is very glad to have a new real keyboard.

Jason Strate is lost in translation.

MySQL:

Justin Swanhart has a good take on Replication of the NOW() function (also, time travel).

MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation.

Ronald Speelman is helping you create random test data using real data from your MySql database.

MySQL Cluster 7.2.9 Released informed by Andrew Morgan.

Matt Reid is blogging about using TRIGGERs to keep datetime columns updated without direct SQL calls.