Updated: 2009-12-31 06:26:34
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS ZIP Code Database in Microsoft Access Thursday December 31, 2009 This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city state pair and even provides the latitude and longitude of that location . Download the database : ZIP Code Database 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 Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read Responses 27 Add Your Response Recent Blog Comments Get Certified Opening PDF Files Within Microsoft Access Payroll Database in Microsoft Access Explore Databases Must Reads Databases for Beginners SQL Basics Top
Updated: 2009-12-30 03:38:22
Adding to yesterday’s varied quick comments:
Robert Hodges of Continuent offers a great outline of Continuent’s clustering story, with a lot of “Now we got right what we previously didn’t know/admit we got wrong.” Continuent now claims to have a strong clustering offering, both paid and free/open-source, for both MySQL and PostgreSQL, with Oracle support perhaps [...]
Updated: 2009-12-30 02:50:53
I’m frustrated by a constant need — or at least urge — to correct myths and errors about MapReduce. Let’s try one more time:
MapReduce was named and popularized — but not invented — by Google.
“MapReduce” variously refers to:
A programming paradigm
Execution engines that implement the programming paradigm
Distributed file systems that work with the execution [...]
Updated: 2009-12-29 06:22: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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Preventing Rounding in SQL Server Tuesday December 29, 2009 In a recent forum message jyoung100 wrote : I am using the sum function in Microsoft SQL Server to add 3.0 and 1.5, but the answer keeps coming out as 5. What am I doing wrong Can you help jyoung100 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 . 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 Do You Want To See in Access 2010 Read Responses 27 Add Your Response Recent Blog Comments Get Certified Opening PDF Files Within Microsoft Access Payroll Database in Microsoft Access Explore
Updated: 2009-12-29 01:14:46
I have various subjects backed up that I don’t really want to write about at traditional blog-post length. Here are a few of them.
Vertica offers a post on its 3.5 release, with a riff on the popular theme “We’ve fixed some weaknesses in our prior versions that we didn’t previously say we had.” More important, [...]
Updated: 2009-12-28 02:33:41
Try JibJab Sendables® eCards today!
Welcome 2010! Happy New Year!
Related articles:Goodbye 2005, Hello Vegas
Updated: 2009-12-27 23:23:00
Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Twitter Weekly Updates for 2009-12-27 Posted in December 27, 2009 7:23 . pmh Lewi No Comments DB Geek says : Twitter Weekly Updates for 2009-12-20 : google_ad_client pub-4372398370642959 468×60, cre http : bit.ly 8bjgAy Blogged Oracle Tampa Extreme Performance Seminar Exadata v2 http : it.toolbox.com trd 46 2 36029 3 The hardest arithmetic to master is that which enables us to count our blessings . Eric Hoffer RT : TheOnion Feds Uncover Secret Santa Ring http : bit.ly 8EMCxI Fill this season with cheer by designating a sober driver before going to holiday parties http : buzzeddriving.adcouncil.org buzzeddriving Blog Comments : Comment on Ora_Tweet Tweet From Oracle , A PL SQL Twitter API by Caramoan : Twitter in some ways i http : bit.ly 8u5CZo Blogged 2009 The Oracle Year in Review Part 1 http : it.toolbox.com trd 46 2 36071 3 Tweeting 2 years , 5 months , 5 hours , 9 minutes , 52 seconds July 27, 2007 How about you http : bit.ly eC942 howlong 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
Updated: 2009-12-27 19:16:30
Around the end of the Cold War, Esther Dyson took it upon herself to go repeatedly to Eastern Europe and do a lot of rah-rah and catalysis, hoping to spark software and other computer entrepreneurs. I don’t know how many people’s lives she significantly affected – I’d guess it’s actually quite a few – but [...]
Updated: 2009-12-27 16:21:48
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Log Shipping in SQL Server 2008 Sunday December 27, 2009 Log shipping allows you to keep two SQL Server databases synchronized for high availability . In a log shipping relationship , the primary server transfers copies of its transaction logs to the secondary server on a periodic basis . The secondary server receives those logs and uses them to update its copy of the database so that it is then in the same state as the database on the primary server . Read the full article : Log Shipping in SQL Server 2008 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read
Updated: 2009-12-24 06:04:27
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS SQL Server Recovery Models Thursday December 24, 2009 In the event of a database failure , you have the most flexibility restoring databases using the full recovery model . In addition to preserving data modifications stored in the transaction log , the full recovery model allows you to restore a database to a specific point in time . For example , if an erroneous modification corrupted your data at 2:36AM on Monday , you could use SQL Server's point-in-time restore to roll your database back to 2:35AM , wiping out the effects of the error . Read more about SQL Server Recovery Models 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 Glossary
Updated: 2009-12-22 06:03:17
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS NOT NULL Constraints in Microsoft SQL Server Tuesday December 22, 2009 NOT NULL constraints in Microsoft SQL Server allow you to specify that a column may not contain NULL values . When you create a new NOT NULL constraint on a database column , SQL Server checks the column's current contents for any NULL values . If the column currently contains NULL values , the constraint creation fails . Otherwise , SQL Server adds the NOT NULL constraint and any future INSERT or UPDATE commands that would cause the existence of a NULL value fail . Read the full article : NOT NULL Constraints in Microsoft SQL Server 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to
Updated: 2009-12-20 06:54:12
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Opening PDF Files Within Microsoft Access Sunday December 20, 2009 In a recent forum message Redwings2010 wrote : My boss wants me to create a form using Access 2007 that would open a specific PDF file to view in the form . He doesn't want to click on and view the PDF file outside Access . Is that possible Can you help Interested in solutions to the same problem Visit the About Databases forum and join the discussion Comments 1 See All Posts Prev Next Leave a Comment Comments December 30, 2009 at 10:57 am 1 Guy : says Yes , it’s possible . You may achieve this with the use of . hyperlinks Here’s : how 1. In a table add a field with the following : attributes Field Name : LinkToPdf you may actually name the field as you like Data Type : Hyperlink 2. Create your form With the Form Wizard , make sure a TextBox is generated for the LinkToPdf . field If the form is already existing , open it in Design
Updated: 2009-12-17 06:41:43
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS SQL Server Transaction Log Management Thursday December 17, 2009 The transaction log plays a critical role in a SQL Server database : it maintains an ongoing record of database activity crucial for the restoration of recent data in the event of a disaster . However , this benefit comes at a cost : the transaction log can consume a substantial amount of space in an active database . SQL Server provides two actions designed to counterbalance these large space requirements : transaction log truncation and log file shrinking . Read more in SQL Server Transaction Log Management 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss
Updated: 2009-12-15 06:36:51
: 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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Database Certification Spotlight : OCA Tuesday December 15, 2009 The Oracle Certified Database Administrator OCA credential is an entry-level certification designed to serve as a stepping-stone to the more advanced Oracle Certified Professional OCP and Oracle Certified Master OCM programs . Currently , there are three active certification programs : Oracle 9i , Oracle 10g and Oracle 11g . I'd strongly encourage you to certify on the most recent version of Oracle in order to maintain your credential as long as possible . Read the full story : Oracle Certified Associate 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 Must Reads Databases for Beginners SQL Basics Top 10 SQL FAQs Top 5 Things Beginners Need to Know Database Glossary Discuss
Updated: 2009-12-14 03:44:43
Oracle has put out a press release promising to play nicely with MySQL if its Sun takeover is approved. The parts in italics below are quotes. My comments are in plain text.
1. Continued Availability of Storage Engine APIs. Oracle shall maintain and periodically enhance MySQL’s Pluggable Storage Engine Architecture to allow users the flexibility to [...]
Updated: 2009-12-13 15:54:49
Have you ever called a customer at 9:00 AM on the East coast only to find that your customer is on the West coast and its 6:00 AM and you just woke them? This happens all the time.
Many businesses use QuickBase for sales and CRM applications wouldn’t it be great to add the time [...]
Updated: 2009-12-13 11:35:43
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Copying Access Forms Sunday December 13, 2009 In a recent forum message DajuParker wrote : I have created a complex form in Access under a particular table . How can I copy duplicate that form into a different table in that same Access file Do you have any advice for DajuParker Interested in solutions to the same issue Visit the About Databases forum and join the discussion Comments 1 See All Posts Prev Next Leave a Comment Comments December 22, 2009 at 5:51 pm 1 joemach : says With the form that you want to save FILESAVE AS you get a pop up to save the form as a new name . Put in a new name and select . OK Go to design view and change the Record Source of the new form to the other table . Go to each control and change the Control Source for each Textbox to the field you . want This works for Access 97 2003 not sure about other . versions Let me know how this . works Leave a Comment Leave a
Updated: 2009-12-11 22:06:52
I’ve written some snarky things about the “NoSQL” concept – or at least the moniker. (Carl Olofson’s term “non-schematic databases” seems less bad.) Yet I’m actually favorable about the increasing use of SQL alternatives. Perhaps I should pull those thoughts together.
Relational database management systems were invented to let you use one set of data in [...]
Updated: 2009-12-11 19:44:01
Neal Leavitt is writing an article for IEEE on NoSQL. So he’s circulated a long list of questions, encouraging people to answer as many or few as they choose. Unfortunately, most of the questions are technically meaningless, in that they implicitly rely on the false assumption that there is such a thing as a single [...]
Updated: 2009-12-11 16:15:02
Information preservation* DBMS vendor Clearpace officially changed its name to RainStor this week. RainStor is also relocating its CEO John Bantleman and more generally its headquarters to San Francisco. This all led to a visit with John and his colleague Ramon Chen, highlights of which included:
RainStor expects to finish the year with > 50 users [...]
Updated: 2009-12-11 15:16:54
Ray Wang made a terrific post based on SAP’s annual influencer love-in, an event which I no longer attend. Ray believes SAP has been in a “crisis”, and sums up his views as
The Bottom Line – SAP’s Turning The Corner
Credit must be given to SAP for charting a new course. A shift in the management [...]
Updated: 2009-12-10 16:26:54
If you have ever embedded a YouTube, Camtasia, Jing or Flash video into a QuickBase dashboard you know that the Internet Explorer browser will display an annoying pop-up that can drive you crazy.
This is because you are introducing a Flash video object that is hosted in a location other than QuickBase. You [...]
Updated: 2009-12-10 06:40:14
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 My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Microsoft SQL Server DEFAULT Constraints Thursday December 10, 2009 DEFAULT constraints allow you to specify a value that the database will use to populate fields that are left blank in the input source . They're a replacement for the use of NULL values that provide a great way to predefine common data elements . Read the full article : DEFAULT Constraints in Microsoft SQL Server 2008 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 Glossary Discuss Readers Respond What Do You Want To See in Access 2010 Read Responses 27 Add Your Response Recent Blog Comments Get Certified Opening PDF Files Within Microsoft Access Payroll Database in Microsoft
Updated: 2009-12-07 05:50:47
There are only three ways that the amount of data stored in data warehouses can grow:
The same kinds of data are stored as before, with more being added over time.
The same kinds of data are stored as before, but in more detail.
New kinds of data are stored.
The first of those three ways doesn’t lead to [...]
Updated: 2009-12-06 23:23:00
DB Geek says: Twitter Weekly Updates for 2009-11-29: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cre… http://bit.ly/6DQ5za #
Blogged "ZDNet's Oracle Topline" http://it.toolbox.com/trd/46/2/35625/3 #
Just bought this on Amazon: 'LG 37LH30 37-Inch 1080p LCD HDTV, Gloss Black' by LG http://bit.ly/5yQvwj #
RT: @google Making the web faster: introducing Google Public DNS http://bit.ly/8GVVcJ #
"Eagles come in all shapes and sizes, but you [...]
