As you probably know, I have been doing RDBMS work for many years, some
25+ years by now. At Recorded Future I am the database architect, and
although an RDBMS is used extensively, MySQL in this case, we are
looking at options, and are currently doing more...
1 replies - 3229 views - 12/01/11 by Anders Karlsson in Articles
There are a lot of considerations for deploying MySQL in the Cloud.
Some concepts and details won't be obvious to DBAs used to deploying on
traditional servers. Here are eight best practices which will
certainly set you off on the right foot.**...
1 replies - 3596 views - 11/10/11 by Sean Hull in Articles
Once a development or operations team gets over the hurdle of
open-source, and start to feel comfortable with the way software works
outside of the enterprise world, they will likely start to settle in and
feel comfortable. Fear not, there are more...
0 replies - 3697 views - 09/21/11 by Sean Hull in News
There are a lot of scalability challenges we see with clients over
and over. The list could easily include 20, 50 or even 100 items, but
we shortened it down to the biggest five issues we see.
1. Tune those queries
0 replies - 6168 views - 07/31/11 by Sean Hull in News
In a blog post following a recent report by the 451 Group, Matthew Aslett, a senior
analyst for the research firm, defines the term “NewSQL”
as a new breed of SQL database-related products.
0 replies - 4469 views - 07/01/11 by Razi Sharir in News
Matt Aslett from the 451 group created a term called “NewSQL”. On the definition of NewSQL, Aslett writes:
“NewSQL” is our shorthand for the various new
scalable/high performance SQL database vendors. We have previously
referred to these products as...
0 replies - 7227 views - 04/08/11 by Liran Zelkha in News
What does 2011 hold for
your database? Below are our main predictions for the year ahead:
Database models and alternatives settle back on SQL
2 replies - 5311 views - 04/05/11 by Razi Sharir in News
This is a guest post by Baron Schwartz that was posted on Peter Zaitsev's blog
0 replies - 5535 views - 03/01/11 by Peter Zaitsev in News
Java is a great language. It manages memory for you, teaches us about
object-oriented programming, and makes us better coders as we use it.
Plus, it really is a ‘write once, run anywhere’ language. Nonetheless,
Java applications can run into a few...
6 replies - 12267 views - 12/22/10 by Bhaskar Sunkara in Articles
It was two years ago when Sun released MySQL 5.1. Today the open source project's formidable user base will finally get the next major release, MySQL 5.5. The first major version produced by Oracle includes InnoDB by default, SIGNAL/RESIGNAL support for...
0 replies - 24481 views - 12/17/10 by Mitchell Pronsc... in Daily Dose
I wrote couple of weeks ago on dangers
of bad cache design. Today I’ve been troubleshooting the production
down case which had fair amount of issues related to how cache was
used.
The deal was as following. The update to the codebase was performed
and...
0 replies - 4518 views - 11/24/10 by Peter Zaitsev in News
I recently mentioned a
few of the big “non-starter” limitations Postgres has overcome for
specific use cases. I decided to write a series of blog posts on
MySQL’s unsolved severe limitations. I mean limitations that really
hobble it for major,...
0 replies - 5508 views - 11/15/10 by Peter Zaitsev in News
Google presented a new document to the court in the Oracle-Android case. In the document, Google says that they did not copy Oracle's Java APIs and that Oracle had revised or deleted essential passages in the evidence that attempts to prove Google's...
0 replies - 22716 views - 11/13/10 by Mitchell Pronsc... in Daily Dose
#10. Searching for a NULL
SELECT *FROM aWHERE a.column = NULL
In SQL, a NULL is never equal to anything, even another NULL. This query won’t return anything and in fact will be thrown out by the optimizer when building the plan.
3 replies - 9739 views - 11/12/10 by Alex Bolenok in News
Here's a typical problem that results from "SQL Hegemony" -- all data
must be in a database, and all access must be via SQL. This can also be
called the "SQL Fetish" school of programming.War Story.
On a Data Warehousing project, we...
12 replies - 6798 views - 10/01/10 by Steven Lott in News
This article is part of the DZone NoSQL Resource Portal, which is brought to you in collaboration with 
