Updated: 2011-07-31 12:29:21
In a recent forum message, Scootered wrote:
"I grew up using MS Access while I was in the US Air Force. We used it a lot just to create static databases ...Read Full Post
Updated: 2011-07-28 05:41:32
SQL Server databases rely upon tables to store data. In this tutorial, we explore the process of designing and implementing a database table in Microsoft SQL Server.
Read ...Read Full Post
Updated: 2011-07-27 19:14:36
I spoke with Eliot Horowitz and Max Schierson of 10gen last month about MongoDB users and use cases. The biggest clusters they came up with weren’t much over 100 nodes, but clusters an order of magnitude bigger were under development. The 100 node one we talked the most about had 33 replica sets, each with [...]
Updated: 2011-07-27 13:27:04
Zettaset is confusing, but as best I understand: Zettaset sells Hadoop add-on/enhancement software, with what might be called an enterprise-friendly Hadoop management focus. “Business intelligence” gets mentioned prominently in Zettaset’s marketing, but not in what executives now say. Apparently the BI focus is old news, predating a hard pivot. Zettaset’s marketing also mentions NoSQL, for [...]
Updated: 2011-07-26 09:45:52
I refer often to machine-generated data, which is commonly generated inexpensively and in log-like formats, and is often best aggregated in a big bit bucket before you try to do much analysis on it. The term has caught on, to the point that perhaps it’s time to distinguish more carefully among different kinds of machine-generated [...]
Updated: 2011-07-26 04:40:33
Are you preparing for Microsoft Exam 70-433: SQL Server 2008 Database Development? If you'd like to become a Microsoft Certified Technical Specialist on SQL Server 2008, this exam is ...Read Full Post
Updated: 2011-07-24 12:36:51
In a recent forum message, Duncan wrote:
"I am new to Access and trying to modify an existing report so that when the Route number changes from the 100's to the ...Read Full Post
Updated: 2011-07-22 13:32:16
I talked with McObject yesterday. McObject has two product lines, both of which are something like in-memory DBMS — eXtremeDB, which is the main one, and Perst. McObject has been around since at least 2003, probably has no venture capital, and probably has a very low double-digit number of employees.* *I could be wrong in [...]
Updated: 2011-07-21 17:03:51
It's often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel's unique ...Read Full Post
Updated: 2011-07-19 06:02:42
If you're switching to Microsoft Access 2010 from an earlier version, you're bound to immediately notice some changes. If you've been using Access 2007, the ribbon-based user interface will look ...Read Full Post
Updated: 2011-07-18 06:25:27
It turns out that my impression that HBase is broken was unfounded, in at least two ways. The smaller is that something wrong with the HBase/Hadoop interface or Hadoop’s HBase support cannot necessarily be said to be wrong with HBase (especially since HBase is no longer a Hadoop subproject). The bigger reason is that, according [...]
Updated: 2011-07-17 17:00:29
In a recent forum message, TheTemp wrote:
"I would like to modify the expense tracker template with a beginning budget and not have to put separate budget amounts for each month ...Read Full Post
Updated: 2011-07-15 09:27:18
As a follow-up to the latest Stonebraker kerfuffle, Derrick Harris asked me a bunch of smart followup questions. My responses and afterthoughts include: Facebook et al. are in effect Software as a Service (SaaS) vendors, not enterprise technology users. In particular: They have the technical chops to rewrite their code as needed. Unlike packaged software [...]
Updated: 2011-07-14 12:10:34
This post has a sequel. Last week, Mike Stonebraker insulted MySQL and Facebook’s use of it, by implication advocating VoltDB instead. Kerfuffle ensued. To the extent Mike was saying that non-transparently sharded MySQL isn’t an ideal way to do things, he’s surely right. That still leaves a lot of options for massive short-request databases, however, [...]
Updated: 2011-07-14 05:56:37
As you may already know, databases use tables to organize information. (If you don't have a basic familiarity with database concepts, read What is a Database?) Each table consists of ...Read Full Post
Updated: 2011-07-12 06:49:31
Are you preparing for Microsoft Exam 70-432: SQL Server 2008 Implementation and Maintenance? If you'd like to become a Microsoft Certified Technical Specialist on SQL Server 2008, this exam ...Read Full Post
Updated: 2011-07-11 04:14:24
Hadoop is immature technology. As such, it naturally offers much room for improvement in both industrial-strengthness and performance. And since Hadoop is booming, multiple efforts are underway to fill those gaps. For example: Cloudera’s proprietary code is focused on management, set-up, etc. The “Phase 1″ plans Hortonworks shared with me for Apache Hadoop are focused [...]
Updated: 2011-07-11 04:13:36
My clients at Cloudera have been around for a while, in effect positioned as “the Hadoop company.” Their business, in a nutshell, consists of: Packaging up a Cloudera distribution of Apache Hadoop. This distribution doesn’t have proprietary code; it’s just packaged by Cloudera from Apache projects (with a decent minority of the code happening to [...]
Updated: 2011-07-11 03:13:14
I blogged a little last year about the rewards and challenges of combining professional services and software in a mature company’s business model. My main example was Oracle. But other examples from Oracle’s history might have been equally instructive. For example: Oracle started out doing what amounted to custom development for government (military/intelligence) clients. Even [...]
Updated: 2011-07-10 05:49:57
In a recent forum message, Nayer_Sh wrote:
"I have a drop down list box inside a form. I would like to see the drop down list's order in the form as ...Read Full Post
Updated: 2011-07-07 17:27:28
Sybase made a total hash of the timing of this week’s press release. I got annoyed after they promised to inform me of the new embargo time, then broke the promise. Other people got annoyed earlier than that. So be it. Below is the draft of a post I was holding, with brackets added around [...]
