Top SQL Blogs Weekly: Best of 29/2015

19.07.2015 00:44:17

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

SQL Server

SQL SERVER – How to Change Server Name?
HOW TO: Recreate SQL Server Statistics In a Different Environment
13 Questions to Ask Before You Touch a Database Server
SQL SERVER – Querying Performance Counters from SQL Server
SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR

PostgreSQL

Selectively firing Postgres triggers
Postgres 9.5 feature highlight: pg_file_settings to finely track system configuration
PG Phriday: 10 Ways to Ruin Performance: Indexing the World
Transactional DDLs
Dropping columns on partitioned tables.

MySQL

MongoDB benchmark: sysbench-mongodb IO-bound workload comparison
Bypassing SST in Percona XtraDB Cluster with binary logs
MySQL QA Episode 6: Analyzing and Filtering
MySQL QA Episode 5: Preparing Your QA Run with pquery
Bypassing SST in Percona XtraDB Cluster with incremental backups

Oracle

Bloom failure
Implementing a Mutually Exclusive Relationship in the Database
How long does a logical IO take?
Locking Privileges in Oracle
Oracle Cluster Health Monitor – changes in 12.1.0.2

Mishmash

Thinking Critically About Mobile Game Retention
New search capabilities in SharePoint Server 2013-2016
7 common database design errors
Another step forward in the creation of an advanced online discussion forum
SQL Server 2016: In-Memory OLTP enhancement




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