This Log Buffer Edition spread love of databases just before Valentine’s Day. Lovely blog posts from Oracle, SQL Server and MySQL are here for you to love.
Oracle:
Creating a Mobile-Optimized REST API Using Oracle Service Bus by Steven Davelaar.
GROUP BY – wrong results in 12.1.0.2
Using Edition-Based Redefinition to Bypass Those Pesky Triggers
It’s easy to make mistakes, or overlook defects, when constructing parallel queries – especially if you’re a developer who hasn’t been given the right tools to make it easy to test your code.
If you have a sorted collection of elements, how would you find index of specific value?
SQL Server:
How to use the IsNothing Inspection Function in SSRS
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query?
SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.
Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out.
Resilient T-SQL code is code that is designed to last, and to be safely reused by others.
MySQL:
The NoSQL databases are gaining increasing popularity. MongoDB, being one of the most established among them, uses JSON data model and offers great scalability and ease of use due to the dynamic data schemas..
Is upgrading RDS like a shit-storm that will not end?
Over the last few MySQL releases the size of the MySQL package have increased in size and it looks like the trend is continuing.
This article details the proper method of load balancing either a Percona XTRADB Cluster (PXC) or MariaDB Cluster.
One common job for a DBA is working with a Development Team member on a batch loading process that is taking more time than expected.
No comments