Top SQL Blogs Weekly: Best of 25/2017

25.06.2017 07:02:21

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

SQL Server

SQL SERVER – New Quality of Database Documentation – Dataedo
The Three T's of Backups
12 Ways Smart Data Professionals Act Stupid
SQL SERVER – PowerShell Script – Remove Old SQL Database Backup Files From Azure Storage
Changing Default Database File Locations in SQL Server 2016

PostgreSQL

Odd Month Arithmetic
Use WITH TIME ZONE
explain.depesz.com, paste.depesz.com – TOR announcement and some updates
#212: DynamoDB to Postgres: Why and How

MySQL

The MySQL High Availability Landscape in 2017 (The Elders)
Debian 9 released with MariaDB as the only MySQL variant
MariaDB Server 10.2 GA Release Overview
Percona Monitoring and Management 1.1.5 is Now Available
ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

Oracle

It's just bad code or bad design … most of the time
Steps for Moving ASM Disk from FRA to DATA
Using DataGuard broker to show apply lag and throughput
More on Optimistic Locking with ORA_ROWSCN
DIY parallel task execution

Mishmash

Periscope Data | How to Get Started With AWS Spectrum in Minutes
Oracle SQL Strip Quotes
Periscope Data | Optimize Your Periscope Instance With Usage Data
Periscope Data | Introducing Controlled Dashboard Refresh
Periscope Data | SQL History and Why Your Database Isn't Really Relational




© 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.