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

Posted in: Technical Track

This Log Buffer Editions rounds up, yet again, some cool blog posts from across the planet. Sit back, relax and enjoy.

Oracle:

Marc has completed review of enhancement of SQL regarding RMAN in the 12c.

This weekend we have finalized latest update for our ADF runtime performance audit tool – Red Samurai Performance Audit Tool v 2.4.

This isn’t a SQL Developer post per-se, however if you are using the Oracle Developer Day VirtualBox 12c image, you will find this useful.

aud$ and ASSM – a good combination.

Why You Don’t Want to Code Validation in Before Commit?

SQL Server:

Basit A. Farooq talks about Different approaches of counting number of rows in a table.

The Top 5 SQL Server Features You Aren’t Using And Why.

A CLR Application: Deleting Three Billion Rows.

The simple query to find the database backup status The select statment consists of ServerName dbname BackupStartDate BackupFinishDate BackupAge Size status Type The query will only run from sql 2005 and later version.

Characters you should never ever use in an object or schema name!

MySQL:

Migration of MTR suites to use InnoDB.

50 tips to boost MySQL Performance Webinar follow up .

MySQL Workbench is a great tool when someone asks you to look at their schemas.

MySQL for Excel Main Features Video.

Many-table joins in MySQL 5.6.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The 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 enabled me to get 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. These days for the last some 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 *