Top SQL Blogs Weekly: Best of 41/2015

11.10.2015 00:34:24

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

SQL Server

SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
SQL SERVER – Trick – Running SSMS With Different Windows Account
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
SQL SERVER – Why Should You Not to Use Old Style JOIN?
HOW TO: Improve Database Performance Without Changing Code

PostgreSQL

2.2.0 Released!
Getting WAL files from Barman with ‘get-wal’
PostgreSQL vs. I/O schedulers (cfq, noop and deadline)
UUID vs BIGSERIAL for Primary Keys
Waiting for 9.6 – Add CASCADE support for CREATE EXTENSION.

MySQL

Using Apache Spark and MySQL for Data Analysis
When mysqld kills mysqld
Online DDL and Percona XtraDB Cluster 5.6
Advanced MySQL Server Auditing
How to Organize a Tech Conference

Oracle

What Is SQL Injection and How to Stop It
The SQL*Plus Stuff You Like and Love Lives On in SQLcl
More on XML Extensions in Oracle SQL Developer
PL/SQL Functions
From Zero to Dashboards in 10min with BICS

Mishmash

Why SQL is neither legacy, nor low-level, nor difficult, nor the wrong place for (business) data logic, but is simply awesome!
Understanding Distributed Analytics Databases, Part 2 — Data Distribution
Top SQL Blogs Weekly: Best of 40/2015
Why do you need data modeling?




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