Top SQL Blogs Weekly: Best of 39/2017

01.10.2017 07:03:47

Top SQL Blogs brings you interesting news every day. Each week I select the best of:

SQL Server

SQL SERVER – What Are Ghost Records and How to Clean Them Up?
SQL SERVER – Document Your Databases with Data Dictionary and Diagrams
SQL SERVER – Simple Explanation of AT TIME ZONE Feature
How to Hire a Junior DBA
SQL SERVER – How to Enable Backup Compression On by Default

PostgreSQL

Transaction traceability in PostgreSQL 10 with txid_status(…)
Postgres-BDR with OmniDB
Storing the Original Time Zone
PL/pgSQL's Good SQL Alignment
Working on production systems

MySQL

MySQL 8.0 RC1 – Highlights
Percona Monitoring and Management 1.3.0 Is Now Available
Percona Live Europe: Tutorials Day
Avoid Shared Locks from Subqueries When Possible
Percona Live Europe Session Interview: High-Performance JSON – PostgreSQL Vs. MongoDB with Wei Shan Ang and Dominic Dwyer (GlobalSign)

Oracle

Oracle Indexing Myths (Telling Lies)
Get the Right Columns, In the Right Order
Ampersand instead of colon for bind variables
How to group connected elements (or pairs)
check invalid directories

Mishmash

How to install MongoDB
Dataedo 6.0 beta: Custom Fields, Cross-DB and Much More!
Top SQL Blogs Weekly: Best of 38/2017




© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.