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

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Oracle:

Always a pleasure read, John Piwowar blogs about a change in Oracle Apps world and tells what it means to us.

You never forget your first love, first DBA blooper, and you never forget your first SSD.

Kerry Osborne shares an interesting little project which he recently did.

Why Isn’t My Index Used… When USER2 Executes this Query? One of leading guru Charles Hooper answers.

So what triggers are we talking about? Toon Koppelaars gives overview.

Cary Millsap Can Help You Trace It. Need I say more?

CBO isn’t perfect, and you should remember that.

SQL Server:

Chris Webb is announcing Technitrain – Expert SQL Server Training in the UK.

Mike Walsh is thankful for self employment this Thanksgiving.

John Pertell posts last in his series on monitoring performance on a server hosting Microsoft’s SQL Server Reporting Service.

Developers like to have some control over the development process. An example is index building.

On Thanksgiving in USA, Thomas LaRock has two things to mention and one is The DBA Plate.

MySQL:

Shlomi Noach blogs about reading results of SHOW statements, on server side.

Arjen shares the video of recent session at OSDC 2011 Canberra about SQL Locking and transactions.

The ScaleBase Analysis tool gives a schema a grade between 1 and 100 for being “sharding compatible”. It’s a neat feature, but many ask how the grade is calculated. Well – here goes.

Webyog has for the first time been spending some time trying to understand the performance_schema.

How do you know that your code is fast? Is it fast for your test cases or is it fast for every case? When changes are made how does that affect your customers? Dathan Pattishall answers.