• Counting SQL Result Rows

    Updated: 2012-03-29 06:46:44
    SQL provides the COUNT function to retrieve the number of records in a table that meet given criteria. We can use the COUNT(*) syntax alone to retrieve the number ...Read Full Post

  • DataStax Enterprise and Cassandra revisited

    Updated: 2012-03-27 20:46:03
    My last post about DataStax Enterprise and Cassandra didn’t go so well. As follow-up, I chatted for two hours with Rick Branson and Billy Bosworth of DataStax. Hopefully I can do better this time around. For starters, let me say there are three kinds of data management nodes in DataStax Enterprise: Vanilla Cassandra. Cassandra plus [...]

  • Timestamping Database Records

    Updated: 2012-03-27 05:46:12
    There are many applications where you may wish to add a date/time stamp to each record, identifying the time that the record was added to the database. It's easy ...Read Full Post

  • CodeFutures/dbShards update

    Updated: 2012-03-26 12:42:52
    I’ve been talking a fair bit with Cory Isaacson, CEO of my client CodeFutures, which makes dbShards. Business notes include: 7 production users, plus an 8th imminent. 12-14 signed contracts beyond that. ~160 servers in production. One customer who has almost 15 terabytes of data (in the cloud). Still <10 people, pretty much all engineers. [...]

  • Notes on the ClearStory Data launch, including an inaccurate quote from me

    Updated: 2012-03-26 10:03:33
    ClearStory Data launched, with nice coverage in the New York Times, Computerworld, and elsewhere. But from my standpoint, there were some serious problems: (Bad.) I was planning to cover the launch as well, in a split exclusive, but that plan was changed, costing me considerable wasted work. (Worse.) I wasn’t told of the change as [...]

  • Service Desk Database

    Updated: 2012-03-22 05:45:32
    Looking for a database to track service calls for your business? Microsoft offers a free Service Call Management Database Template for users of Access 2003 (or later). This ...Read Full Post

  • DataStax Enterprise 2.0

    Updated: 2012-03-21 08:20:45
    Edit: Multiple errors in the post below have been corrected in a follow-on post about DataStax Enterprise and Cassandra. My client DataStax is announcing DataStax Enterprise 2.0. The big point of the release is that there’s a bunch of stuff integrated together, including at least: Cassandra — the NoSQL DBMS, which DataStax sometimes calls “DataStax [...]

  • Comments on Oracle’s third quarter 2012 earnings call

    Updated: 2012-03-21 07:42:38
    Various reporters have asked me about Oracle’s third quarter 2012 earnings conference call. Specific Q&A includes: What did Oracle do to have its earnings beat Wall Street’s estimates? Have a bad second quarter and then set Wall Street’s expectations too low for Q3. This isn’t about strong results; it’s about modest expectations. Can Oracle be [...]

  • Backup Compression in SQL Server 2012

    Updated: 2012-03-20 04:42:58
    Administrators may wish to take advantage of SQL Server's backup compression capabilities. This feature, only available in the Enterprise Edition of SQL Server 2008, is now available to Standard Edition ...Read Full Post

  • Akiban update

    Updated: 2012-03-19 10:06:52
    I have a bunch of backlogged post subjects in or around short-request processing, based on ongoing conversations with my clients at Akiban, Cloudant, Code Futures (dbShards), DataStax (Cassandra) and others. Let’s start with Akiban. When I posted about Akiban two years ago, it was reasonable to say: Akiban is in the short-request DBMS business. MySQL [...]

  • Juggling analytic databases

    Updated: 2012-03-16 10:09:03
    I’d like to survey a few related ideas: Enterprises should each have a variety of different analytic data stores. Vendors — especially but not only IBM and Teradata — are acknowledging and marketing around the point that enterprises should each have a number of different analytic data stores. In addition to having multiple analytic data [...]

  • Getting the Most Out of Microsoft Access

    Updated: 2012-03-15 07:23:20
    Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the ...Read Full Post

  • The Power of SQL

    Updated: 2012-03-13 16:19:43
    Frank Zhou recently posted these entries on OraQA.com: How to transform a RefCursor query resultset into HTML table in SQL How to convert a RefCursor query resultset to CSV format in SQL How to transform a CSV file into HTML table in SQL How to transform a database table dataset into HTML table in SQL [...]

  • Free Genealogy Database

    Updated: 2012-03-13 05:24:39
    Are you interested in tracing your family roots but don't have a good place to store all of your genealogical information? While there are several full-featured family tree software packages ...Read Full Post

  • How to Download BLOB Content as a File Using Oracle Application Express

    Updated: 2012-03-12 13:00:02
    In a previous article, you learned how to create a simple Oracle Application Express application to store the content of any file into a BLOB column in the database. In this article, you will learn how to include in a report a file download link to the content stored in a BLOB column. If the [...]

  • Kinds of data integration and movement

    Updated: 2012-03-12 08:53:50
    “Data integration” can mean many different things, to an extent that’s impeding me from writing about the area. So I’ll start by simply laying out some of the myriad ways that data can be brought to where it is needed, and worry about other subjects later. Yes, this is a massive wall of text, and [...]

  • Here’s What You May Have Missed This Week

    Updated: 2012-03-10 19:09:22
    An introduction to MVC Ajax with jQuery: A Beginner’s Guide How to Hire a Programmer The 10 commandments of good source control management ACID vs. BASE: The Shifting pH of Database Transaction Processing Application vs Database Programming Filenames and Pathnames in Shell: How to do it correctly The Day Programmer vs. The Night Programmer Linux [...]

  • Product Comparison Raima

    Updated: 2012-03-10 08:51:28
    1.206.748.5300 44.1628.826.800 Support Login Collect , Store , Manage Move Data What We Do Products Services Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Developer Tools Downloads User Forum Online Documentation Maintenance and Support Videos and Webinars Whitepapers Partners Resellers Technical Partners Company About Us Management News Press Releases Newsletters RSS News Feed Blog Careers Contact Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Download Product Overview Compare our database management system solutions with high-availability and in-memory . capabilities RDM System RDM 11, or the RDM System , : includes RDM Mobile Edition RDM Embedded Edition RDM

  • Mobile Database System Software RDM Mobile Raima

    Updated: 2012-03-10 08:51:27
    1.206.748.5300 44.1628.826.800 Support Login Collect , Store , Manage Move Data What We Do Products Services Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Developer Tools Downloads User Forum Online Documentation Maintenance and Support Videos and Webinars Whitepapers Partners Resellers Technical Partners Company About Us Management News Press Releases Newsletters RSS News Feed Blog Careers Contact Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Download Available March 16, 2012 RDM Mobile Edition RDM Mobile Edition is a high-performance , database management system ideal for the developer who is creating a standalone application for a smart phone or tablet device

  • RDM Embedded Edition Embedded Database Management System Raima

    Updated: 2012-03-10 08:51:26
    1.206.748.5300 44.1628.826.800 Support Login Collect , Store , Manage Move Data What We Do Products Services Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Developer Tools Downloads User Forum Online Documentation Maintenance and Support Videos and Webinars Whitepapers Partners Resellers Technical Partners Company About Us Management News Press Releases Newsletters RSS News Feed Blog Careers Contact Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Download Available March 16, 2012 RDM Embedded Edition RDM Embedded Edition is a high-performance , database management system optimized for the operating systems commonly used within the embedded market . It is ideal for

  • Client Server DBMS for High-Performance RDM Workgroup Raima

    Updated: 2012-03-10 08:51:25
    1.206.748.5300 44.1628.826.800 Support Login Collect , Store , Manage Move Data What We Do Products Services Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Developer Tools Downloads User Forum Online Documentation Maintenance and Support Videos and Webinars Whitepapers Partners Resellers Technical Partners Company About Us Management News Press Releases Newsletters RSS News Feed Blog Careers Contact Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Download RDM Workgroup RDM Workgroup Edition is a high-performance , database management system optimized for the operating systems commonly used within the desktop and server environments It is ideal for standalone and

  • Enterprise Lite Database Management System Raima

    Updated: 2012-03-10 08:51:24
    1.206.748.5300 44.1628.826.800 Support Login Collect , Store , Manage Move Data What We Do Products Services Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Developer Tools Downloads User Forum Online Documentation Maintenance and Support Videos and Webinars Whitepapers Partners Resellers Technical Partners Company About Us Management News Press Releases Newsletters RSS News Feed Blog Careers Contact Product Overview Mobile Embedded Desktop Server Enterprise Lite Maintenance and Support Professional Services Download RDM Server RDM Server is Raima’s extremely powerful Client Server database management system , perfectly designed for business-critical applications that need a higher degree of server horse power that provides

  • Hardware and components — lessons from Teradata

    Updated: 2012-03-09 07:32:53
    I love talking with Carson Schmidt, chief of Teradata’s hardware engineering (among other things), even if I don’t always understand the details of what he’s talking about. It had been way too long since our last chat, so I requested another one. We were joined by Keith Muller, who I presume is pictured here. Takeaways [...]

  • SQL Server Distributed Management Framework

    Updated: 2012-03-08 04:22:00
    Policy objects specify the conditions you wish to enforce against database targets using the Distributed Management Framework (DMF). In this tutorial, we create a DMF policy that enforces the stored ...Read Full Post

  • Help a Soldier with a Database

    Updated: 2012-03-06 05:19:42
    In a recent forum message, SSgt Carol Miller wrote: "I'm working on a tracking Form in Access 2007. And I'm trying to get Conditional Formatting to highlight the field for ...Read Full Post

Current Feed Items | Previous Months Items

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