Oracle Open World is in full bloom. Enthusiasts of Oracle and MySQL are flocking to extract as much knowledge, news, and fun as possible. SQL Server aficionados are not far behind too.
Oracle:
Frank Nimphius have announced REST support for ADF BC feature on OOW today. Probably this functionality will be available in the next JDeveloper 12c update release.
RMAN Enhancements New Privilege A new SYSBACKUP privilege is created in Oracle 12c, it allows the grantee to perform BACKUP and RECOVERY operations with RMAN SQL in RMAN.
To continue with the objective of separating duties and the least privileges, Oracle 12c introduce new administrative privileges all destined to accomplish specific duties.
Unified Auditing offers a consolidated approach, all the audit data is consolidated in a single place. Unified Auditing consolidate audit records for the following sources.
SOA Suite 12c – WSM-02141 : Unable to connect to the policy access service.
SQL Server:
Data Compression and Snapshot Isolation don’t play well together, you may not see a performance benefit.
Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level?
Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase ‘Quirky Update’ tricks to perform the many permutations of running totals in SQL Server.
Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.
Change All Computed Columns to Persisted in SQL Server.
MySQL:
Low-concurrency performance for point lookups: MySQL 5.7.5 vs previous releases.
How to get MySQL 5.6 parallel replication and XtraBackup to play nice together.
The InnoDB labs release includes a snapshot of the InnoDB Native Partitioning feature.
Visualizing the impact of ordered vs. random index insertion in InnoDB.
Single thread performance in MySQL 5.7.5 versus older releases via sql-bench.
No comments