Log Buffer #494: a carnival of the vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

Declarative REST Client Feign with Spring Boot

Sometimes it is necessary to put on your uber-geek hat and start using cryptic bits of code to retrieve information from an Oracle database.

Deployment of Oracle Applications and Database with OpenStack Murano

A current question on the OTN database forum asks: “What’s the difference between object and tablespace reorganization?” Here’s an analogy to address the question.

Bulk inserts in MongoDB

SQL Server:

TempDB growth due to version store on AlwaysOn secondary server

Power BI for Data Modelling

SSIS Package documentor

SQL Server Database Provisioning

When Stored Procedures Go Bad

MySQL:

MySQL Cluster and real-time requirements

2-Phase Commit in NDBCluster

High Availability on a Shoestring Budget – Deploying a Minimal Two Node MySQL Galera Cluster

Separation of Query Server and Data Server