Log Buffer #461: A Carnival of the Vanities for DBAs

Posted in: Log Buffer, Technical Track

This Log Buffer browses through Oracle, SQL Server and MySQL spaces and brings forth some of the useful blog posts for this week.

Oracle:

Conner throws it out of the park. As we all (hopefully) know, we should always deploy named program units (procedures/functions) within packages. Its a great method of encapsulation of logic.

Pythian’s Gleb talks about Azure on RAC. Microsoft Azure provides an acceptable and affordable platform for a training environment.

There are some performance improvements that require physical storage options to be set on tables or indexes. One particular technique that I will take as an example for this article is index compression.

To call Oracle Reports from Oracle Forms application, the most secure approach is to use the RUN_REPORT_OBJECT built-in.

Introducing Asset Physical Inventory with PeopleSoft Asset Tracking

SQL Server:

Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server

SSIS: Case sensitivity may expose issues with change deployment

Foreign Key Indexes and Binding

In SQL Server 2016 we have new compression functions to compress and uncompress specific data.

Database Continuous Integration

MySQL:

VividCortex is all about optimizing your queries. Many of our users asked us to analyse their queries, searching for common errors and mistakes.

RocksDB vs the world for loading Linkbench tables

Measuring Docker IO overhead

MariaDB 5.5.48 and Connector/J 1.3.5 now available

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

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.

No comments

Leave a Reply

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