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

Posted in: Technical Track

If the basics are right, then the foundation is more likely to be solid, and the growth on that foundation is almost sure to follow the progressive path. Oracle, SQL Server, and MySQL bloggers are striving hard to set the basics of technology in order to help lay a sound foundation for the readers so that they can grow leaps and bounds in the right direction. This Log Buffer Edition covers just that.


Well, the long-awaited Oracle cloud offering is finally here and Bradley Brown is walking you through it.

Bobby Durrett is discussing the limits of SQL optimization.

Leslie McNeill of Oracle OpenWorld Blog team talks about friends, food, and fun at the My Oracle Support community meetup.

Jake is blogging about even more Internet of things, SmartThings.

Mark Rittman is integrating Oracle WebCenter and Oracle BI EE.

SQL Server:

So, what is a Relational Database? Kevin Kline is in Timewarp.

Back when the lock manager was rewritten for SQL Server 7 and row level locking was added to the product, the procedure sp_index option gave us the ability to turn OFF either row or page locks or both for one particular index or for a table and all the indexes on it. Kalen has more.

The humble Compute Scalar is one of the least understood execution plan operators and usually the last place people look for query performance problems. Paul White blogs.

Buck Woody guides us on how to use the resources the right way.

Louis Davidson is asking about utility queries-structures of tables with the Identity column.


Baron Schwartz is helping us detect MySQL server problems automatically.

MySQL and NoSQL go together. In the data center, that’s a known fact. Inside MySQL, that’s lesser known. Ulf Wendel writes.

Tim Callaghan is having a go at the Covered Indexes vs. Clustered Fractal Tree Indexes.

One useful feature of the Percona MySQL builds are the User Statistics.  They let you track detailed information about clients and individual user accounts and threads indexes and tables, according to Gavin Towey.

Why are there gaps in my auto_increment sequence even though there are no deletes or rolled back transactions? Scott Noyes answers.

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 *