Top SQL Blogs Weekly: Best of 46/2015

16.11.2015 15:56:01

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

SQL Server

SQL SERVER – What is SQL Server Operating System?
Interview Question of the Week #045 – How to Do Case Sensitive Search?
Announcing Our 2015 Black Friday Sale on SQL Server Training
SQL SERVER – What is T-SQL Window Function Framing? – Notes from the Field #102
SQL SERVER – Installation failed with error – Wait on the Database Engine recovery handle failed

PostgreSQL

Parallel Sequential Scan is Committed!
Parallel Sequential Scan is Committed!
My Daughter Speaks
Top 10 Steps to a Smoother Postgres Deployment
Postgres 9.6 feature highlight: operator and function pushdown with postgres_fdw

MySQL

MariaDB Connector/J failover support – case Amazon Aurora
What it's Like
Logical MySQL backup tool Mydumper 0.9.1 now available
pt-online-schema-change and innodb_stats_persistent on MySQL 5.6
Upgrading Directly from MySQL 5.0 to 5.7 using an ‘In Place’ Upgrade

Oracle

Direct path and buffered reads again: compressed tables.
Decoding DBA_TAB_COLUMNS high_value and low_value
How to Make Your Purchasing Department Want Toad as Much as You Do
A new line on NEWLINE
Histograms

Mishmash

Concatenating Rows in Redshift, Postgres, & MySQL
Modeling a Database for Recording Sales. Part 2 – Creating Tables for Products and Services
Remote Collaboration on Database Design Just Got Easier




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