• Transferring Data Between Access and Excel

    Updated: 2011-10-27 05:23:10
    Microsoft Excel and Microsoft Access are both powerful tools for handling large quantities of data within the Microsoft Office suite. Often, you might find yourself needing to move data ...Read Full Post

  • Where Datameer is positioned

    Updated: 2011-10-25 22:53:31
    I’ve chatted with Datameer a couple of times recently, mainly with CEO Stefan Groschupf, most recently after XLDB last Tuesday. Nothing I learned greatly contradicts what I wrote about Datameer 1 1/2 years ago.  In a nutshell, Datameer is designed to let you do simple stuff on large amounts of data, where “large amounts of [...]

  • What File Format Does Microsoft Access Use?

    Updated: 2011-10-25 05:16:28
    Wondering what file format Microsoft Access uses to store your database? It actually depends upon the version of Microsoft Access you're using and the particular way you've created your ...Read Full Post

  • Big Data and the Cloud: What's the Link?

    Updated: 2011-10-25 01:46: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 Egypt France Germany Hong Kong Hungary India Ireland 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 TechSoup Surveys Events Facebook Second Life Soup Recipes Connect

  • NoSQL notes

    Updated: 2011-10-24 05:20:27
    Last week I visited with James Phillips of Couchbase, Max Schireson and Eliot Horowitz of 10gen, and Todd Lipcon, Eric Sammer, and Omer Trajman of Cloudera. I guess it’s time for a round-up NoSQL post. Views of the NoSQL market horse race are reasonably consistent, with perhaps some elements of “Where you stand depends upon [...]

  • Transparent relational OLTP scale-out

    Updated: 2011-10-24 05:19:09
    There’s a perception that, if you want (relatively) worry-free database scale-out, you need a non-relational/NoSQL strategy. That perception is false. In the analytic case it’s completely ridiculous, as has been demonstrated by Teradata, Vertica, Netezza, and various other MPP (Massively Parallel Processing) analytic DBMS vendors. And now it’s false for short-request/OLTP (OnLine Transaction Processing) use [...]

  • Schooner pivots further

    Updated: 2011-10-24 05:18:11
    Schooner Information Technology started out as a complete-system MySQL appliance vendor. Then Schooner went software-only, but continued to brag about great performance in configurations with solid-state drives. Now Schooner has pivoted further, and is emphasizing high availability, clustered performance, and other hardware-agnostic OLTP (OnLine Transaction Processing) features. Fortunately, Schooner has some interesting stuff in those [...]

  • More notes on Oracle NoSQL

    Updated: 2011-10-20 16:49:31
    A reporter asked me for some thoughts on Oracle’s new NoSQL product. For the most part, I stand by my previous comments on Oracle NoSQL. Still, NoSQL in general deserves a place in Oracle shops, so it makes sense for Oracle to try to coopt it. Oracle’s core DBMS is not well suited to track [...]

  • SQL Server Constraints

    Updated: 2011-10-20 05:20:25
    Database constraints provide you with a way to enforce business logic within your database. In this series of articles, we explore the constraints available to you within Microsoft SQL ...Read Full Post

  • What those nested data structures are about

    Updated: 2011-10-19 18:29:59
    As I’ve noted before, the very big web companies have an issue with nested data structures. The subject came up in XLDB talks yesterday too, so my big goal for lunch was to finally understand what was being talked about. Sitting at a table full of eBay and LinkedIn folks turned out to be a [...]

  • Oracle is buying Endeca

    Updated: 2011-10-18 17:09:56
    Oracle is buying Endeca. The official talking points for the deal aren’t a perfect match for Endeca’s actual technology, but so be it. In that post, I wrote: … the Endeca paradigm is really to help you make your way through a structured database, where different portions of the database have different structures. Thus, at [...]

  • Vertica Community Edition

    Updated: 2011-10-18 16:48:10
    The press release announcing Vertica’s Community Edition is a bit vague. And indeed, much of what I know about Vertica Community Edition is along the lines of “This is what I think will happen, but of course it could still change.” That said, I believe: Vertica Community Edition has all of regular Vertica’s features. However [...]

  • Pivot Tables Tutorial

    Updated: 2011-10-18 05:15:52
    Pivot tables offer an inexpensive and easy solution to those who need some of the power of a database within the familiar environment of a spreadsheet package. Both Microsoft ...Read Full Post

  • Commercial software for academic use

    Updated: 2011-10-14 07:21:21
    As Jacek Becla explained: Academic scientists like their software to be open source, for reasons that include both free-like-speech and free-like-beer. What’s more, they like their software to be dead-simple to administer and use, since they often lack the dedicated human resources for anything else. Even so, I think that academic researchers, in the natural [...]

  • Compression in Sybase ASE 15.7

    Updated: 2011-10-14 05:29:18
    Sybase recently came up with Adaptive Server Enterprise 15.7, which is essentially the “Make SAP happy” release. Features that were slated for 2012 release, but which SAP wanted, were accelerated into 2011. Features that weren’t slated for 2012, but which SAP wanted, were also brought into 2011. Not coincidentally, SAP Business Suite will soon run [...]

  • SQL Server Versions

    Updated: 2011-10-13 05:30:52
    Wondering what version of Microsoft SQL Server 2008 is right for your needs? It might be difficult to choose between the many options available to you: SQL Server Standard Edition SQL Server Express Edition SQL Server Workgroup SQL Server Enterprise Edition SQL Server Data Center Edition SQL Server Parallel Data Warehouse Edition SQL Server Developer Edition SQL Server WebSQL Server Compact ...Read Full Post

  • Pivot Tables in Google Spreadsheets

    Updated: 2011-10-11 05:26:35
    Google Docs now offers pivot table functionality that rivals the features found in Microsoft Excel. Read more: Pivot Tables in Google Spreadsheets Related ...Read Full Post

  • Movie Collection Database

    Updated: 2011-10-06 05:46:32
    Looking for a way to organize your movie collection? This Microsoft Access 2010 Movie Collection Database Template provides you with the ability to track your collection by format, reviews ...Read Full Post

  • just::thread C++0x Thread Library V1.7.0 Released

    Updated: 2011-10-05 08:36:52
    : , J ust S oftware S olutions Call Us on 0845 053 0 350 Or email us for Custom Software Development Buy just : thread C++0x Thread Library . Download and get started today About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives October 2011 1 August 2011 1 June 2011 2 May 2011 1 April 2011 1 March 2011 1 February 2011 1 January 2011 1 2010 24 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site

  • Pivot Tables in Excel 2010

    Updated: 2011-10-04 05:40:17
    Pivot tables provide a powerful data analysis tool embedded within your current spreadsheet software. They offer the ability to summarize data without the use of a relational database or aggregate ...Read Full Post

Current Feed Items | Previous Months Items

Sep 2011 | Aug 2011 | Jul 2011 | Jun 2011 | May 2011 | Apr 2011