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

Posted in: Technical Track

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.

email

Interested in working with Fahd? Schedule a tech call.

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.

1 Comment. Leave new

Log Buffer #247, A Carnival of the Vanities for DBAs « Fast Ninja Blog by Freelanceful – Web Design | Coding | Freelancing
November 27, 2011 5:07 am

[…] 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 […]PlanetMySQL Voting: Vote UP / Vote DOWN Original Source: Planet MySQL […]

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *