Over a million developers have joined DZone.

The Best of the Week (Dec. 05): SQL Zone

DZone's Guide to

The Best of the Week (Dec. 05): SQL Zone

· Java Zone
Free Resource

Bitbucket is for the code that takes us to Mars, decodes the human genome, or drives your next car. What will your code do? Get started with Bitbucket today, it's free.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (December 05 - December 12). Here they are, in order of popularity:

1. Bulk Update/Delete using the Criteria API in JPA 2.1/Java EE 7

  • It has long been possible to do bulk updates and deletes using JPQL in JPA.

2. MySQL Replication Over Slow Links/High Latency

  • MySQL replication is considered to be efficient and usually changes in the master server are performed in the slaves within a single second.

3. Registering Doctrine Type Mappings for Standalone Migrations

  • Shortly after starting to use Doctrine Migrations as a standalone tool in my project, I came across this error message...

4. Avoiding MySQL ALTER Table Downtime

  • MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall.

5. Azure SQL Database Creation Made Easy

  • Microsoft Azure product team recently extended the database creation workflow in the preview Azure management portal to support two new scenarios namely create from sample and create from backup.


Bitbucket is the Git solution for professional teams who code with a purpose, not just as a hobby. Get started today, it's free.


Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


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

{{ parent.tldr }}

{{ parent.urlSource.name }}