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

Posted in: Technical Track

With real possibilities and opportunities, blogging is maturing day by day, and so is technology and its innovations. The combination of both becomes a dazzling medley, which is called Log Buffer. Enjoy this week’s stunning Log Buffer #311.


Sudip Datta is writing about database as a service.

Premature optimization, (probably) because of Donald Knuth’s famous line “premature optimization is the root of all evil,” (see Structured Programming with go to Statements) is, at the very least, a controversial topic.

Are you using the application server that best serves your changing business needs? Maybe it’s time to consider an upgrade? Suggested by R A Sanyal.

Not all Deadlocks are created the same, according to Doug.

Bitten by a Virtual Column, _OPTIMIZER_IGNORE_HINTS Doesn’t Ignore Hints? Charles Hooper blogs.

SQL Server:

Ryan Adams is renaming a server with SQL.

Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution!

Need to check when the SQL Server instance was rebooted?

Bradley Schacht had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with a deadlock message.

Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.


Chris Calender is troubleshooting “Waiting for table metadata lock” Errors for both MyISAM and InnoDB Tables.

Baron is currently finishing some features to make a program highly resilient to occasional crashing bugs.

The MySQL Connect 2013 Call for Papers is Open!

Want to lose your foreign key? Here is how.

So what about the diffstat of MariaDB compared to MySQL? Stewart Smith opines.

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 *