• SQL Server Table Partitioning

    Updated: 2010-08-31 07:03:13
    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...Read Full Post

  • Default Yes/No Values in Microsoft Access Databases

    Updated: 2010-08-29 07:57:35
    In a recent forum message, CARMENCHA asks: "I am using Access 2007. I have defined a field as Yes/No and I need to have this field default to Yes (e.i. ...Read Full Post</p

  • Database Certifications

    Updated: 2010-08-26 07:27:21
    Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Perhaps you're just getting started in database administration and you'd like to ...Read Full Post

  • CrowdConf 2010 Coming to San Francisco

    Updated: 2010-08-24 19:24:18
    Jump to Content Jump to Navigation Jump to Footer Search : TechSoup Home Learning Center Community Find Services Get Products Log In Join How To Use TechSoup Home Community TechSoup Blog CrowdConf 2010 Coming to San Francisco TechSoup Delivered By the Cup New articles , discussions , offers . . Weekly View sample New Product Alert Additions to the TechSoup Stock catalog . . Monthly View sample Email : RSS Feed Be notified of new articles as soon as we publish . them All TechSoup RSS Feeds What Is RSS Tags Accessible Technology Digital Divide Fundraising GreenTech Hardware Networks Online Seminar Running Your Organization Security Services Software Tech Planning Troubleshooting and Maintenance Using the Web and Internet Blog Search Other TechSoup : Blogs TechSoup For Libraries Blog Learn

  • SQL*Plus Timers

    Updated: 2010-08-24 15:00:44
    SQL*Plus TIMING is a handy little utility that you can use to do a performance analysis on any commands or blocks run during a period. It is different from the SET TIMING command which is used to display timing data after each SQL command or PL/SQL block you run. Here is an example: TIMING SHOW [...]

  • Stock Market Database in Microsoft Access

    Updated: 2010-08-24 07:09:22
    In a recent forum message, Ken wrote: "I'm new to access and I'm trying to learn but I have a problem. I have a very large set of excel files ...Read Full Post

  • About Oracle Press

    Updated: 2010-08-23 15:00:03
    Oracle Press is a marketing label used by McGraw Hill to market its line of Oracle books – the books are not formally written by Oracle Corporation nor are they formally tech edited by Oracle Corporation, although some employees of Oracle Corporation have used McGraw Hill as a publishing company. At least for me, for [...]

  • Showing or Hiding Tabs in Access 2010

    Updated: 2010-08-22 18:07:02
    Access 2010 uses the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of ...Read Full Post

  • Authentication Modes in SQL Server 2008

    Updated: 2010-08-19 07:06:38
    Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of ...Read Full Post

  • I’m collecting data points on NoSQL and HVSP adoption

    Updated: 2010-08-18 07:09:08
    I was asked to do a magazine article on NoSQL, where by “NoSQL” is meant “whatever they talk about at NoSQL conferences.” By now the number of publications planning to run the article is up to 2, the deadline is next week and, crucially, it has been agreed that I may talk about HVSP in [...]

  • Finally confirmed: Membase has a reasonable product roadmap

    Updated: 2010-08-18 03:37:55
    On my recent trip to California, neither I nor my clients at Northscale covered ourselves in meeting-arranging glory. Still, from the rushed 30 minute meeting we did wind up having, I finally came away feeling good about Membase’s product direction. To review, Membase is a reasonably elastic persistent data store, sporting the memcached API, making memcached/Membase [...]

  • DB2 workload management

    Updated: 2010-08-18 02:47:09
    DB2 has added a lot of workload management features in recent releases. So when we talked Tuesday afternoon, Tim Vincent and I didn’t bother going through every one. Even so, we covered some interesting subjects in the area of DB2 workload management, including:  If your goal is to keep a certain class of queries from [...]

  • More on temp space, compression, and “random” I/O

    Updated: 2010-08-17 23:44:59
    My PhD was in a probability-related area of mathematics (game theory), so I tend to squirm when something is described as “random” that clearly is not. That said, a comment by Shilpa Lawande on our recent Flash/temp space discussion suggests the following way of framing a key point: You really, really want to have multiple data [...]

  • Mailing List Database

    Updated: 2010-08-17 07:06:05
    One of the most common uses of a Microsoft Access database is generating labels for mass mailings. In this tutorial, we examine the process of creating mailing labels using Microsoft ...Read Full Post

  • 5 Interesting Things You May Have Missed On This Aug 16, 2010

    Updated: 2010-08-16 15:03:08
    Links to interesting, educational, informational, or just plain fun websites...

  • Vertica’s innovative architecture for Flash, plus more about temp space than you perhaps wanted to know

    Updated: 2010-08-16 02:07:33
    Vertica is announcing: Technology it already has released*, but has not published any reference architectures for A Barney partnership** In other words, Vertica has succumbed to the common delusion that it’s a good idea to put out half-baked press releases the week of TDWI conferences. But if we look past that kind of all-too-common nonsense, Vertica is highlighting [...]

  • Splitting Database Tables By Year

    Updated: 2010-08-15 07:59:15
    In a recent forum message, Michael wrote: "I need to create a partitioned table per year and per month, something like this: 2010 ...Read Full Post

  • PDF Reporting with Microsoft Access

    Updated: 2010-08-12 07:16:16
    Adobe Acrobat (.PDF) offers a great method of sharing data across the Internet while preserving formatting. It's simple to generate these files from an Access database.<br / The instructions vary slightly depending upon the version of Access you use: Creating PDFs with Access 2007 Creating PDFs with earlier versions of Access ...Read Full Post

  • Big Data is Watching You!

    Updated: 2010-08-10 23:30:22
    There’s a boom in large-scale analytics. The subjects of this analysis may be categorized as: People Financial trades Electronic networks Everything else The most varied, interesting, and valuable of those four categories is the first one. That may change some day, with the growing importance of machine-generated data, and of big-data science in particular. But I think it’s a fair assessment [...]

  • Exporting Data from Access 2010 to Excel

    Updated: 2010-08-10 07:13:20
    It's often necessary to convert data stored in an Access database to another form, such as an Excel workbook. You may wish to take advantage of some of Excel's unique ...Read Full Post

  • Links and observations

    Updated: 2010-08-09 20:37:51
    I’m back from a trip to the SF Bay area, with a lot of writing ahead of me. I’ll dive in with some quick comments here, then write at greater length about some of these points when I can. From my trip:  Aster Data showed me a lot of customer names and deal sizes, across [...]

  • Notes on EMC’s Greenplum subsidiary

    Updated: 2010-08-09 18:02:17
    I spent considerable time last week with my clients at both Greenplum and EMC (if we ignore the fact that the deal has closed and they’re now the same company). I also had more of  a hardcore engineering discussion than I’ve had with Greenplum for quite a while (I should have been [...]

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

    Updated: 2010-08-09 18:00:53
    : , 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 Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives August 2010 1 July 2010 2 June 2010 1 May 2010 2 April 2010 4 March 2010 1 February 2010 3 January 2010 3 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach ,

  • ANTs Software CEO insults Sybase, claims migration success

    Updated: 2010-08-04 04:43:12
    Jeff Pryslak of Sybase put up a post insulting ANTs Software and the general idea of ANTs-aided Sybase-to-DB2 migration. CEO Joe Kozak of ANTs hit back with a rambling diatribe, which came to my attention because he mentioned my name in it, making some rather fanciful remarks about the “long” relationship I used to have [...]

Current Feed Items | Previous Months Items

Jul 2010 | Jun 2010 | May 2010 | Apr 2010 | Mar 2010 | Feb 2010