Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

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

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

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.


Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.

Topics:

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}