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

Are you joining the containers revolution? Start leveraging container management using Platform9's ultimate guide to Kubernetes deployment.

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.


Moving towards a private or Hybrid cloud infrastructure model? Get started with our OpenStack Deployment Models guide to learn the proper deployment model for your organization.


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 }}