Top SQL Blogs Weekly: Best of 40/2015

04.10.2015 01:24:56

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

SQL Server

How to Download the Stack Overflow Database via BitTorrent
SQL SERVER – What Does WHERE 1=1 Mean in the Code?
SQL SERVER – What is Windows Internal Database Edition?
SQL SERVER – Basic architecture of Transaction Logs
SQL Server 2016 CTP2.4: Maintenance Plan Changes

PostgreSQL

Mirror Mirror on the wall, Where's the data? In my Vol
Tool Time: Integrate Postgres Into Your Data Center
Avoid naming a constraint directly when using ON CONFLICT DO UPDATE
Connecting to SQL Server from Linux using FDWs
PostgreSQL performance on ReiserFS

MySQL

Capture database traffic using the Performance Schema
HowTo: Retrieve Direct Messages From Twitter and Store Them in MySQL
Getting Started with MySQL Cluster - Hands-on Lab (HOL) - Oracle Open World (OOW) - October 29th
MySQL Sandbox, creating test environment for Group Replication plugin
MySQL Community Reception at Oracle OpenWorld

Oracle

Interim patch apply best practices in Oracle
Identifying database link usage
My sessions recommendations for JavaOne '15 and OOW '15
Designing Surrogate vs Natural Keys with Oracle SQL Developer
Master Notes

Mishmash

Understanding Distributed Analytics Databases, Part 1: Query Strategies
Create MySQL Index
A unified view on database normal forms: from the Boyce-Codd Normal Form to the Second Normal Form (2NF, 3NF, BCNF)
REGEXP_LIKE Behavior
Upcoming database conferences – October 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.