Over a million developers have joined DZone.

The Best of the Week (Oct. 31): SQL Zone

DZone's Guide to

The Best of the Week (Oct. 31): SQL Zone

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

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

1. Hibernate Collections Optimistic Locking

  • Hibernate provides an optimistic locking mechanism to prevent lost updates even for long-conversations.

2. MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

  • Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, but here are all the questions with my complete answers

3. Facebook MySQL database engineers ready for Percona Live London 2014

  • I spoke with Facebook database engineers Yoshinori “Yoshi” Matsunobu and Shlomo Priymak about their upcoming sessions along with what’s new at Facebook since our last conversation back in April.

4. Understanding the Execution Plan [When Table JOIN occurs Part-I]

  • In my previous article we are just using a single table as per our example is concern, Now in this article we are going to see the different table join each other’s and make a single data set by using JOIN.

5. Back to Learning Grammar with ANTLR

  • This post is going to be about language processing. Language processing could be anything like an arithmetic expression evaluator, a SQL parser or even a compiler or interpreter. Many times when we build user facing products, we give users a new language to interact with the product.


It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate


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