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

Posted in: Technical Track

This week’s post focuses on Oracle, SQL Server, and MySQL weblogs from across the planet. Log Buffer Editions are the manifestation of the fact that nerd bloggers from databases are not only growing but they are also producing immense volume of quality ramblings. Enjoy!

Oracle:

Stelios Charalambides’s book on SQLTXPLAIN is now announced, Carlos Sierra informs.

Geertjan is showing around things like Oracle DB, Oracle ADF, GlassFish, JDeveloper, and NetBeans IDE.

Paul Wright asks: Good news and bad news – which would you like first?

MacLochlainns is blogging about the reset sequence START WITH.

Glynn Foster is sharing a simple deployment example using Oracle Solaris 11.

Gwen Shapira shares excellent and concrete advice for abstract writers.

SQL Server:

Jason Strate compares the compatibility view sysperfinfo with the dynamic management view sys.dm_os_performance_counters.

SQL Server 2012 introduces the CHOOSE function, which allows to return an item based upon its 1-based index value. David Dye gives an example.

Denny Cherry is fixing a table that has overflowed its primary key.

It didn’t get much attention at the time (maybe because it was done at the Sharepoint Conference, and not at PASS). Why?  Chris Webb asks.

Jen McCown writes a good piece of advice for beginners in blogging.

MySQL:

Bill Karwin blogs about his favorite tool as he asks for some query logs.

Anders Karlsson talks all about Character sets, Collations, UTF-8, and all that.

Ulf Wendal is supercharging PHP MySQL applications using the best API.

Ronald Bradford is working on an evaluation project about schema design in open source applications and seeks community help.

In his MySQL 101, Cedric Peintre is having a go at Numeric type attributes and maximum value.

email

Author

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 *