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.
No comments