Over a million developers have joined DZone.

The Best of the Week (Aug. 8): SQL Zone

DZone's Guide to

The Best of the Week (Aug. 8): SQL Zone

· Java Zone ·
Free Resource

Java-based (JDBC) data connectivity to SaaS, NoSQL, and Big Data. Download Now.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (August 8 to 14). Here they are, in order of popularity:

1. A Beginner's Guide To JPA/Hibernate Flush Strategies

Hibernate’s flush behavior is not always as obvious as one might think.

2. Avoid Hibernate Anemia and Reduce Code Bloat

One of my beefs with Hibernate as an ORM is that it encourages anemic domain models that have no operations and are simply data structures.

3. Math and SQL Part 3: MVCC, Immutability, and Functional Programming

While first normal form is pretty much restricted to relational operations, this piece is more general. It looks at the basic promise of functional programming, and the way that this applies to PostgreSQL. In the mean time, we will also look at a fully functional approach to a key-value store in Perl as a close analogue.

4. dm_exec_query_plan Returning NULL Query Plan

I recently hit a scenario (SQL Server 2012 Standard, 11.0.5058) where I was trying to pull out the execution plan for a stored procedure from the plan cache, but one query was returning a NULL query plan.

5. MySQL Find and Replace (REPLACE)

Ever had need to do a MySQL find and replace to quickly replace some data in your database? Fear not, MySQL has a nifty little string function, REPLACE, that allows a user to find and replace instances of a search string with a substitution string.

Connect any Java based application to your SaaS data.  Over 100+ Java-based data source connectors.


Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}