Updated: 2010-02-28 06:33:53
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Free Personal Budgeting Database Sunday February 28, 2010 This personal financial planning database allows you to track income and expenses against your budget targets using Microsoft Access . Download the Microsoft Office Personal Budget Database Template from the Microsoft Office Community . website Comments 0 See All Posts Share 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 Glossary Discuss Readers Respond What I Wish I Knew About Databases Read Responses 5 Add Your Response Recent Blog Comments Tracking Employee Training in a Database Help with Access SQL Query in Visual Basic for Applications Changing Tab Location with VBA Explore Databases Must Reads
Updated: 2010-02-25 22:03:12
Dan Olds argues that Oracle is likely to pursue commercially-substantive high performance computing (HPC), emphasis mine:
I just don’t see Oracle abandoning HPC entirely. I think it may call it by some other name or describe it differently, but it will be in the high throughput computing business for the foreseeable future.
There are some interesting angles [...]
Updated: 2010-02-25 06:38:01
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Expression Builder Tables Won't Appear Thursday February 25, 2010 In a recent forum message UberMonkey wrote : I'm trying to insert a really simple formula into one of my tables maybe this should actually be made into a query , but I'm still a newbie , and need to look into that but in any case , when I open the Expression Builder , none of my tables appear . You have three screenshots of Expression Builder in your tutorial . Mine looks like the first one , but I cannot make it look like the second or third ones which display your tables and queries . It also has many fewer functions to choose from in the middle panel . What am I missing Can you help UberMonkey Interested in solutions to the same problem Visit the About Databases forum and join the conversation Comments 0 See All Posts Share Prev Next Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your
Updated: 2010-02-25 05:10:48
It had been a very long time since I was remotely up to speed on Sybase’s main OLTP DBMS, Adaptive Server Enterprise (ASE). Raj Rathee, however, was kind enough to fill me in a few days ago. Highlights of our chat included:
One of the most confusing things about Sybase ASE is its version numbering. In [...]
Updated: 2010-02-24 21:44:54
I wouldn’t say every post in Chris Bird’s occasionally-updated blog is brilliant. I wouldn’t even say every post is readable. But I’d still recommend his blog to just about anybody who reads here as, at a minimum, a consciousness-raiser.
One of the two posts inspiring me to mention this is a high-level one on “technical debt“, [...]
Updated: 2010-02-23 23:05:03
, 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 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 , which lies just 4 miles from our office in West . Cornwall Design and Content Copyright 2005-2010 Just Software Solutions Ltd . All rights . reserved Sea Shell Photo Copyright MarieC February 2010 C++ Standards Committee Mailing Tuesday , 23 February 2010 The February 2010 mailing for the C++ Standards Committee was published last week . This is the pre-meeting mailing for the March 2010 committee meeting and contains a new working draft There are 5 concurrency-related
Updated: 2010-02-23 06:32:24
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Data Mining Applications in Business Tuesday February 23, 2010 Through the use of automated statistical analysis or data mining techniques , businesses are discovering new trends and patterns of behavior that previously went unnoticed . Once they've uncovered this vital intelligence , it can be used in a predictive manner for a variety of applications . Read the full story : Data Mining : An Introduction Comments 0 See All Posts Share 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What I Wish I Knew About Databases Read Responses 5 Add Your Response Recent Blog Comments Tracking Employee Training in a Database Help with Access
Updated: 2010-02-23 06:09:07
This article provides a set of simple techniques for preventing SQL Injection vulnerabilities. These techniques can be used with practically any kind of programming language with any type of database. There are other types of databases, like XML databases, which can have similar problems (e.g., XPath and XQuery injection) and these techniques can be used to protect them as well.
Updated: 2010-02-22 00:30:23
February is usually a busy month for data warehouse DBMS product releases, product announcements, and other real or contrived data warehouse DBMS news, and it can get pretty confusing trying to keep those categories of “news” apart.* This year is no exception, although several vendors – including Teradata and Netezza – are taking “rolling thunder” [...]
Updated: 2010-02-22 00:21:13
Much like Aster Data did in Aster 4.0 and now Aster 4.5, Netezza is announcing a general parallel big data analytic platform strategy. It is called Netezza TwinFin(i), it is a chargeable option for the Netezza TwinFin appliance, and many announced details are on the vague side, with Netezza promising more clarity at or before [...]
Updated: 2010-02-22 00:20:13
Like Vertica, Netezza, and Teradata, Aster is using this week to pre-announce a forthcoming product release, Aster Data nCluster 4.5. Aster is really hanging its identity on “Big Data Analytics” or some variant of that concept, and so the two major named parts of Aster nCluster 4.5 are:
Aster Data Analytic Foundation, a set of analytic [...]
Updated: 2010-02-22 00:19:00
Vertica briefed me last month on its forthcoming Vertica 4.0 release. I think it’s fair to say that Vertica 4.0 is mainly a cleanup/catchup release, washing away some of the tradeoffs Vertica had previously made in support of its innovative DBMS architecture.
For starters, there’s a lot of new analytic functionality. This isn’t Aster/Netezza-style ambitious. Rather, [...]
Updated: 2010-02-21 23:23:00
Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Twitter Weekly Updates for 2010-02-21 Posted in February 21, 2010 7:23 . pmh Lewi No Comments DB Geek says : Twitter Weekly Updates for 2010-02-14 : google_ad_client pub-4372398370642959 468×60, cr http : bit.ly ddNyj8 Blogged Wazzup http : it.toolbox.com trd 46 2 36990 3 Cracked.com : 5 reasons to be scared of apple . http : bit.ly bbWsv3 Anyone else get Service Temporarily Unavailable a lot on oracle.com's documentation Seems to be getting worse . Blogged Would You Leave Your Job http : it.toolbox.com trd 46 2 37018 3 Powered by Twitter Tools 127 tweet twitter You can follow any responses to this entry through the RSS 2.0 feed . You can leave a response or trackback from your own site . Leave a Reply Click here to cancel . reply Name required Mail will not be published required Website : XHTML You can use these tags : Please add 8 and 4 Subscribe via reader Subscribe to the Database Geek by Email Subscribe to comments Recent Posts Twitter Weekly Updates for 2010-02-21 Twitter Weekly Updates for 2010-02-14 Twitter Weekly Updates for 2010-02-07 Twitter Weekly Updates for 2010-01-31 Twitter
Updated: 2010-02-21 16:26:26
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Creating a DMF Condition Sunday February 21, 2010 Conditions are the clauses that you may use to create DMF policies on a management facet . Examples of conditions are usernames , account creation dates and password complexity policies . In this example , we will create a DMF condition that enforces a stored procedure naming policy that requires all stored procedures begin with the sp_ prefix . You may choose to create any DMF condition that enforces your organization's business requirements . If you're new to DMF , you may wish to begin by reading Declarative Management Framework in Microsoft SQL Server Otherwise , read the full story : Creating a DMF Condition Comments 0 See All Posts Share 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 Must Reads Databases for
Updated: 2010-02-18 06:41:34
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Passwords for Microsoft Access Databases Thursday February 18, 2010 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 with a password , step by step . Read the full article : Password Protecting an Access Database Comments 0 See All Posts Share 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What I Wish I Knew About Databases Read Responses 5 Add Your Response Recent Blog Comments Tracking Employee Training in a Database Help with Access SQL Query in Visual Basic for Applications Changing
Updated: 2010-02-18 05:56:15
The 2010 CWE/SANS Top 25 Most Dangerous Programming Errors is a list of the most widespread and critical programming errors that can lead to serious software vulnerabilities. They are often easy to find, and easy to exploit. They are dangerous because they will frequently allow attackers to completely take over the [...]
Updated: 2010-02-16 07:04:22
Streambase is announcing something called the StreamBase Component Exchange, for developers to exchange components to be used with the StreamBase engine, presumably on an open source basis. I simultaneously think:
This is a good idea, and many software vendors should do it if they aren’t already.
It’s no big deal.
For reasons why, let me quote an email [...]
Updated: 2010-02-16 06:41:03
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Regular Expressions in SQL Server Queries Tuesday February 16, 2010 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 that fits a certain pattern , rather than specifying it exactly . For example , you can use the wildcard C to match any string beginning with a capital C . Read the full article : Pattern Matching in SQL Server Queries Comments 1 See All Posts Share Prev Next Leave a Comment Comments February 17, 2010 at 8:49 am 1 Vickie : says When I click on the link to take me to the Free SQL classes it brings up a long list of the classes but nothing related to SQL . Can you tell me the section and class name that it is listed under Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed : Say It
Updated: 2010-02-15 13:00:51
The following is a list of database limits which are divided into four categories in addition to the PL/SQL compiler limits. It is an aggregation of 5 separate web pages from the Oracle Database 11g Release 2 documentation library. I put them all here on one page for convenience.
Datatype Limits
Datatypes
Limit
Comments
BFILE
Maximum size: 4 GB
Maximum [...]
Updated: 2010-02-14 23:23:00
DB Geek says: Twitter Weekly Updates for 2010-02-07: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/barDm4 #
Who dat say dey gonna beat dem Saints? Who dat? Who dat? #
In a way, Manning couldn't lose. He played for hs team but his city won anyway. #
Blog Comments: Comment on JSON In (and out) of Oracle – JSON Data [...]
Updated: 2010-02-14 00:40:17
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS SQL Server Developer Permissions Sunday February 14, 2010 In a recent forum message William Rich wrote : I'm a Visual Basic SQL Server developer who recently changed jobs . In the past , the SQL Server DBA would assign my development team a connection string and we would merrily code away creating tables , stored procedures , and the like with little regard for security SQL Server would tell us when we had exceeded the boundaries of our permissions and a call to the DBA would smooth out momentary stoppages in our development activities . However , on my new job , my ignorant disregard for the plight of the DBA has caught up with me . Our company produces a non-Windows , Unix based product , and even though we rely heavily on Windows workstations and Microsoft turn-key products to support our workflow , there is little ADO.NET and SQL Server knowledge or activity . I'm proposing an overhaul of our
Updated: 2010-02-11 17:13:33
Joel Kallman lists steps to make apex.oracle.com run faster, like turning on the KeepAlive setting in Oracle HTTP Server, reducing the open window for Web crawlers in robots.txt, replacing a Database Access Descriptor with an httpd.conf rewrite rule and increasing file system caching and memory size. Read the details at Making apex.oracle.com fast (again).
Updated: 2010-02-11 15:13:42
As he has before, Intelligent Enterprise Editor Doug Henschen
Personally selected annual lists of 12 “Most influential” companies and 36 “Companies to watch” in analytics- and database-related sectors.
Made it clear that these are his personal selections.
Nonetheless has called it an Editors’ Choice list, rather than Editor’s Choice.
(Actually, he’s really called it an “award.”)
People advising [...]
Updated: 2010-02-11 11:29:57
Google recently received a patent for MapReduce. The first and most general claim is (formatting and emphasis mine):
A system for large-scale processing of data, comprising:
a plurality of processes executing on a plurality of interconnected processors;
the plurality of processes including a master process, for coordinating a data processing job for processing a set of input data, [...]
Updated: 2010-02-11 06:19:25
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Declarative Management Framework in Microsoft SQL Server 2008 Thursday February 11, 2010 SQL Server's Declarative Management Framework DMF allows you to proactively regulate the configuration and operation of your SQL Server databases . You may declare security and best practice policies and then apply them to your database server . Read the full story : Declarative Management Framework in Microsoft SQL Server 2008 Comments 0 See All Posts Share 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What I Wish I Knew About Databases Read Responses 5 Add Your Response Recent Blog Comments Tracking Employee Training in a Database Help
Updated: 2010-02-10 21:58:59
Oracle has agreed to acquire Convergin, a leading provider of real-time service brokering solutions.
Convergin’s industry-leading J2EE-based Service Broker platform enables communications service providers (CSPs) to manage services for a wide range of networks and application platforms, including pre-paid charging. The solution allows CSPs to focus on launching innovative services while modernizing to next-generation networks.
CSPs are [...]
Updated: 2010-02-10 20:42:03
It can take a fairly stable team of programmers as long as six months to get to a point where they’re estimating programming time fairly close to actuals, says Suvro Upadhyaya, a Senior Software Engineer at Oracle. Accurately estimating programming time is a process of defining limitations, he says. The programmers’ experience, domain knowledge, and [...]
Updated: 2010-02-10 14:03:43
Links to interesting, educational, informational, or just plain fun websites...
Updated: 2010-02-10 05:18:17
When Oracle acquired Sun, the database giant also acquired the Java technology that was Sun's lifeblood. Oracle Chairman and CEO Larry Ellison called Java the most important technology Oracle has ever acquired. With ownership and leadership come responsibility. Java's future is now in Oracle's hands. This eWEEK slide show presents 15 ways Oracle can improve Java and boost its position in the Java community.
Updated: 2010-02-09 05:48:15
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Storing Binary Files in an Access Database Tuesday February 9, 2010 Microsoft Access allows you to include attachments in database tables . You may store photos , graphics , documents and other files in your Access database using Microsoft's Object Linking and Embedding OLE technology . Read the full article : How to Include Attachments in an Access Database Comments 0 See All Posts Share 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 Adding Splash Screens to Access How To Create an Adobe PDF File From an Access Database Creating the Database File Converting an Excel Spreadsheet to an Access Database Converting an Excel Spreadsheet to an Access Database Discuss Readers Respond What I Wish I Knew About Databases Read Responses 5 Add Your Response
Updated: 2010-02-07 23:23:00
DB Geek says: Twitter Weekly Updates for 2010-01-31: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/cJsK50 #
Blog Comments: Comment on Twitter Weekly Updates for 2009-06-07 by over the counter nail fungus treatment: over th… http://bit.ly/criJK5 #
Blog Talk: Comment by upendra on Oracle Streams Configuration: Change Data Capture http://bit.ly/cnzP3x #
Blog Talk: Comment by Mkoneru on Learn [...]
Updated: 2010-02-07 13:39:26
Search Databases Home Computing Technology Databases Share 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Database Client Synchronization Sunday February 7, 2010 In a recent forum message kpalser wrote : I need some recommendations for software to develop a database with good client GUI synchronization , i.e : a multiuser database solution where clients will display data without the need for a manual refresh . For example , if one user updates a record from a client application , other clients currently viewing the same record will automatically show the updated data . To date I have used FileMaker , which is great for rapidly developing solutions . However , since the front end and data back end are not separated it is not very scalable . Imagine different companies are using independent copies of the same solution . Every time you need to update the solution you would manually have to make changes for each company or re-import their records into the new version of the solution . Although Filemaker
