Top SQL Blogs Weekly: Best of 33/2015

16.08.2015 00:45:19

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

SQL Server

SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol
SQL SERVER – Error while starting SQL Server logFileSize <= BlkToByteOffset ((ULONG)-1)
SQL SERVER – How to Identify Locked Table in SQL Server?
Clustered Index key columns in Nonclustered Indexes
SQL SERVER – Performance Monitoring for Analysis Services – Notes from the Field #093

PostgreSQL

Please, security test our code!
Momentous Day for Oracle Database Customers? Not Likely!
Code Transparency isn’t for the Weak
Turning xlog into json
Have problems with PostgreSQL? Try using Hive!

MySQL

The language of compression
Percona Live Amsterdam Discounted Pricing and Community Dinner!
Virtual Columns and Effective Functional Indexes in InnoDB
MySQL replication primer with pt-table-checksum and pt-table-sync
MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash

Oracle

Optimizing the PL/SQL Challenge VIII: The Importance of Testing Equivalent Queries
Recognizing Those Who Make the Oracle Design World a Better Place
Oracle 12.1.0.2c Standard Cluster: New Location / Name For Alert Log
Installing the Oracle database in docker
After startup trigger on RAC

Mishmash

Game Revenue Metrics — What Matters, and When
ColumnStore Indexes in MS SQL Server
jOOQ and Vertabelo – getting started
Top SQL Blogs Weekly: Best of 32/2015
ColumnStore Indexes




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