(Troy Coleman) I recently returned from the IDUG 2011 North America conference in Anaheim. It was a great conference, and I wanted to share a bit about the keynote speech by Jeff Jonas.
Other News
The different ways of doing HA in MySQL
(Henrik Ingo) A week ago Baron wrote a blog post which can only be described as the final nail in the coffin for MMM. At MySQL AB we never used or recommended MMM as a High Availability solution. I never really asked about details about that, but surely one reason was that it is based on using the M
Punctuation in XPath, Part 1: dot (“.”)
(Evan Lenz) When you write XQuery, a large subset of what you’re writing is actually XPath 2.0. In fact, XQuery 1.0 is defined formally as an extension to, or superset of, XPath 2.0.
WCF 4.0 Features: Part 1
(Dhananjay Kumar) WCF 4 comes with many new features for a better developer experience. There is a high integration with workflow service.
Overview of WITH RESULT SETS Feature of SQL Server Denali
(Ashish Kumar Mehta) While looking through the new features and improvements in SQL Server Denali, we found a potentially interesting feature WITH RESULT SETS. This is a very useful feature especially when one needs to display a result set of a stored procedure by changing the names and data types o
Compensating for Bad Schema
Compensating for Bad Schema Most of the items from the bad things to do in a database survey were pretty straight forward. I find it interesting that the item receiving the most votes for bad things to do was also one of the items I received the most questions regarding it’s meaning, “Compensating for Bad Schema.” There are a number […]
Introducing MySQL to MongoDB Replication
(Robert Hodges) The last article on this blog described our planned MySQL to MongoDB replication hackathon at the recent Open DB Camp in Sardinia. Well, it worked, and the code is now checked into the Tungsten Replicator project.
Computing PERCENTILE
(Serge Rielau) I should know better than you answer “Sure!” when someone asks me if I have a “few minutes” for a “quick SQL question”.
Some Nuggets from IDUG in the OC, Part 1
(Robert Catterall) That’s OC as in Orange County, California, where you’ll find Anaheim, site of the 2011 International DB2 Users Group North American Tech Conference. The conference wrapped up on May 6, and herein I have items of information gleaned from some of the sessions I attended (posting del
ASSM bug reprise – part 2
(Randolf Geist) In the first part of this post I’ve explained some of the details and underlying reasons of bug 6918210. The most important part of the bug is that it can only be hit if many row migrations happen during a single transaction. However, having excessive row migrations is usually a sign