Updated: 2012-02-28 04:51:40
You might wish to share data with users in your organization who may, in turn, wish to create their own forms and reports. While you may want them to ...Read Full Post
Updated: 2012-02-27 13:39:15
There’s a growing consensus that consumers require limits on the predictive modeling that is done about them. That’s a theme of the Obama Administration’s recent work on consumer data privacy; it’s central to other countries’ data retention regulations; and it’s specifically borne out by the recent Target-pursues-pregnant-women example. Whatever happens legally, I believe this also [...]
Updated: 2012-02-27 08:54:05
Charles Duhigg of the New York Times wrote a very interesting article, based on a forthcoming book of his, on two related subjects: The force of habit on our lives, and how we can/do deal with it. (That’s the fascinating part.) A specific case of predictive modeling. (That’s the part that’s getting all the attention. [...]
Updated: 2012-02-26 17:32:32
The Obama Administration recently released a position paper on consumer data privacy. I have mixed feelings about it. The document admirably says: Internet-related regulation should be informal, so as to maintain flexibility in the face of technological change (and, less clearly stated, government technological ignorance). Consumers should be given opt-ins and opt-outs regarding data retention, [...]
Updated: 2012-02-26 08:32:26
SAP HANA has gotten much attention, mainly for its potential. I finally got briefed on HANA a few weeks ago. While we didn’t have time for all that much detail, it still might be interesting to talk about where SAP HANA stands today. The HANA section of SAP’s website is a confusing and sometimes inaccurate [...]
Updated: 2012-02-23 04:50:59
You may often need to create a SQL Server query that performs inexact pattern matching through the use of wildcard characters. The use of wildcards allows you to find data ...Read Full Post
Updated: 2012-02-21 04:50:21
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting ...Read Full Post
Updated: 2012-02-21 00:39:06
This is one of a series of posts on business intelligence and related analytic technology subjects, keying off the 2011/2012 version of the Gartner Magic Quadrant for Business Intelligence Platforms. The four posts in the series cover: Overview comments about the 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms, as well as a link to [...]
Updated: 2012-02-21 00:38:07
This is one of a series of posts on business intelligence and related analytic technology subjects, keying off the 2011/2012 version of the Gartner Magic Quadrant for Business Intelligence Platforms. The four posts in the series cover: Overview comments about the 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms, as well as a link to [...]
Updated: 2012-02-21 00:37:54
This is one of a series of posts on business intelligence and related analytic technology subjects, keying off the 2011/2012 version of the Gartner Magic Quadrant for Business Intelligence Platforms. The four posts in the series cover: Overview comments about the 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms, as well as a link to [...]
Updated: 2012-02-21 00:37:51
This is one of a series of posts on business intelligence and related analytic technology subjects, keying off the 2011/2012 version of the Gartner Magic Quadrant for Business Intelligence Platforms. The four posts in the series cover: (This post) Overview comments about the 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms, as well as a [...]
Updated: 2012-02-17 06:38:34
Sarah Lacy argues that enterprise application software is due for a change. Her reasons seemingly boil down to: Users are increasingly eager for friendlier, consumer-like technology. The current generation of apps was installed long enough ago — often before the Year 2000 deadline — that enterprises are willing to contemplate rip-and-replace. I’m inclined to agree, [...]
Updated: 2012-02-17 06:37:58
I recently wrote a long post on the premise that enterprise analytic applications are not like the other (operational) kind. That begs the question(s): What are operational enterprise applications like? Historically, the essence of enterprise applications has been data management — they capture business information, then show it to you. User interfaces are typically straightforward [...]
Updated: 2012-02-16 05:49:29
Protecting the integrity of information stored in a database is one of the most important responsibilities of a database administrator. One task associated with this responsibility is performing regular database ...Read Full Post
Updated: 2012-02-15 23:45:44
According to the MySQL Cluster home page, today’s MySQL Cluster release has — give or take terminology details – added transparent sharding (Edit: Actually, please see the first comment below) and a memcached interface. My quick comments on all this to a reporter a couple of days ago were: Persistent memcached is a useful thing. [...]
Updated: 2012-02-14 04:15:56
In a recent forum message, tcarrier62 wrote:
"I'm trying to replace 2003 data access pages on sharepoint with access 2007 forms. With a data access page you simply saved it ...Read Full Post
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-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-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