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

Sep 7, 2012 / By Fahd Mirza

Tags: , , ,

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.

Oracle:

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.

MySQL:

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.

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>