While cloud technologies are roaring ahead in full force; the traditional RDBMS like Oracle, Microsoft SQL Server and MySQL are adapting pretty fast. This Log Buffer Edition covers blogs related to that and more.
Oracle:
Oracle JET Simple Table with Fake JSON Server
Every time any page is requested from your website by a human or another program or an automated bot, the event is tracked in a log file that is stored on the web server.
Gitora 2 enabled developers to manage database objects that support the CREATE OR REPLACE command, namely PACKAGES, PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS, SYNONYMS and TYPES in a Git repository.
Oracle just released its first REST JDBC driver on OTN, in conjunction with the 17.3.0 Oracle REST Data Services Beta release.
When you are restrained in the JRE that you can use with SQLcl, you can embed your own in the sqlcl directory tree.
SQL Server:
Understanding Azure Data Factory – A Cloud Based Integration Service
The Shortcomings of Predictive Accuracy
Setting Variables in Calling T-SQL Code While Using sp_executesql
Azure DWH part 15: PolyBase and Azure Data Lake
Creating Basic Indexes on the Stack Overflow Public Database
MySQL:
Heads Up: The List of Replication Defaults That Have Changed in 8.0.2
IO-bound table scan performance for MyRocks, InnoDB and TokuDB
MyRocks Experimental Now Available with Percona Server for MySQL 5.7.19-17
Timing load & index for sysbench tables
Automatic Partition Maintenance in MariaDB
No comments