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

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.

Oracle:

• If you grant the DBA role to a user, Oracle also grants it the UNLIMITED TABLESPACE system privilege. If you then revoke the DBA role from this user, Oracle also revokes its UNLIMITED TABLESPACE system privilege.
• Lost SYSMAN password OEM CC 12gR5.
• How Terminal Emulation Assists Easy Data Management.
• Using EMCLI List Verb to Get Detailed Information of EM Targets.
• How to change apex_public_user password in ORDS.

SQL Server:

• When the connection between you and the the target host are multiple servers across the continent, the latency will drive crazy mad.
• SQLCMD and Batch File magic.
• Greg Larson walks through the GUI installation process for SQL Server 2016 and explore these new installation options.
• A Single-Parameter Date Range in SQL Server Reporting Services.
• Is SQL Server killing your application’s performance?

MySQL:

• MariaDB Galera Cluster 10.0.22 and Connector updates.
• Building MaxScale from source on CentOS 7.
• Orchestrator & Pseudo-GTID for binlog reader failover.
• InnoDB holepunch compression vs the filesystem in MariaDB 10.1.
• Open-sourcing PinLater: An asynchronous job execution system.

Learn more about Pythian’s expertise in Oracle , SQL Server & MySQL.