Top SQL Blogs Weekly: Best of 52/2014

27.12.2015 01:04:09

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

SQL Server

SQL SERVER 2016 – New T-SQL Functions – COMPRESS and DECOMPRESS
Network Load Testing Using iPerf
SQL SERVER – Script: Remove Spaces in Column Name in All Tables
SQL SERVER – Getting to understand SQL Server Activity Monitor in SSMS
SQL SERVER – How To Improve Performance by Offloading Backups to a Secondary Replica – Notes from the Field #108

PostgreSQL

PgCenter 0.2.0 Released.
PostgreSQL Performance Observability
A Christmas present: PostgreSQL 9.5 RC1
Always Do This #2: ssl_renegotiation_limit = 0
Permissions: A little trickery

MySQL

Percona Server for MongoDB storage engines in iiBench insert workload
Better high availability: MySQL and Percona XtraDB Cluster with good application design
The State of SSL in MariaDB
MariaDB 10.1.10 and MariaDB Galera Cluster 5.5.47 and 10.0.23 now available
SSL/TLS Improvements in MySQL 5.7.10

Oracle

Memory advisors – how reliable?
Non-intrusive tracing
Recruiting for DBAs
Testing
Github Repository

Mishmash

Funnel Metrics - Step-over-Step Drop Rates
IT Salary Thought
Advent Calendar: Tip #21 – How to quickly find a table in a diagram
Advent Calendar: Tip #22 – How to identify problems with my model
Advent Calendar: Tip #23 – I only use Vertabelo occasionally. How can I pay less?




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