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

Posted in: Log Buffer, Technical Track

This Log Buffer Edition covers Oracle, SQL Server, Cloud, and PostgreSQL. Special thanks to Jeremy Schneider for PostgreSQL information.

Cloud:

Getting Ready for AWS re:Invent 2017

Amazon Elasticsearch Service now supports VPC

Introducing Gluon: a new library for machine learning from AWS and Microsoft

Do You Have a SaaS Checklist?

Azure Event Grid now supports Event Hubs as a destination

Oracle:

Rapid first few steps with Fn – open source project for serverless functions

Database as a Service using Enterprise Manager

Best method for tuning sub-optimal execution plans

VBCS: Action Handlers, send an email

Selective persistence of Oracle Diagnostic Logging (ODL) output

SQL Server:

SQL Server Performance Benchmarking with Patterns

Introduction to Statistics

10 Ways to Save Money and Provide Comprehensive High Availability for SQL Server

SQL Server Integration Services 2016 Tutorial

The Real World of the Database Administrator

PostgreSQL:

PostgreSQL 10.0 was released on Thursday October 5. Contributor Robert Haas said this is the most impressive list of new features in
the past 10 years. A few headline areas include logical replication, partitioning and parallel query.

Rachid Belaid wrote a great introduction to PostgreSQL physical storage. On the surface it is very similar to other common relational databases, but be careful… remember that PostgreSQL does MVCC very differently from most other relational databases. (hint: there’s no undo tablespace!)

If there are table stakes for relational databases, it’s reliable backup and recovery. PostgreSQL add-ons provide the polished interface (a la RMAN) but the database core itself is stable, hardened and mature with regards to durability. Craig Kerstiens recently wrote a nice overview of logical and physical backups on PostgreSQL and it’s also worth reviewing Sadequl Hussain‘s excellent walk-through from last year on the topic.

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 *