Top SQL Blogs Weekly: Best of 15/2018

15.04.2018 07:00:00

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

SQL Server

Optimization Thresholds – Grouping and Aggregating Data, Part 1
Creating Facets in SQL Server 2017 Using R
Change SQL Server Collation - Back to Basics
SQL SERVER – Steps to Migrate Cluster Storage from Old Disks to Newly Attached Disks
Training Week: Announcing Ben Miller's PowerShell for DBAs: Level 2

PostgreSQL

Partition Elimination in PostgreSQL 11
Using Java Database Interface (jDBI) with PostgreSQL
Waiting for PostgreSQL 11 – MERGE SQL Command following SQL:2016
#251: The Story of A Mega Postgres 10 Upgrade
paste.depesz.com is back (for good?)

MySQL

Percona Live 2018 Featured Talk: Containerizing Databases at New Relic (What We Learned) with Joshua Galbraith and Bryant Vinisky
New Regular Expression Functions in MySQL 8.0
MySQL 8.0 Regular expressions and character properties
Migrating Database Charsets to utf8mb4: A Story from the Trenches
ProxySQL Admin Support for Multiple Clusters

Oracle

Concurrency … the path to success and the path the failure
18.1 – New Formatting Option, Right-Align Query Keywords
18.1 Features: SQL Injection Detection
A look into oracle redo, part 9a: commit – concurrency considerations
Data Hashing

Mishmash

Fedora R Install
Top SQL Blogs Weekly: Best of 14/2018




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