Top SQL Blogs Weekly: Best of 34/2015

23.08.2015 00:35:20

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

SQL Server

SQL Authority News – 100 Million and Onwards
SQL SERVER – How to Migrate Existing Database to Contained Databases
SQL SERVER – PowerShell – Knowing SQL Server Information
SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions
Why You Should Care About Microsoft APS and Azure SQL Data Warehouse

PostgreSQL

ABN AMRO Clearing: From Legacy to Postgres Plus
The People Choose PostgreSQL and EnterpriseDB’s Cloud
Waiting for 9.6 – Add new function pg_notification_queue_usage.
So, what is TABLESAMPLE actually good for?
Waiting for 9.6 – Add psql PROMPT variable showing the pid of the connected to backend.

MySQL

MariaDB Galera Cluster 10.0.21 and 5.5.45 now available
Featured Talk: The Future of Replication is Today: New Features in Practice
Adding your own collation to MySQL
How much could you benefit from MySQL 5.6 parallel replication?
Proposal to extend binary operators in MySQL

Oracle

Securing Account Details: A Story About SQL Injection and Bind Variables
Discovering Foreign Keys in Oracle SQL Developer Data Modeler
Index Usage
Loading file data … easier than you think
Script to get previous month’s AWR report

Mishmash

ORMs under the hood
Setting up Your Redshift Cluster
Designing a data model for a hotel room booking system
Top SQL Blogs Weekly: Best of 33/2015
Use an object in a query?




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