This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.
Oracle:
Provisioning EBS on Oracle Cloud: Latest Enhancements
ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2
Business rules, common sense and query performance
Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed
Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!
SQL Server:
Windowing Functions: Tell me when that changes
SQL Server Bulk Insert Row Terminator Issues
Introducing DLM Techniques for a Multi-Database Multi-Server System
Ding – The World’s Largest Mobile Top-up Network Streamlines QA with SQL Server Containers
Enable Trace Flags in SQL Server
MySQL:
Migrating MySQL database from Amazon RDS to DigitalOcean
Monitoring Databases: A Product Comparison
New collations in MySQL 8.0.0
How to store date, time, and timestamps in UTC time zone with JDBC and Hibernate
MySQL Connector/NET 7.0.7 m6 development has been released
No comments