This Log Buffer Edition covers some informative and interesting posts from Oracle, SQL Server and the MySQL.
Oracle:
If you’re not using Toad DBA Suite, it’s sometimes hard to find solutions. Somebody wanted to know how to find indexes that aren’t that aren’t indirect. Indirect indexes are those created for a primary key because a primary key column or set of columns are both not null and uniquely constrained. You can’t drop a unique index for a primary key without dropping the primary key constraint that indirectly created it.
At the NoCOUG fall conference at the eBay town hall in San Jose, we got a first-hand look at the workings of the most complex database environments in the world.
Is there a feature you would like added to Inventory or Inventory Items? Tired of logging Service Requests with Support to request product enhancements? Well those days are over. You can now submit Enhancement Requests (ER’s) for Logistics (Inventory) and/or Inventory Items (APC/PLM/PIM) directly in their respective Communities.
Oracle Database 12c : EXPAND_SQL_TEXT, APPROX_COUNT_DISTINCT, Session Sequences and Temporary Undo.
Integrating Cordova Plugin with Oracle MAF – iOS Calendar Plugin by Chris Muir.
SQL Server:
Learn how to invoke SSRS reports from an SSIS package after the data load is completed.
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask.
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
Monitoring Azure SQL Database.
Stairway to SQL Server Agent – Level 2: Job Steps and Subsystems.
Where in the Application Should Data Validation be Done?
MySQL:
Creating JSON documents with MariaDB.
Geographic replication with MySQL and Galera.
Sys Schema for MySQL 5.6 and MySQL 5.7.
Logging with MySQL: Error-Logging to Syslog & EventLog.
Multi-source Replication with Galera Cluster for MySQL.
No comments