This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs from across the planet.
Oracle:
You might be thinking “Nothing is more frustrating that encountering a string column that is full of dates”. But there is something worse than that.
Unique constraint WWV_FLOW_WORKSHEET_RPTS_UK violated.
Understanding query slowness after platform change
Database Migration and Integration using AWS DMS
Oracle BPM 12c: Browsing the SOAINFRA
SQL Server:
Adding PK Exceptions to SQLCop Tests
Is a RID Lookup faster than a Key Lookup?
Performance Surprises and Assumptions : DATEADD()
Generate INSERT scripts from SQL Server queries and stored procedure output
PowerShell Desired State Configuration: Pull Mode
Continuous Delivery from the 19th Century to TODAY
MySQL:
ProxySQL versus MaxScale for OLTP RO workloads
Properly removing users in MySQL
MySQL/MariaDB cursors and temp tables
Quick start MySQL testing using Docker (on a Mac!)
Query Rewrite plugin can harm performance
No comments