• Dividing Access 2010 Databases

    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

  • Translucent modeling, and the future of internet marketing

    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 [...]

  • The latest privacy example — pregnant potential Target shoppers

    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. [...]

  • The Consumer Privacy Bill of Rights — OK but totally insufficient

    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, [...]

  • SAP HANA today

    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 [...]

  • SQL Server Pattern Matching

    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

  • Adding Passwords to Access 2010 Databases

    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

  • Third-party analytics

    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 [...]

  • The 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms — company-by-company comments

    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 [...]

  • Business intelligence industry trends

    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 [...]

  • The 2011/2012 Gartner Magic Quadrant for Business Intelligence Platforms — overview comments

    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 [...]

  • The future of enterprise application software

    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, [...]

  • Enterprise application software, past and present

    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 [...]

  • Backing Up Databases in Access 2010

    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

  • Quick notes on MySQL Cluster

    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. [...]

  • Publishing Access Forms on SharePoint

    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

  • Installing SQL Server 2008 R2 Express Edition

    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

  • Installing MySQL on Windows 7

    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

  • Mailing Labels in Microsoft Access 2010

    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

Current Feed Items | Previous Months Items

Jan 2012 | Dec 2011 | Nov 2011 | Oct 2011 | Sep 2011 | Aug 2011