This Log Buffer Edition covers Oracle, SQL Server and MySQL blog posts of the week.
Oracle:
Improving PL/SQL performance in APEX
A utility to extract and present PeopleSoft Configuration and Performance Data
No, Oracle security vulnerabilities didn’t just get a whole lot worse this quarter. Instead, Oracle updated the scoring metric used in the Critical Patch Updates (CPU) from CVSS v2 to CVSS v3.0 for the April 2016 CPU. The Common Vulnerability Score System (CVSS) is a generally accepted method for scoring and rating security vulnerabilities. CVSS is used by Oracle, Microsoft, Cisco, and other major software vendors.
Oracle Cloud – DBaaS instance down for no apparent reason
Using guaranteed restore points to navigate through time
SQL Server:
ANSI SQL with Analytic Functions on Snowflake DB
Exporting Azure Data Factory (ADF) into TFS Source Control
Getting started with Azure SQL Data Warehouse
Performance Surprises and Assumptions : DATEADD()
With the new security policy feature in SQL Server 2016 you can restrict write operations at the row level by defining a block predicate.
MySQL:
How to rename MySQL DB name by moving tables
MySQL 5.7 Introduces a JSON Data Type
Ubuntu 16.04 first stable distro with MySQL 5.7
MariaDB AWS Key Management Service (KMS) Encryption Plugin
MySQL Document Store versus Bug hunter
Author
Interested in working with Fahd? Schedule a tech call.
No comments