• Greenplum Single-Node Edition — sometimes free is a real cool price

    Updated: 2009-10-19 07:25:41
    Greenplum is announcing today that you can run Greenplum software on a single 8-core commodity server, free. First and foremost, that’s a strong statement that Greenplum wants enterprises to pay it for Greenplum’s parallelization/”private cloud” capabilities. Second, it may be an attractive gift to a variety of folks who want to extract insight from [...]

  • This week at the Teradata Partners user conference

    Updated: 2009-10-19 07:07:31
    Teradata tells me that its press embargoes are ending at 9:00 this morning. Here are some highlights of what’s going on, although names, dates, and details will have to await conversations and press releases this week. Teradata is productizing “private cloud,” under names including “Teradata Enterprise Analytics Cloud,” “Teradata Agile Analytics Cloud,” and “Teradata Elastic Mart [...]

  • Writing SQL Queries in Access 2007

    Updated: 2009-10-18 19:54:01
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Writing SQL Queries in Access 2007 Sunday October 18, 2009 In a recent forum message BooIsMyCat wrote : I have a table named tblantennadatanodups that has fields tagid date time and number of fish I also have a user interface where a listbox is present with tagids . Please help me with the SQL query to display the row containing the tagid when the user clicks on any ID . Do you have any advice Interested in solutions to the same problem Visit the About Databases Forum and join the . conversation Comments 0 See All Posts Prev Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Keys Discuss Recent Blog Posts Writing SQL Queries in Access 2007 Backing up a SQL Server

  • Greenplum customer notes

    Updated: 2009-10-18 10:44:18
    In a briefing about a forthcoming product announcement, Greenplum threw in a slide saying: Greenplum is getting 12-15 new (paying) customers per quarter, all of whom it fondly refers to as “Tier 1″ enterprises. Greenplum will hit the 100+ customer mark this quarter (thus joining Vertica and Infobright). <10% of Greenplum business is now “influenced” by Sun hardware. I [...]

  • Three big myths about MapReduce

    Updated: 2009-10-18 10:14:37
    Once again, I find myself writing and talking a lot about MapReduce. But I suspect that MapReduce-related conversations would go better if we overcame three fairly common MapReduce myths: MapReduce is something very new MapReduce involves strict adherence to the Map-Reduce programming paradigm MapReduce is a single technology So let’s give it a try. When Dave DeWitt and Mike [...]

  • Introduction to SenSage

    Updated: 2009-10-18 10:02:42
    I visited with SenSage on my two most recent trips to San Francisco. Both visits were, through no fault of SenSage’s, hasty. Still, I think I have enough of a handle on SenSage basics to be worth writing up. General SenSage highlights include: SenSage used to be known as Addamark. SenSage used to characterize itself as being [...]

  • Technical introduction to Splunk

    Updated: 2009-10-18 10:01:06
    As noted in my other introductory post, Splunk sells software called Splunk, which is used for log analysis. These can be logs of various kinds, but for the purpose of understanding Splunk technology, it’s probably OK to assume they’re clickstream/network event logs. In addition, Splunk seems to have some aspirations of having its software used [...]

  • General introduction to Splunk

    Updated: 2009-10-18 09:59:56
    I dropped by log analysis software vendor Splunk a few weeks ago for a chat with Marketing VP Steve Sommer (who some you may know from Cognos and/or Informix), Product Management VP Christina Noren, and above all co-founder/CTO Erik Swan. Splunk turns out to be a pretty interesting company, from both business and technical standpoints. [...]

  • Kickfire capacity and pricing

    Updated: 2009-10-18 03:16:14
    Kickfire’s marketing communication efforts are still a work in progress. Kickfire did finally relax its secrecy about FPGA-vs.-custom-silicon – not coincidentally during Netezza’s recent publicity cycle. That wise choice helped Kickfire get some favorable attention recently for its technical and market strategy, e.g. from Daniel Abadi, Merv Adrian and, kicking things off — as it [...]

  • Perhaps the scariest world record we’ve ever seen. Can...

    Updated: 2009-10-17 00:56:56
    Archives Submit a Post Universal Record Database Blog Perhaps the scariest world record we’ve ever seen . Can anyone put us in touch with this guy brieflynoted Absolutely gorgeous video of the world record freedive without fins at 88 meters 288 . feet It’s easy to forget how dangerous freediving is while watching William Trubridge descend into the ocean so gracefully . He makes it look almost effortless , but if you’ve ever had the urge to swim deep you know it’s certainly not . I can’t even imagine the amount of training it takes to condition your body to adapt to the the high-pressure that comes with extreme depth and lack of oxygen . Freediving must be one of the most intense experiences . It’s amazing to me what can be accomplished in a single . breath Reblogged from briefly noted October 16, 2009, 7:56pm Comments View blog comments powered by Disqus Retrograde Get our RSS Feed Theme designed by Redfield Icons by Cameron Hunt

  • Most People To Yell "We Love You Jimmy!" At Once

    Updated: 2009-10-17 00:54:34
    Most People To Yell "We Love You Jimmy!" At Once: The Emmy-winning Late Night With Jimmy Fallon blog reports on 1006 Wright State freshmen and the record they set for Most People To Yell “We Love You Jimmy!” At Once.

  • Win a copy of just::thread in our Halloween Contest

    Updated: 2009-10-16 22:14:54
    : , J ust S oftware S olutions just : thread C++0x Thread Library Call Us on 0845 053 0 350 Or email us for Custom Software Development 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 RSS Blog Archives October 2009 1 September 2009 2 August 2009 4 July 2009 1 June 2009 2 May 2009 2 April 2009 3 March 2009 2 February 2009 3 January 2009 3 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which lies just 4 miles from our office in West . Cornwall Design and Content Copyright 2005-2009 Just Software Solutions Ltd . All rights . reserved Sea Shell Photo Copyright MarieC Win a copy of just : thread in our Halloween Contest Friday , 16 October 2009 Yes , that's right this Halloween we've got 3 copies of the just : thread portability pack worth 100 to give away . The Portability Pack provides implementations of just : thread for both Linux and Windows , so you can use the

  • Backing up a SQL Server Database

    Updated: 2009-10-15 07:31:04
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Backing up a SQL Server Database Thursday October 15, 2009 One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set . Microsoft SQL Server provides database administrators with the ability to customize a database backup and recovery plan to the business and technical requirements of an . organization In this article , we explore the process of backing up data with Microsoft SQL Server . When you create a backup plan , you'll need to create an appropriate mix of backups with varying backup scopes and backup types that meet the recovery objectives of your organization and are suitable for your technical . environment Read the full article : SQL Server Backup Types and Scopes Comments 0 See All Posts Prev Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment

  • MapReduce webinars and annotated slides

    Updated: 2009-10-15 02:06:12
    As previously noted, I’m giving a webinar twice today — i.e., Thursday, October 15 – at 10:00 am and 1:00 pm Eastern time. The subject is MapReduce. The sponsor is Aster Data. Part of the webinar will be an explanation of MapReduce basics, especially the conflict between theory/propaganda and reality. As you might guess from the identity of [...]

  • Using Database ODBC with QuickBase

    Updated: 2009-10-14 15:25:20
    If you know of anyone that has long wanted to integrate QuickBase with SQL Server, Microsoft Word, Excel, Access or Visio, be sure to invite them to attend this webinar entitled “Using ODBC with QuickBase”. Scheduled for 2:00 PM Eastern time Thursday 10/15 we will talk with Claude von Roesgen one of the early [...]

  • Infobright notes

    Updated: 2009-10-14 01:32:36
    I had lunch w/ Bob Zurek and Susan Davis of Infobright today. This wasn’t primarily a briefing, but a few takeaways are: Infobright now has >100 paying customers. Typical database size is from the low 100s of gigabytes to the low single-digit number of terabytes. Agile development is at or approaching two-week release cycles. Like Kickfire, Infobright  has a [...]

  • Keeping Access Database Connections Open

    Updated: 2009-10-13 07:29:04
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Keeping Access Database Connections Open Tuesday October 13, 2009 In a recent forum message Richard Martin wrote : I have a program which consists of functions within a dll which sits on another package . I use an Access Database to hold data relating to the host package . Each time I need data from the mdb the host package calls one of my functions and opens the database , does what it needs to do , then closes the connection when the function ends . Is there anyway of keeping open the connection to the Access db even though the host package does not directly access the db Can you help Richard Looking for solutions to the same problem Join the discussion in the About Databases forum Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It

  • Definitely hope a collaboration with J C Sum and ‘Magic...

    Updated: 2009-10-12 22:16:48
    Definitely hope a collaboration with J C Sum and ‘Magic Babe’ Ning is in our future. If anyone knows them, please put us in touch.

  • ColdFusion 9 AJAX & User Interface Controls with jQuery Session Files

    Updated: 2009-10-12 17:13:05
    At the request of some people from my session at MAX 2009, I am making the session files (code, Derby database and presentation files) available for download. You can get them here. I would like to thank everyone who attended my session, you guys were great!

  • Creating a Snapshot Replication Distributor

    Updated: 2009-10-11 07:48:22
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Creating a Snapshot Replication Distributor Sunday October 11, 2009 SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized . In this article , we look at the first step of the snapshot replication process : creating the replication distributor . Read the full article : Creating a Snapshot Replication Distributor Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Related Articles Snapshot Replication Definition About Databases Glossary EVMS User Guide What is a snapshot EVMS User Guide Creating snapshot objects SQL Server Replication EVMS User Guide EVMS User Guide Discuss Recent Blog Posts Writing SQL Queries in Access 2007 Backing up a SQL Server

  • Computer Inventory Database for Microsoft Access

    Updated: 2009-10-08 07:57:41
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Computer Inventory Database for Microsoft Access Thursday October 8, 2009 This IT Inventory database template for Microsoft Access 2007 will help you organize your business' computer inventory . It includes tables for tracking workstations , servers , software and network information . Download the template : IT Inventory Database Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Related Articles How To Install the Northwind Sample Database in Microsoft Access 2000 Feature Articles Microsoft Access Fundamentals Top 5 Desktop Databases Backing up a Microsoft Access Database Discuss Recent Blog Posts Writing SQL Queries in Access 2007 Backing up a SQL Server Database Keeping Access Database Connections Open Community Forum Explore

  • Where my Idahos at?

    Updated: 2009-10-07 14:45:00
    Where my Idahos at?

  • Disaster Preparedness with SQL Server 2008

    Updated: 2009-10-06 07:55:44
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Disaster Preparedness with SQL Server 2008 Tuesday October 6, 2009 After completing the process of installing and configuring Microsoft SQL Server , any database administrator is entitled to sit back and take a well-deserved break . However , it's important to remember that the database administration process does not end when your database is humming along at a comfortable pace answering user requests . You considered a multitude of issues during the database design process performance , access controls , replication strategies , normalization and indexing to name a few . Have you taken the time to develop a contingency plan to cover unforeseen catastrophes that might threaten your database in the future Read the full article : SQL Server Disaster Recovery Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your

  • Binary Data Type

    Updated: 2009-10-04 15:54:38
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Binary Data Type Sunday October 4, 2009 In a recent forum message Gerald : wrote I am working with an existing database that has a field defined as data type binary(8 The field in existing records is populated with Not sure exactly how or where this is utilized , but I need to add additional records to this table but I am unable to enter anything but NULL into this . field Following is the error I get when I try to modify the : field Microsoft SQL Server Management Studio Express Invalid value for cell row 4, column 5 The changed value in this cell was not recognized as . valid Net Framework Data Type : Byte[ Error Message : You cannot use the Result pane to set this Field data to values other than . NULL Can you help Gerald Interested in solutions to the same problem Visit the About Databases forum and join the . discussion Comments 0 See All Posts Prev Next Comments No comments yet .

  • 4 Useful and Interesting Links for 2009-10-04

    Updated: 2009-10-04 15:01:21
    Links to interesting, educational, informational, or just plain fun websites...

  • Thanks for taking part, Frank. We had a ton of fun on last...

    Updated: 2009-10-03 22:47:00
    Archives Submit a Post Universal Record Database Blog Thanks for taking part , Frank . We had a ton of fun on last night’s show . Drew’s outstanding feat and all the records we documented will be posted shortly . Anyone out there planning to try and beat this patbaer frankhejl In case you missed it , here’s a bunch of folks you might know me included getting hit in the face with a pie by Drew Barrymore on tonight’s or I guess last night’s Late Night with Jimmy Fallon . Actually , I didn’t get hit Sorry , pie covered . pals See if you can spot me and other . friends I got pied by the Firestarter Reblogged from Things I Find October 03, 2009, 5:47pm Comments View blog comments powered by Disqus Anterograde Retrograde Get our RSS Feed Theme designed by Redfield Icons by Cameron Hunt

  • Tune in tomorrow night for the Universal Record Database, not...

    Updated: 2009-10-02 01:40:59
    Tune in tomorrow night for the Universal Record Database, not the Universal Records Database as this image suggests. It’ll be us, we swear. We’re going to be on the show. For real. No fakesies.

  • Choosing the Correct Edition of Microsoft Office for Your Needs

    Updated: 2009-10-01 07:20:18
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Choosing the Correct Edition of Microsoft Office for Your Needs Thursday October 1, 2009 There are at least eight different versions of the Microsoft Office suite , making it difficult to choose the correct one for your needs . If you choose a version that's not sufficient to meet your needs , you'll wind up feeling frustrated . On the other hand , if you overshoot and buy too full-featured a package , you'll waste . money How should you choose Here's a simple guide to making your decision . First , if you're reading this blog , you're likely a Microsoft Access user . This makes it easy to eliminate half of the choices off the bat . The following four editions of Microsoft Office do NOT include : Access Microsoft Office Basic 2007 Microsoft Office Home Student 2007 Microsoft Office Standard 2007 Microsoft Office Small Business 2007 That leaves us with four remaining options . We can

  • We’re thrilled to be part of the launch party for world...

    Updated: 2009-09-30 02:44:15
    Archives Submit a Post Universal Record Database Blog We’re thrilled to be part of the launch party for world record holder David Sax s amazing new book . Andrea Rosen you free that night to join us September 29, 2009, 9:44pm Comments View blog comments powered by Disqus Anterograde Retrograde Get our RSS Feed Theme designed by Redfield Icons by Cameron Hunt

  • Partitioning SQL Server Tables

    Updated: 2009-09-29 07:17:42
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Partitioning SQL Server Tables Tuesday September 29, 2009 Looking to optimize the performance of your SQL Server database If your database contains very large tables , you may benefit from partitioning those tables onto separate filegroups . This technology , introduced in SQL Server 2005, allows you to spread data onto different physical disks , leveraging the concurrent performance of those disks to optimize query . performance Read the full article : Partitioning a SQL Server Database Table Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It Related Articles Creating Tables in Microsoft SQL Server SQL Server Index Tuning How To Performance Tune SQL Server 7.0 Introduction to Microsoft SQL Server 2000 Learn ASP.NET 2.0 SQL Server and

  • Linking a Stored Procedure Recordset to a Table

    Updated: 2009-09-27 20:17:09
    Search Databases Home Computing Technology Databases Email Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases since 2000 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Linking a Stored Procedure Recordset to a Table Sunday September 27, 2009 In a recent forum message Raul Lopez wrote : I have a recordset returned from a stored procedure . I have a table that I need to link the column of the recordset to a column in the db table . The recordset pulls the prices of the items on an item list . The table has the items as they were sold by the document . How do I link this Is it with the UNION or UNION ALL I look at the way the stored procedure was written and , for the life of me , I cannot seem to find where that procedure is pulling the information from . I think this deals a lot with my lack of knowledge . Do you have any advice for Raul Interested in solutions to the same problem Join the discussion in the About Databases forum Comments 0 See All Posts Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL

  • VistaDB 4.0 Build 5

    Updated: 2009-09-26 20:43:00
    VistaDB Net Database Blog Embedded SQL Database Engine for Net Home Archive Contact Subscribe VistaDB.Net VistaDB 4.0 Ships with Build 6 VistaDB 4.0 Build 5 by Jason Short 26 September 2009 Build 5 Final Release Candidate We expect this to be the final release candidate of VistaDB 4. We now have over a hundred customers who have upgraded their vdb3 projects to vdb4 and the feedback has been very positive . nbsp This release is fine to go live with on your website or project as well . nbsp Just realize that we will be updating builds probably weekly for the next few weeks . nbsp We are adding the sample projects and other non-engine related things to the setup , and will continue to work on any issues reported by . customers Pagesize Limitations on tables , index , etc Pagesize has always had a direct effect on the number of columns that could be present in a table , size of a description , max length on a view , etc . nbsp Now we are enforcing those limits a little more strictly , and PackDatabase has been updated to promote a database to the correct pagesize for the data in the . database All database pages have a 96 byte header that is required for tracking structures , trees ,

  • Oracle SQL Developer 2.1 EA1 Released

    Updated: 2009-09-24 22:57:26
    Oracle SQL Developer 2.1 Early Access 1 is available for download. Please review the Release Notes before you start. For all other supporting documents, please visit SQL Developer on OTN. Here’s the new feature list : http://www.oracle.com/technology/products/database/sql_developer/files/NewFeatureList21.htm Here’s the OBE for the new Unit Testing: [...]

  • How to add Microsoft Outlook to QuickBase

    Updated: 2009-09-22 17:16:33
    Tune in Thursday 9/24 at 2pm Eastern time for a webinar entitled: “ How to add Microsoft Outlook to QuickBase”. This open webinar showcases “SendToQuickBase” and “SendToOutlook” an Outlook integration product from SoftTech, Inc. “SendToQuickBase” bridges and extends QuickBase so users have full Outlook Integration for email, meetings, appointments, tasks and contact updates. Anything [...]

Last Months Items