Updated: 2010-06-30 08:37:37
Todd Hoff (High Scalability blog) posted a lengthy examination of the case and use cases for VoltDB. That excellent post, in turn, is based on a Mike Stonebraker* webinar for VoltDB, for which the slide deck is happily available. It’s all nicely consistent with what I wrote about VoltDB last month, in connection with its [...]
Updated: 2010-06-29 07:40:27
In a recent forum message, Andrew wrote:
"I have been trying to achive something for some time now and was wondering if anyone could help out. I have a database ...Read Full Post
Updated: 2010-06-27 09:09:41
Infobright called a couple weeks ago to discuss, among other subjects, its subsequently-released Infobright Release 3.4. I made no effort to distinguish between community/open source and professional/chargeable editions, but leaving that aside, it seems fair to characterize Infobright 3.4 as having two overlapping primary themes:
Performance and bottleneck cleanup.
“Omigod, you mean you didn’t have that feature [...]
Updated: 2010-06-27 06:34:25
Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use ...Read Full Post
Updated: 2010-06-27 05:35:28
A number of vendors had announcements last week, notably:
Netezza (user conference)
Aster Data (to steal some of Netezza’s thunder)
Infobright (so far as I can tell, just because it was time for a product release, and also to get ahead of the summer doldrums)
Northscale (ditto)
Time to play some catchup.
I’ll start with Aster Data, which added to the [...]
Updated: 2010-06-26 06:17:11
EnterpriseDB has some deplorable business practices (my stories of being screwed by EnterpriseDB have been met by “Well, you’re hardly the only one”). But a couple of more successful DBMS vendors have happily partnered with EnterpriseDB even so, to help pick off Oracle users. IBM’s approach was in the vein of an EnterpriseDB-infused version of [...]
Updated: 2010-06-25 10:42:26
I really, really wanted to title this post “Flash is coming in a flash.” That seems a little exaggerated — but only a little.
Netezza now intends to come out with a Flash-based appliance earlier than it originally expected.
Indeed, Netezza has suspended — by which I mean “scrapped” — prior plans for a RAM-heavy disk-based appliance. [...]
Updated: 2010-06-24 21:46:44
The TRY...CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and ...Read Full Post
Updated: 2010-06-23 05:33:18
Netezza’s Enzee Universe conference is now almost over, and I still haven’t figured out what my gig as “conference blogger” entails. More precisely, I’m operating from our unspoken fallback plan, namely “If all else fails, do what you’d do anyway, but do more of it.” For me to live up to that, all Netezza had [...]
Updated: 2010-06-22 07:38:42
In a recent forum message, Norma asked:
"I own a small business (staffing agency) run out of my home. I have one associate besides myself. We are using ...Read Full Post
Updated: 2010-06-21 06:15:17
I took advantage of my recent conversations with Netezza and IBM to discuss what kinds of data warehouse load latency were practical. In both cases I got the impression:
Subsecond load latency is substantially impossible. Doing that amounts to OLTP.
5 seconds or so is doable with aggressive investment and tuning.
Several minute load latency is pretty easy.
10-15 [...]
Updated: 2010-06-21 06:05:47
Thursday, I spent 3 ½ hours talking with 10 of Netezza’s more senior engineers. Friday, I talked for 1 ½ hours with IBM Fellow and DB2 Chief Architect Tim Vincent, and we agreed we needed at least 2 hours more. In both cases, the compression part of the discussion seems like a good candidate to [...]
Updated: 2010-06-21 06:00:12
As I’ve mentioned in a couple of other posts, Netezza is stressing that the most recent wave of its technology is software-only, with no hardware upgrades made or needed. In other words, Netezza boxes already have all the silicon they need. But of course, there are really at least three major aspects to the Netezza [...]
Updated: 2010-06-21 05:57:35
Netezza is having its user conference Enzee Universe in Boston Monday–Wednesday, June 21-23, and naturally will be announcing new products there, and otherwise providing hooks and inducements to get itself written about. (The preliminary count is seven press releases in all.) To get a head start, I stopped by Netezza Thursday for meetings that [...]
Updated: 2010-06-20 07:45:57
Database professionals around the world are heralding the release of MySQL 5, just in time for the holiday season! This major release of the popular open-source database packs in quite ...Read Full Post
Updated: 2010-06-17 23:04:42
, 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 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 , which lies just 4 miles from
Updated: 2010-06-17 06:45:16
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of ...Read Full Post
Updated: 2010-06-16 21:23:30
So what can I say? One of the phrases I hate most is “We’ve had problems with that.” I have seen that, or some form of that, question used as an excuse to not try new features, to not use best practices, keep a head in the sand, stick to Oracle7 features, etc.
As an example, in my early days with data modeling, I once created a new schema. It wasn’t a very big schema;… Read the rest!
Updated: 2010-06-15 06:36:41
In a recent forum message, macvidur asked:
"In Multiple row sub queries we use IN, ANY and ALL. ANY and ALL both seem to compare each and every value in the ...Read Full Post
Updated: 2010-06-15 06:23:00
Blogged "Stupid Proc Tricks -The Weird and Wonderful Overload" http://it.toolbox.com/trd/46/2/39311/3 #
My 2 year old turned off the refrigerator and unscrewed the light bulb. I fear what he will do when he discovers the screw driver. #
DB Geek says: Stupid Proc Tricks -The Weird and Wonderful Overload: <!–
google_ad_client = "pub-4372398370642959"… http://bit.ly/bPVMI2 #
Powered by Twitter Tools
Updated: 2010-06-15 01:19:59
When overloading a procedure or function it is the calling parameters that make the difference. The return type does not make a difference as far as the ability to overload. Generally, when talking about overloaded procedures, you will hear or read something like “You must change at least one of the parameter data types to overload it.” But that’s not really true.
Read more about Stupid Proc Tricks -The Weird and Wonderful Overload
Updated: 2010-06-13 07:37:22
With the May 2010 release of SQL Server 2008 R2, many database professionals wondered why Microsoft didn't increment the product's name to SQL Server 2010. Indeed, there is a ...Read Full Post
Updated: 2010-06-10 21:41:44
Steven Feuerstein published a new presentation titled: Golden Rules for Developers [PDF].
Here is a summary of his seven “golden rules” that will help you write better code:
Don’t repeat anything.
Hide everything.
Don’t take shortcuts.
Embrace standards.
Build on a foundation.
Never lose information.
Don’t write code alone.
Agreed with all. I would also add an eighth one: Understand your data.
What would you [...]
Updated: 2010-06-10 06:07:02
Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of ...Read Full Post
Updated: 2010-06-10 02:24:44
Home What is LinkedIn Join Today Sign In In order to see this profile , you need to join LinkedIn Why Join LinkedIn Discover the people around you Easily connect with long-lost colleagues Show who you know in common Join Now Already a User Please enter your email address and password to access this . profile : Email address : Password Forgot password Make sure you have cookies and Javascript enabled in your browser before signing . in Customer Service About Blog Careers Advertising Recruiting Solutions Tools Developers Language Deutsch English Español Français Italiano Português LinkedIn Updates LinkedIn Answers LinkedIn Jobs Jobs Directory Company Directory Service Provider Directory LinkedIn Corporation 2010 User Agreement Privacy Policy Copyright Policy
Updated: 2010-06-08 07:06:31
SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center.
Read ...Read Full Post
Updated: 2010-06-04 22:59:45
Talking to Algebraix reminded me that David Childs is still alive and kicking. I only ever encountered Childs once, in the early/mid-1980s, when he was pushing his company Set Theoretic Information Systems. The main customer example for STIS was General Motors, for which he had achieved a remarkable amount of database compression. It was something [...]
