Over a million developers have joined DZone.

The Best of the Week (Apr 03): SQL Zone

DZone's Guide to

The Best of the Week (Apr 03): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (April 03 - April 10), with appearances by Java 8 and MySQL.

· Database Zone ·
Free Resource

Slow SQL Server? These SentryOne resources share tips and tricks for not only troubleshooting SQL Server performance issues, but also preventing them before they hit your production environment.

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

1. How to Avoid the Dreaded Dead Lock When Pessimistic Locking - And Some Awesome Java 8 Usage!

  • Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to synchronise several applications on a shared, global lock. Some may think this is abusing the database. We think use the tools you have if they can solve the problem you have.

2. Modifying Your MySQL Structure w/o Downtime

  • Did you try to add a new index to your MySQL huge table and suffered from a downtime?

3. The Cost of Not Properly Managing Your Databases

  • Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist.

4. Using MobileFirst SQL Adapters with an Ionic Application

  • MobileFirst Adapters are server-side components that connect your hybrid mobile application to other things. Those “things” being generally broken down into a few categories, and a few specific adapter types. The SQL adapter is, as you can guess, a connection to a database.

5. Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

  • My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7″ on February 25 generated several excellent questions following the presentation. I didn’t have time to answer many of the questions during the session and so in this post I answer all of them.


Database monitoring tools letting you down? See how SentryOne empowers Enterprises to go faster.

sql ,best of the week ,database

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}