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

In this week’s edition, Log Buffer brings some of the nifty blog posts from Oracle, SQL Server and MySQL.

Oracle:

SQL*PLus on Mac

Cloud Data Warehousing for Dummies

When 2 Queries Are Better Than 1

Why oh Why Do Will Still Not Have a Fast Bulk “SQL*Unloader” Facility?

How Partial Indexing helps you save space in #Oracle 12c

SQL Server:

How to download a file from internet using SSIS

How to Get the Output of a Stored Procedure into a Table

Lists With, or Without, Ranges in both T-SQL and PowerShell

LINQ Debugging and Visualization

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

MySQL:

MySQL 8.0: MTR Configurations to Be Set to Server Defaults Where Possible

Database Daily Ops Series: GTID Replication and Binary Logs Purge

MySQL Connector/Python 2.2.2 m3 Development Release has been released

Debian and MariaDB Server

Galera Cache (gcache) is finally recoverable on restart