Top SQL Blogs Weekly: Best of 18/2015

03.05.2015 00:46:59

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

SQL Server

New sp_Blitz® and sp_BlitzCache® Updates
SQL SERVER – Collect and Analyze SQL Server Data Efficiently
SQL SERVER – Using “High Performance” Power Plan for SQL Server
Microsoft SQL Server Licensing Simplified into 7 Rules
Internals of the Seven SQL Server Sorts – Part 1

PostgreSQL

HOWTO use JSONB, the binary formatted JSONs in PostgreSQL
Find Budget for New Customer Engagement IT Initiatives
PG Phriday: Reducing Writes With Unlogged Tables
Postgres utilities and restricted tokens on Windows
Enabling PostGIS raster drivers and out-of-db raster support

MySQL

Generated (Virtual) Columns in MySQL 5.7 (labs)
Indexing 101: Optimizing MySQL queries on a single table
LinkBenchX: benchmark based on arrival request rate
Optimizer hints in MySQL 5.7.7 – The missed manual
Test your knowledge: Percona XtraDB Cluster (PXC) quiz

Oracle

Deploying Oracle REST Data Services from Oracle SQL Developer
Optimizing the PL/SQL Challenge III: Too Many AND Clauses Spoil the Plan
Setting Default Script Execution Directory in SQLcl
Not Exists
Preventing CREATE (only) for a User

Mishmash

OLAP for OLTP practitioners
Helpful Redshift Admin Queries
How to generate Flask-SQLAlchemy models using Vertabelo
Understanding Execution Plans in PostgreSQL
A migration pitfall with ALL COLUMN SIZE AUTO




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