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:
Hibernate’s flush behavior is not always as obvious as one might think.
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.
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.
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.
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.