Top SQL Blogs Weekly: Best of 36/2015

06.09.2015 00:47:59

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

SQL Server

SQL SERVER – SPID is KILLED/ROLLBACK state. What to Do Next?
SQL SERVER – What’s the Difference between ROW_NUMBER, RANK, and DENSE_RANK? – Notes from the Field #096
SQL SERVER – Configure the Backup Compression Default Server Configuration Option
SQL SERVER – How to Enable or Disable All the Triggers on a Table and Database?
SQL SERVER – Transparent Data Encryption and Frequently Asked Questions

PostgreSQL

A Pink Cloud with Postgres Cuts Dutch Government IT Budgets
Testing GPU-accelerated PostgreSQL
Lock-polling script for ALTER TABLE
PG Phriday: Postgres as Middleware
Postgres extension to retrieve file system information

MySQL

Facebook’s Simon Martin on semi-synchronous replication
Booking dot yeah! Booking.com’s Jean-François Gagné on Percona Live Amsterdam
Introducing mysqlpump
High-load clusters and desynchronized nodes on Percona XtraDB Cluster
Percona Toolkit and systemd

Oracle

Foreign Keys and Library Cache Locks
How to Survive, no, Thrive at Oracle Open World
Plan change monitor prevents user impact from bad plan
12C Paging through Data and Restricting Result Sets
Index Usage – 4

Mishmash

Free Oracle Tuning Book
Solving the Traveling Salesman Problem with Postgres Recursive CTEs
Creating Drupal Charts on External Views Data
Using CALIBRATE_IO
Connecting phpMyAdmin to Amazon RDS




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