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

Get the Edge with a Professional Java IDE. 30-day free trial.

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.

Get the Java IDE that understands code & makes developing enjoyable. Level up your code with IntelliJ IDEA. Download the free trial.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}