Top SQL Blogs Weekly: Best of 36/2016

11.09.2016 07:00:00

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

SQL Server

SA Spoof
DBA Days: Money for Nothing, Chips for Free
DBA Days: Scripts from Downtime Train
DBA Days: Killing TempDB softly
Query Store, Force Plan and "Better" Plans

PostgreSQL

PostgreSQL 9.1 End of Life
The „synchronous_commit" parameter and streaming replication
PostGIS 2.3.0beta1 Released
PG Phriday: Irrelevant Inclinations
pg_cron: Run periodic jobs in PostgreSQL

MySQL

Don't Spin Your Data, Use SSDs!
Get MySQL Passwords in Plain Text from .mylogin.cnf
Percona is Hiring: Director of Platform Engineering
Basic Housekeeping for MySQL Indexes
MyRocks Docker images

Oracle

Having Fun With Prompts – and Saving Yourself from Mistakes
How to Convert Rows to Columns and Back Again with SQL (Aka PIVOT and UNPIVOT)
Partitioning an existing index
How many memory is truly used by my Oracle instance?
Ask Tom table about NOLOGGING and redo generation

Mishmash

The Best Redshift Optimization Blog Posts of 2016
Calculating Proportional Values in SQL
Top SQL Blogs Weekly: Best of 35/2016




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