• submit to reddit
Lukas Eder07/24/14
0 replies

Frightening Facts about MySQL

So, you might've seen Destroy all Software's talk about JavaScript. Well, here's a similar talk (less funny, more scary) about MySQL.

Alec Noller07/24/14
0 replies

The Best of DZone: July 17 - 23

If you missed anything on DZone this week, now's your chance to catch up! This week's best include a Spring MVC 3 view controller example, a look at the new mobile database, Realm, the Java origins of AngularJS, 5 quick points about threads in Java EE, and more.

Alec Noller07/23/14
0 replies

Dev of the Week: Pierre-Hugues Charbonneau

Every week here and in our newsletter, we feature a new developer/blogger from the DZone community. This week we're talking to Pierre-Hugues Charbonneau, Senior IT Consultant and System Architect at CGI Inc., and author of DZone's 200th Refcard: Java Performance Optimization.

Borislav Iordanov07/23/14
0 replies

Why is the Fundamental Theorem of Software Engineering Fundamental?

So you can see where I'm heading with the question posed at the title of this post. It is the reference resolution that is fundamental an indirection is simply what we do to (re)define what that resolution process ultimately looks like.

Hamid Shojaee07/23/14
0 replies

Scrum and Quantum Physics

Since Scrum is an iterative process, you can have great success by focusing on things that you can say with a fair degree of confidence, while still allowing for some uncertainty in all planning and estimates.

Ayende Rahien07/23/14
0 replies

Avoid where in a reduce clause

We got a customer question about a map/reduce index that produced the wrong results. The problem was a problem between the conceptual model and the actual model of how Map/Reduce actually works.

Peter Zaitsev07/23/14
0 replies

A Schema Change Inconsistency with Galera Cluster for MySQL

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.

Mike Bushong07/23/14
0 replies

Scenario planning for first-line managers

Almost every New Product Introduction process includes some placeholder slots to talk about risk. Everyone knows enough to put mitigation plans in these slots. But those mitigation plans are drafted and then ignored by the vast majority of managers.

Kin Lane07/23/14
0 replies

GitHub Commit Storytelling: Now or Later

When you are making GitHub commits you have to provide a story that explains the changes you are committing to a repository. Many of us just post 'blah blah’, ‘what I said last time", or any other garbage that just gets us through the moment. You know you’ve all done it at some point.

Alec Noller07/22/14
0 replies

What's to Come in Oracle Big Data SQL

We heard some interesting news regarding SQL and Big Data earlier this month, and now there's more: Oracle Big Data SQL. Even if that incredibly creative name doesn't do it for you, it looks like it should be useful as a way to connect the various Big Data technologies you might be working with.

Rob J Hyndman07/22/14
0 replies

I am not an econometrician

Econo­met­rics is often “the­ory dri­ven” while sta­tis­tics tends to be “data dri­ven”. I dis­cov­ered this in the inter­view for my cur­rent job when some­one crit­i­cized my research for being “data dri­ven” and asked me to respond.

Peter Zaitsev07/22/14
0 replies

TokuDB Tips: MySQL Backups

In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Yes, we are using Percona Server + TokuDB, along with LVM Backups. But there are some gotchas to be aware of.

Mike Cottmeyer07/22/14
0 replies

What is the ROI of Your Event?

So, where did our new event fall on a scale compared to the others? Did I feel like attendees received value and did I feel like we got a good return on our investment? Let me give a little comparison.

Dharshan Rangegowda07/21/14
0 replies

The three A's of MongoDB security - Authentication, Authorization & Auditing

MongoDB, Inc has made impressive strides over the past 18 months. One of the areas of the product that has seen the most significant improvement has been the area of Security. Security is of paramout importance for a production database. Existing relational databases provides a number of knobs and controls to help the DB administrator manage the security of his database and MongoDB is getting to a similar place as well. In this post we will delve deeper into the security features in the areas of Authentication, Authorization & Auditing.

Markus Winand07/21/14
0 replies

Finding All the Red M&Ms: A Story of Indexes and Full‑Table Scans

A common question that comes up when people start tuning queries is “why doesn’t this query use the index I expect?" There are a few myths surrounding when database optimizers will use an index. The basic decision on whether or not to use an index, though, comes down to its cost.