Top SQL Blogs Weekly: Best of 51/2015

20.12.2015 00:05:59

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

SQL Server

SQL SERVER – Fix SQL Server Index Fragmentation with dbForge Index Manager
SQL SERVER – How to Create a Readable Secondary Server in SQL Server Standard – Notes from the Field #107
SQL SERVER – Server Side and Client Side Trace
Optimizing Update Queries
Give Your T-SQL a Semicolonoscopy

PostgreSQL

MongoDB Adds Postgres and Validates Postgres’ Central Role in Hybrid Data Platform Strategy
PostgreSQL with different I/O schedulers
Waiting for 9.6 – psql: Support multiple -c and -f options, and allow mixing them.
Waiting for 9.6 – Allow EXPLAIN (ANALYZE, VERBOSE) to display per-worker statistics.
A Business Card History of Postgres

MySQL

Percona Server for MongoDB 3.0.7-1.0 is now available
MongoDB 3.2 WiredTiger in iiBench
Percona Server 5.7.10-1 first RC available
Sneak peek at the Percona Live Data Performance Conference and Expo 2016
Using dbsake to recover table structure from .frm files and process mysqldump output

Oracle

Creating Multiple Tables in a Single Transaction
Formatting Code in SQLcl
The art of describing a problem
Your Favorite Posts from 2015
Unindexed Foreign Keys on empty/unused table and locks

Mishmash

Multi-dimensional Clustering Using K-Means in Postgres SQL
Using Different MySQL Storage Engines in Database Design
Database Modeling Course (3): Problem Set 1 – Identifying Entities
Top SQL Blogs Weekly: Best of 50/2015
Advent Calendar: Tip #16 – Can I put the same table in the diagram twice?




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