Top SQL Blogs Weekly: Best of 23/2015

07.06.2015 01:08:45

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

SQL Server

How to Set Up Standard Edition AlwaysOn Availability Groups in SQL Server 2016
SQL SERVER – FIX – Msg 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use
SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)
Features SQL Server Needs to Add (And Drop)
SQL SERVER – Finding Out Identity Column Without Using Column Name

PostgreSQL

PG Phriday: 10 Ways to Ruin Performance: Cast Away
Goodbye jsonb_replace, hello jsonb_set
How to write fast database applications?
DROP TABLE: Killing shared_buffers
Blackhole FDW updated

MySQL

New PERFORMANCE_SCHEMA defaults in MySQL 5.7.7
Optimizing Percona XtraDB Cluster for write hotspots
Is 80% of RAM how you should tune your innodb_buffer_pool_size?
High availability using MySQL in the cloud
Percona TokuMXse 3.0.3-1.0-rc6 is now available

Oracle

Everything you ever wanted to know about the PL/SQL Debugger
Query Tuning 101: Comparing Execution Plans and Access vs. Filter Predicates
Infographic: Oracle SQL Developer Data Grid Features
PMML in Oracle Data Mining
Untrusted X11 forwarding

Mishmash

10 Rules for a Better SQL Schema
PostgreSQL database replication
Ways to improve your SharePoint Intranet
Spider Schema – a bridge between OLTP and OLAP?
Recap SharePoint Event Paris 2015




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