Top SQL Blogs Weekly: Best of 12/2017

26.03.2017 07:14:07

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

SQL Server

Why Developers Should Consider Microsoft SQL Server
SQL SERVER – sp_readrequest – Long Running Process
SQL SERVER – 10 Questions Where YES May Be a Wrong Answer – Performance Health Check
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved Because it is a Work Table Page – TempDB Files
5 Signs Your SQL Server Isn't Wearing Pants

PostgreSQL

What is a "good" conversion rate for your signup flow?
Outer Joins and WHERE Clauses
Characters Sets, Encodings, and Collations
Referencing SELECT Column Aliases in WHERE Clauses
Re-import repository keys for BDR and pglogical apt repositories

MySQL

Defining Moments in Database History
MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions
Running Percona XtraBackup on Windows … in Docker
Prophet: Forecasting our Metrics (or Predicting the Future)
The Puzzling Performance of the Samsung 960 Pro

Oracle

SQLcl – Setting Up the Formatter
Oracle Database 12c Release 2: Analytic Views & SQL Developer
Auto REST with ORDS: An Overview and What's Next?
Deception
Using Delphix to support Oracle upgrade

Mishmash

Install PyGame on Fedora
Top SQL Blogs Weekly: Best of 11/2017




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