This Log Buffer Edition rides on the wave of new ideas in the database realms. From Oracle technologies through MySQL to the SQL Server, things are piping hot.
Oracle:
The Call for Papers for the Rittman Mead BI Forum 2015 is currently open, with abstract submissions open to January 18th 2015.
The replicat process is the apply process within the Oracle GoldenGate environment.
“SELECT * FROM TABLE” Runs Out Of TEMP Space.
“log file sync” and the MTTR Advisor.
Working with XML files and APEX – Part 3: Detail elements in a row with OUTER JOIN.
SQL Server:
Get started testing your database code with the tSQLt framework.
Archiving Hierarchical, Deleted Transaction Using XML.
As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences.
Free eBook: Fundamentals of SQL Server 2012 Replication
Importance of Statistics and How It Works in SQL Server – Part 1
MySQL:
Is Zero downtime even possible on RDS?
Monitor MySQL Database Users with VividCortex
Django with time zone support and MySQL
Using Perl to send tweets stored in a MySQL database to twitter
When ONLY_FULL_GROUP_BY Won’t See the Query Is Deterministic.
No comments