Updated: 2012-02-09 04:15:30
Microsoft SQL Server 2008 Express Edition is a free, compact version of the popular enterprise database server. The Express Edition is ideal for database professionals seeking a desktop testing ...Read Full Post
Updated: 2012-02-08 22:51:11
A reporter interviewed me via IM about how CIOs should view SAS Institute and its products. Naturally, I have edited my comments (lightly) into a blog post. They turned out to be clustered into three groups, as follows: SAS faces a number of challenges, not unlike those faced by other high-priced legacy technology vendors. It [...]
Updated: 2012-02-08 17:17:32
This year’s Gartner Magic Quadrant for Data Warehouse Database Management Systems is out.* I shall now comment, just as I did on the 2010, 2009, 2008, 2007, and 2006 Gartner Data Warehouse Database Management System Magic Quadrants, to varying extents. To frame the discussion, let me start by saying: In general, I regard Gartner Magic [...]
Updated: 2012-02-07 06:49:30
I wasn’t the only one to be dubious about Forrester Research’s Hadoop taxonomy (or lack thereof). GigaOm’s Derrick Harris was as well, and offered a much superior approach of his own. In Derrick’s view, there’s Hadoop, Hadoop distributions, Hadoop management, and Hadoop applications. Taking those out of order, and recalling that no market categorization is [...]
Updated: 2012-02-07 04:42:41
The MySQL database server is one of the most popular open source databases in the world. Although administrators typically install MySQL on a server operating system, it's certainly possible to ...Read Full Post
Updated: 2012-02-07 03:18:25
My clients at Odiago, vendors of WibiData, have changed their company name simply to WibiData. Even better, they blogged with more detail as to how WibiData works, in what is essentially a follow-on to my original WibiData post last October. Among other virtues, WibiData turns out to be a poster child for my views on [...]
Updated: 2012-02-06 13:27:06
I talked with the Sumo Logic folks for an hour Thursday. Highlights included: Sumo Logic does SaaS (Software as a Service) log management. Sumo Logic is text indexing/Lucene-based. Thus, it is reasonable to think of Sumo Logic as “Splunk-like”. (However, Sumo Logic seems to have a stricter security/trouble-shooting orientation than Splunk, which is trying to [...]
Updated: 2012-02-06 05:16:20
Forrester has released its Q1 2012 Forrester Wave: Enterprise Hadoop Solutions. (Googling turns up a direct link, but in case that doesn’t prove stable, here also is a registration-required link from IBM’s Conor O’Mahony.) My comments include: The Forrester Wave’s relative vendor rankings are meaningless, in that the document compares apples, peaches, almonds, and peanuts. [...]
Updated: 2012-02-02 19:58:00
Jump to Content Jump to Navigation Jump to Footer Login Join TechSoup About TechSoup Register Organization How To Use TechSoup : Keywords Please go to Get Products page to search when javascript is disabled Register for Product Donations Get Started Home Learning Center Get Products Community Blog Libraries Donate Technology Digital Catalog Check Eligibility Find Your Country : Link Select . Australia Belgium Botswana Brazil Bulgaria Canada Chile Croatia Czech Republic Egypt France Germany Hong Kong Hungary India Ireland Italy Japan Kenya Luxembourg Macau Mexico Netherlands New Zealand Poland Romania Russia Slovakia Slovenia South Africa Spain Sweden Taiwan United Kingdom USA All TechSoup Partners In Community Discussion Forums TechSoup Blog Events Social Media 101 Second Life Soup Recipes
Updated: 2012-02-02 04:12:15
One of the most common uses of a database is generating mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in ...Read Full Post
Updated: 2012-02-02 04:00:24
I checked in with James Phillips for a Couchbase update, and I understand better what’s going on. In particular: Give or take minor tweaks, what I wrote in my August, 2010 Couchbase updates still applies. Couchbase now and for the foreseeable future has one product line, called Couchbase. Couchbase 2.0, the first version of Couchbase [...]
Updated: 2012-01-31 13:00:59
I had the privilege to be a guest blogger on the ODTUG blog. I wrote about Kscope and my role in putting together the Developer’s Toolbox track as well as why you should attend Kscope. Here is a short excerpt: This year’s Kscope is a special one to me. I volunteered to lead the Developer’s [...]
Updated: 2012-01-31 04:24:13
In a recent forum message, MRTK2012 wrote:
"Could anyone please let me know how to append a wildcard in bcp file to insert
data into database?
In the below example I want ...Read Full Post
Updated: 2012-01-26 04:03:22
With the release of SQL Server 2008, Microsoft included Change Data Capture (CDC) functionality for the first time. This highly anticipated feature provides administrators with the ability to perform ...Read Full Post
Updated: 2012-01-25 16:47:59
I believe IT departments should support and encourage departmental analytics efforts, where “support” and “encourage” are not synonyms for “control”, “dominate”, “overwhelm”, or even “tame”. A big part of that is: Let, and indeed help, departments have the data they want, when they want it, served with blazing performance. Three things that absolutely should NOT [...]
Updated: 2012-01-24 16:57:19
Martin Widlake thinks so: Comments are great, you can put 4000 characters of information into the database about each table, view and column. This can be a brief description of the object, a full explanation of what a column is to hold or even a list of typical entries for a column or table. But [...]
Updated: 2012-01-24 14:42:34
Microsoft is launching SQL Server 2012 on March 7. An IM chat with a reporter resulted, and went something like this. Reporter: [Care to comment]? CAM: SQL Server is an adequate product if you don’t mind being locked into the Microsoft stack. For example, the ColumnStore feature is very partial, given that it can’t be [...]
Updated: 2012-01-24 04:23:00
In a recent forum message, Kulashnikov24 wrote:
"I am creating a database for my contacts in which I intend to store their visiting details with date and time and also want ...Read Full Post
Updated: 2012-01-23 14:29:06
Department-level adoption of analytic technology isn’t the exception; it’s the norm. Reasons include: Many analytic challenges are inherently departmental. In many cases, central IT control of analytics isn’t needed. Departments move ahead without central approval or involvement because they can. That said, arguments for centralizing analytic technology include: A lot of data is used by [...]
Updated: 2012-01-19 04:57:11
Foreign key constraints allow you to create relationships between data elements stored in multiple database tables. In addition to facilitating cross-table database queries (called JOINs), these relationships also ensure ...Read Full Post</p
Updated: 2012-01-17 08:02:18
This post is part of a short series on the history of analytics, covering: Historical notes on analytics — the pre-computer era Historical notes on analytic terminology (this post) Historical notes on analytics — departmental adoption Discussions of the history of analytic technology are complicated by the broad variety of product category names that have [...]
Updated: 2012-01-17 04:21:44
In a recent forum message, Maru314 wrote:
"I recently had to normalize the attached table for my final exam of my database course. I got really turned around because all ...Read Full Post
