Top SQL Blogs Weekly: Best of 42/2016

23.10.2016 07:00:00

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

SQL Server

sp_whoisactive: The Big Fixes!
SQL SERVER – How to Avoid Triggers for Multiple Row Operations in a Table
SQL SERVER Management Studio – Why I am Seeing White Icon Instead of Green or Red?
Searching Strings in SQL Server is Expensive
Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries

PostgreSQL

Back to the Future Part 3: pg_rewind with PostgreSQL 9.6
PostgreSQL and the Platinum Guarantee
BDR History and future
pglogical 1.2 with PostgreSQL 9.6 support
PG Phriday: Broken Parts

MySQL

New MariaDB Foundation staff member sponsored by Alibaba: Lixun Peng
Percona Responds to East Coast DDoS Attack
Upgrading to MySQL 5.7? Beware of the new STRICT mode
A Guide to the Percona Monitoring and Management Demo
Percona Server 5.6.33-79.0 is now available

Oracle

Fixed Stats
Taking a peek at SYS_CONTEXT
Running external programs from the scheduler
Locked rows and lunch breaks ? A simple fix
Conjuctive Normal Form

Mishmash

Interactive Analytics: Redshift vs Snowflake vs BigQuery
Install cx_Oracle for Python
Top SQL Blogs Weekly: Best of 41/2016
Oracle Segment Fails
Python for loops




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