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

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.



Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}