This Log Buffer Edition covers some of the hottest blog posts of Oracle, SQL Server and MySQL for the previous week.
Oracle:
A recent post on the OTN database forum reminded Jonathan how easy it is to forget to keep repeating a piece of information after the first couple of hundred times you’ve explained it. No matter how “intuitively obvious” it is for one person, it’s new to someone else.
The OMS Patcher is a newer patching mechanism for the OMS specifically.
A SQLT report has all kinds of pertinent information including—to name just a few—optimizer settings, indexes, statistics, plan history, and view definitions.
Joins are fundamental in SQL, and are used in most every production query. There are three types in particular that every developer should fully understand.
Why should Oracle Database professionals care about NoSQL and where to start?
SQL Server:
Understanding OPENJSON and FOR JSON in Azure and SQL 2016
Using Data Compression in Master Data Services 2016
The most frustrating thing with any new system is often just working out how to connect to it.
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes.
Database Hardware and Infrastructure Trends
STRING_SPLIT() in SQL Server 2016 : Follow-Up #2
MySQL:
Why would I run MySQL/MariaDB on POWER anyway?
By default, the write() system call returns after all data has been copied from the user space file descriptor into the kernel space buffers. There is no guarantee that data has actually reached the physical storage.
OpenCPS: Vietnam’s Public Sector goes Open Source
MySQL uses metadata locking to manage concurrent access to database objects, and to ensure data consistency when performing modifications to the schema
Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production.
No comments