This log buffer edition sprouts from the beauty, glamour and intelligence of various blog posts from Oracle, SQL Server, and MySQL.
Oracle:
Oracle Exadata Performance: Latest Improvements and Less Known Features
Exadata Storage Index Min/Max Optimization
Oracle system V shared memory indicated deleted
12c Parallel Execution New Features: Concurrent UNION ALL
Why does index monitoring makes Connor’s scratch his head and charges off to google so many times.
SQL Server:
Learn how to begin unit testing with tSQLt and SQL Server.
‘Temporal’ tables contain facts that are valid for a period of time. When they are used for financial information they have to be very well constrained to prevent errors getting in and causing incorrect reporting.
As big data application success stories (and failures) have appeared in the news and technical publications, several myths have emerged about big data. This article explores a few of the more significant myths, and how they may negatively affect your own big data implementation.
When effective end dates don’t align properly with effective start dates for subsequent rows, what are you to do?
In order to automate the delivery of an application together with its database, you probably just need the extra database tools that allow you to continue with your current source control system and release management system by integrating the database into it.
MySQL:
Ronald Bradford on SQL, ANSI Standards, PostgreSQL and MySQL.
How to Manage the World’s Top Open Source Databases: ClusterControl 1.2.9 Features Webinar Replay
A few interesting findings on MariaDB and MySQL scalability, multi-table OLTP RO
MariaDB: The Differences, Expectations, and Future
How to Tell If It’s MySQL Swapping
No comments