The show goes on. This Log Buffer Edition picks some blogs which are discussing new and old features of Oracle, SQL Server and MySQL.
Oracle:
- Directory Usage Parameters (ldap.ora) list the host names and port number of the primary and alternate LDAP directory servers.
- Data Visualization Cloud Service (DVCS) is a new Oracle Cloud Service. It is a subset offering of the currently supported Business Intelligence Cloud Service (BICS).
- ORA-24247: network access denied by access control list (ACL).
- Latches are low level serialization mechanisms, which protect memory areas inside SGA. They are light wait and less sophesticated than enqueues and can be acquired and released very quickly.
- handling disks for ASM – when DB, Linux and Storage admins work together.
SQL Server:
- How to use the Performance Counter to measure performance and activity in Microsoft Data Mining.
- Phil Factor demonstrates a PowerShell-based technique taking the tedium out of testing SQL DML.
- Sandeep Mittal provides an introduction to the COALESCE function and shows us how to use it.
- Hadoop many flavors of SQL.
- Installing and Getting Started With Semantic Search.
MySQL:
- Support for storing and querying JSON within SQL is progressing for the ANSI/ISO SQL Standard, and for MySQL 5.7.
- Loss-less failover using MySQL semi-syncronous replication and MySQL Fabric!
- Memory consumption The binary format of the JSON data type should consume more memory.
- This post compares a B-Tree and LSM for read, write and space amplification. The comparison is done in theory and practice so expect some handwaving mixed with data from iostat and vmstat collected while running the Linkbench workload.
- If you do not have a reliable network access (i.e. in some remote places) or need something really small to store your data you can now use Intel Edison.
Learn more about Pythian’s expertise in Oracle , SQL Server & MySQL.
No comments