Top SQL Blogs Weekly: Best of 3/2016

25.01.2016 00:24:01

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

SQL Server

SQL SERVER – Dedicated Database Development with SQL Source Control
How to Get Your Very First Full Time DBA Job
SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes
Data Manipulation in R: Beyond SQL
SQL SERVER 2016 – InMemory OLTP support for Foreign Key

PostgreSQL

Postgres-XL 9.5: Gearing Towards the Beta Release
Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring
Performance limits of logical replication solutions
Solving Cache Line Contention in Large NUMA Systems
PG Phriday: Joining the Big Leagues

MySQL

Dealing with corrupted InnoDB data
Percona Live Data Performance Conference 2016: news you need to know!
MongoDB revs you up: What storage engine is right for you? (Part 3)
Tired of MySQL Making You Wait? Webinar: Questions and Answers
An update on default_password_lifetime

Oracle

Drop Column
Exporting Multiple Tables to Multiple Excel Spreadsheets
Not using binds .. banging an obsolete drum ?
Why You Can Get ORA-00942 Errors with Flashback Query
Problematic SQL ? PL/SQL is your friend.

Mishmash

Finding Nearest Neighbors in SQL
CBO Choice Between Index & Full Scan: the Good, the Bad & the Ugly Parameters
12c Online Statistics Gathering & Session Private Statistics
Demystifying WORKLOAD – System Statistics Gathering
Oracle Database Licensing with VMware




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