This Log Buffer Editions scours the Internet and brings some of the fresh blog posts from Oracle, SQL Server and MySQL.
Oracle:
Most of Kyles’ servers tend to be Linux VMs on VMware ESX without any graphics desktops setup, so it can be disconcerting trying to install Oralce with it’s graphical “runInstaller” being the gate way we have to cross to achieve installation.
Working around heatbeat issues caused by tracing or by regexp
APEX 5 EA Impressions: Custom jQuery / jQuery UI implementations
Introduction to the REST Service Editor, Generation (PART 2)
Due to recent enhancements and importance within Oracle’s storage portfolio, StorageTek Storage Archive Manager 5.4 (SAM-QFS) has been renamed to Oracle Hierarchical Storage Manager (Oracle HSM) 6.0.
SQL Server:
There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.
Data Mining Part 25: Microsoft Visio Add-Ins
Stairway to Database Source Control Level 3: Working With Others (Centralized Repository)
SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.
Questions About SQL Server Transaction Log You Were Too Shy To Ask
MySQL:
The post shows how you can easily read the VCAP_SERVICES postgresql credentials within your Java Code using the maven repo. This assumes your using the ElephantSQL Postgresql service. A single connection won’t be ideal but for demo purposes might just be all you need.
MariaDB 5.5.42 Overview and Highlights
How to test if CVE-2015-0204 FREAK SSL security flaw affects you
Using master-master for MySQL? To be frankly we need to get rid of that architecture. We are skipping the active-active setup and show why master-master even for failover reasons is the wrong decision.
Resources for Highly Available Database Clusters: ClusterControl Release Webinar, Support for Postgres, New Website and More
No comments