Updated: 2010-04-29 21:44:59
Last month, Vertica’s CEO Ralph Breslauer quit,* and Vertica made it sound like there would be a new CEO late in April. And indeed, as of April 29, there was. He’s a guy I’ve never heard of before named Chris Lynch, apparently quite the sales machine builder. The most substance I’ve found is a pair [...]
Updated: 2010-04-29 17:38:23
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 Injection Attacks Against Web Applications Thursday April 29, 2010 The vast majority of databases in use today have some form of web interface , allowing internal and or external users easy access through familiar browser software . If you're security-conscious , you've undoubtedly spent a significant amount of time setting appropriate security permissions on your databases and web servers . Have you also considered the security of the code that powers the database-web interface One common type of
Updated: 2010-04-27 12:54:40
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 2008 Upgrade Advisor Tuesday April 27, 2010 Microsoft provides the SQL Server 2008 Upgrade Advisor SSUA to help you detect upgrade issues before they occur . This tool examines your SQL Server 2000 and SQL Server 2005 databases and checks for any potential conflicts . I strongly recommend using this tool in advance of any attempted upgrade . Read the full article : Using SQL Server Upgrade Advisor Comments 0 See All Posts Share Prev Comments No comments yet . Leave a Comment Leave a Comment Name
Updated: 2010-04-26 22:33:22
As previously noted, I’ve briefly cut back on blogging (and research) due to some family health issues. The first casualty was a post about memcached. One of the two companies to be featured were my new clients at Northscale. The other was Gear6. What they had in common was:
Both Northscale and Gear6 offered distributions of [...]
Updated: 2010-04-26 01:23:00
Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Twitter Weekly Updates for 2010-04-25 Posted in April 25, 2010 8:23 . pmh Lewi No Comments DB Geek says : Twitter Weekly Updates for 2010-04-18 : google_ad_client pub-4372398370642959 468×60, cr http : bit.ly axT2vM Blogged PHP for PL SQL Developers , The Introduction http : it.toolbox.com trd 46 2 38205 3 Blog Comments : Comment on Designing the Data Mart Part 2 by Lazalo : Very good article . Thanks http : bit.ly dBCxr4 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
Updated: 2010-04-25 20:15:44
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 Numering Microsoft Access Database Records Sunday April 25, 2010 In a recent forum message Joe91A wrote : Using ACCESS , how do I display a consecutive number against each detail record on a report This would show 1 against first record , 2 against next , etc . ending with n' equaling the total number of records . Can you help Joe Interested in solutions to the same question Visit the About Databases forum and join the discussion Comments 0 See All Posts Share Prev Comments No comments yet . Leave a
Updated: 2010-04-22 11:13:59
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 The ACID Model of Database Transactions Thursday April 22, 2010 The ACID model is one of the oldest and most important concepts of database theory . It sets forward four goals that every database management system must strive to achieve : atomicity , consistency , isolation and durability . No database that fails to meet any of these four goals can be considered reliable . Read the full article : The ACID Model Comments 0 See All Posts Share Prev Comments No comments yet . Leave a Comment Leave a Comment
Updated: 2010-04-21 10:54:56
Rumors are flying that Google may acquire ITA Software. I know nothing of their validity, but I have known about ITA Software for a while. Random notes include:
ITA Software builds huge OLTP systems that it runs itself on behalf of airlines.
Very, very unusually, ITA Software builds these huge OLTP systems in LISP.
ITA Software is an [...]
Updated: 2010-04-20 18:34:44
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 Automating DMF Policy Enforcement Tuesday April 20, 2010 SQL Server's Declarative Management Framework allows you to create policies with which databases on your SQL Server 2008 system must comply . In previous articles , we examined how to create DMF conditions , create DMF policies , verify policy compliance and manually enforce policies . In this final installment , we look at ways you can automatically manage DMF policy compliance with Microsoft SQL Server . Read the full story : Automating DMF Policy
Updated: 2010-04-20 15:00:00
I have been playing the PL/SQL Challenge quiz every day. It’s a great way to brush up on my PL/SQL skills. After many years of using PL/SQL, I am still learning about features that I have never known before or totally forgotten about. Take for example one of last week’s quiz questions:
What is the output [...]
Updated: 2010-04-19 22:31:30
Life as an elderly person can have Kafkaesque aspects. For example, whether you are allowed to continue to live independently in your own apartment can depend upon whether you are trusted to follow orders for your own good in areas such as:
Taking medication
Walking with proper care
Keeping your feet elevated to let various medical conditions heal
Similarly, [...]
Updated: 2010-04-19 22:23:52
, 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 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 , which lies just 4 miles from our office in West .
Updated: 2010-04-19 01:23:00
DB Geek says: Twitter Weekly Updates for 2010-04-11: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/blFgRo #
Blogged "Why projects fail. Reason #113" http://it.toolbox.com/trd/46/2/37942/3 #
Trying out the officalt blackberry twitter client. Soso #
Twitter for bb makes my red light blink when ANYone I follow tweets. That means my red light never stops. Annoying. #
Powered by Twitter Tools
Updated: 2010-04-18 21:55:44
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 Protecting an Access Database Sunday April 18, 2010 In a recent forum posting mbocho wrote : I have developed an Access database which I would like to protect with a key so that those who use it can pay for it before using . Can someone help me on how to do this Can you help Interested in answers to the same question Visit the About Databases forum and join the discussion Comments 0 See All Posts Share Prev Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your
Updated: 2010-04-18 15:48:15
My clients at Aster Data are putting on a sequence of conferences called “Big Data Summit(s)”, and wanted me to keynote one. I agreed to the one in Washington, DC, on May 6, on the condition that I would be allowed to start with the same liberty and privacy themes I started my New England [...]
Updated: 2010-04-18 15:15:12
Greenplum recently started a website BigDataNews.com, and quickly signed up Aster Data as a co-sponsor. (Edit: As per a comment below, the decision to sign up additional sponsors was made by the site’s independent publisher.) It’s actually being run by Brett Sheppard, a former Gartner/DataQuest analyst who now gets involved in this kind of thing. [...]
Updated: 2010-04-18 14:56:10
Aster Data has started a site mapreduce.org, which purports to compile “the best information about MapReduce.” At the moment, mapreduce.org highlights include:
A feed of MapReduce-related posts from several blogs, including this one.
A calendar of MapReduce-related events, not necessarily Aster-specific, integrated with a feed combining …
… Aster MapReduce-related press releases and also …
… not necessarily Aster-specific [...]
Updated: 2010-04-16 21:50:43
Elder care issues have flared up with a vengeance, so I’m not going to be blogging much for a while, and surely not at any length. That said, my first post about Datameer was never going to be very long, so lets get right to it:
Datameer offers a business intelligence and analytics stack that runs [...]
Updated: 2010-04-16 20:56:56
One of our readers was kind enough to walk me through his analytic DBMS evaluation process. The story is:
The X Company (XCo) has a <1 TB database.
100s of XCo’s customers log in at once to run reports. 50-200 concurrent queries is a good target number.
XCo had been “suffering” with Oracle and wanted to upgrade.
XCo didn’t [...]
Updated: 2010-04-15 16:40:33
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 UNION Queries in SQL Thursday April 15, 2010 SQL's UNION command allows you to combine the results of two or more database queries that are not necessarily linked through a database relationship . For example , imagine that you have a school database and wish to use it to create a master contact list for all students , faculty and staff . Looking at your database , you discover that the records corresponding to each of these constituencies appears in separate database tables . Your first instinct might be
Updated: 2010-04-13 15:46:46
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 Profiler Database Traces Tuesday April 13, 2010 Traces allow you to track the specific actions performed against a SQL Server databases . They provide valuable information for troubleshooting database issues and tuning database engine performance . In this tutorial , we walk through the process of creating a SQL Server Trace with SQL Server Profiler , step-by-step . Read the full article : How to Create a Trace with SQL Server Profiler Comments 0 See All Posts Share Prev Comments No comments yet
Updated: 2010-04-12 05:54:39
Greenplum is making two product announcements this morning. Greenplum 4.0 is a revision of the core Greenplum database technology. In addition, Greenplum is announcing Greenplum Chorus, which is the first product release instantiating last year’s EDC (Enterprise Data Cloud) vision statement and marketing campaign.
Greenplum 4.0 highlights and related observations include:
For the most part, Greenplum 4.0 [...]
Updated: 2010-04-11 16:22:59
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 Trouble Backing up SQL Server Sunday April 11, 2010 In a recent forum message lfowkes1 wrote : We use a 3rd party backup tool to backup SQL databases . We do Full Database backups every night . For some reason , we can't seem to recover SQL to alternate hardware where SQL has not been been previously installed just by doing a recovery from the full backup . Our SQL DBAs have tried a lot of things . Are we missing something Do you have any advice for lfowkes1 Interested in solutions to the same problem
Updated: 2010-04-11 16:22:59
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 Manual DMF Policy Enforcement in SQL Server Thursday April 8, 2010 The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies . It is important to note , however , that this manual reconfiguration cannot resolve all policy compliance issues . SQL Server will be able to modify database settings , reconfigure permissions and perform similar tasks but it cannot , for example , change the name of a stored procedure without administrator
