This Log Buffer Edition digs deep into the realms of Oracle, SQL Server and MySQL and brings together a few of the top blog posts.
Oracle
We’ve all encountered a situation when you want to check a simple query or syntax for your SQL and don’t have a database around. Of course, most of us have at least a virtual machine for that, but it takes time to fire it up, and if you work from battery, it can leave you without power pretty quickly.
View Criteria is set to execute in Database mode by default. There is option to change execution mode to Both. This would execute query and fetch results from database and from memory. Such query execution is useful, when we want to include newly created (but not committed yet) row into View Criteria result. Newly created row will be included into View Criteria resultset.
Upgrading database hardware in an organization is always a cumbersome process. The most time consuming step is, planing for the upgrade, which mainly includes choosing right hardware for your Oracle databases. After deciding on the hardware type for your databases, rest will be taken care by technical teams involved.
Gluent New World #02: SQL-on-Hadoop with Mark Rittman
The pre-12c implementation of DCD used TNS packages to “ping” the client and relied on the underlying TCP stack which sometimes may take longer. Now in 12c this has changed and DCD probes are implemented by TCP Stack. The DCD probes will now use the TCP KEEPALIVE socket.
SQL Server
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
One of more common concerns among database administrators who consider migrating their estate to Azure SQL Database is their ability to efficiently manage the migrated workloads.
A SQL Server Patching Shortcut
Move an Existing Log Shipping Database to a New Monitor Server
Knee-Jerk Performance Tuning : Incorrect Use of Temporary Tables
MySQL
MySQL 5.7 sysbench OLTP read-only results: is MySQL 5.7 really faster?
7 Galera Cluster presentations in Percona Live Santa Clara 18-21.4. Meet us there!
Generate JSON Data with dbForge Data Generator for MySQL v1.6!
Extending the SYS schema to show metadata locks
EXPLAIN FORMAT=JSON wrap-up
No comments