This Log Buffer Edition covers the Oracle, SQL Server and MySQL with a keen look on the novel ideas.
The case was to roll forward a physical standby with an RMAN SCN incremental backup taken from primary.
Oracle Database 12c: Smart upgrade
This blog covers how to specify query parameters using the REST Service Editor.
Production workloads blend Cloud and On-Premise Capabilities
ALTER DATABASE BEGIN BACKUP and ALTER DATABASE END BACKUP
Mail Fails with SQLCMD Error
How to get Database Design Horribly Wrong
Using the ROLLUP, CUBE, and GROUPING SETS Operators
The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
Distributing innodb tables made simpler!
Choosing a good sharding key in MongoDB (and MySQL)
Update a grails project from version 2.3.8 to version 2.4.4
MySQL Enterprise Backup 3.12.0 has been released
If table is partitioned it makes it easy to maintain. Table has grown so huge and the backups are just keep running long then probably you need to think of archival or purge.
Interested in working with Fahd? Schedule a tech call.