http://www.enzeecommunity.com/index.jspa?view=blog Latest Blog Posts in The Netezza Community en Sun, 30 Oct 2011 02:19:32 GMT Jive SBS 4.5.3 (http://jivesoftware.com/products/clearspace/) 2011-10-30T02:19:32Z en http://www.enzeecommunity.com/blogs/grill/2011/10/29/adapting-the-infrastructure--scalable-backups-of-billions-of-rows When introducing the Netezza platform to a new environment, or even trying to leverage existing technologies to support it, very often the infrastructure admins will have a lot of questions, especially concerning backups and disaster recovery. Not the backup scalable archive scale infrastructure high capacity disaster recovery Sun, 30 Oct 2011 02:19:32 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/10/29/adapting-the-infrastructure--scalable-backups-of-billions-of-rows 2011-10-30T02:19:32Z 3 months, 1 week ago 0 http://www.enzeecommunity.com/blogs/grill/comment/adapting-the-infrastructure--scalable-backups-of-billions-of-rows http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1220 http://www.enzeecommunity.com/blogs/grill/2011/08/26/window-to-the-sanctum "What's this?" asked the CFO of the Data Warehousing Director, now holding a fresh-off-the-press request for more hardware. "We've hit capacity," said the Director with a sigh, lowering himself wearily into a padded chair. "What? That machine is barely admin observation deck brightlight administration trending Fri, 26 Aug 2011 13:40:33 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/08/26/window-to-the-sanctum 2011-08-26T13:40:33Z 5 months, 1 week ago 0 http://www.enzeecommunity.com/blogs/grill/comment/window-to-the-sanctum http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1219 http://www.enzeecommunity.com/blogs/grill/2011/08/03/hairball-plotter-and-the-half-baked-stints Host: Ladies and Gentlemen, I'm your host here with Hairball Plotter- Hairy: Call me Hairy Host: (Pause) Oookay, I'm here with Hairy Plotter and he's going to tell us about some of his - er - Hairy: Innovations Host: Innovations? I thought they were control architecture scalable organized hairball configuration expedient Wed, 03 Aug 2011 17:17:23 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/08/03/hairball-plotter-and-the-half-baked-stints 2011-08-03T17:17:23Z 6 months, 5 days ago 0 http://www.enzeecommunity.com/blogs/grill/comment/hairball-plotter-and-the-half-baked-stints http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1218 http://www.enzeecommunity.com/blogs/grill/2011/07/19/true-bleed--a-spooki-stakehouse-story "You hate me don't you?" she whimpered, teary-eyed. "Nobody hates you, Spooki," Bill assured, "It's just business." "Just business?" she spat, the hurt spilling from her mouth, "Who died and made you king?" "I thought you didn't want to hear about it." Tue, 19 Jul 2011 14:16:55 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/07/19/true-bleed--a-spooki-stakehouse-story 2011-07-19T14:16:55Z 6 months, 2 weeks ago 0 http://www.enzeecommunity.com/blogs/grill/comment/true-bleed--a-spooki-stakehouse-story http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1217 http://www.enzeecommunity.com/blogs/grill/2011/07/04/enzee-universe-afterglow I offer a simple note of thanks to the folks at IBM Netezza who executed what is arguably the best Enzee Universe ever.   I also thank the many of you who attended the Best Practices sessions on Monday. I counted over 450 in attendance just by enzee universe birmingham youtube Mon, 04 Jul 2011 15:59:52 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/07/04/enzee-universe-afterglow 2011-07-04T15:59:52Z 7 months, 5 days ago 0 http://www.enzeecommunity.com/blogs/grill/comment/enzee-universe-afterglow http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1216 http://www.enzeecommunity.com/groups/enzee-universe/blog/2011/06/28/netezza-variable Basically I have a query built that includes four sub queries.I use a timestamp in each one of the sub queries WHERE clause, and is becoming tedious to update this everytime I run the query. Is it possible to DECLARE a variable as a time stamp and then Wed, 29 Jun 2011 02:29:04 GMT communityadmin@netezza.com http://www.enzeecommunity.com/groups/enzee-universe/blog/2011/06/28/netezza-variable 2011-06-29T02:29:04Z 7 months, 1 week ago 1 0 http://www.enzeecommunity.com/groups/enzee-universe/blog/comment/netezza-variable http://www.enzeecommunity.com/groups/enzee-universe/blog/feeds/comments?blogPost=1215 http://www.enzeecommunity.com/blogs/grill/2011/05/25/netezza-transformation-on-amazoncom The long-awaited "SQL" to Netezza Underground has hit Amazon.Com.   http://www.amazon.com/Netezza-Transformation-without-alchemy-sorcery/dp/1453874054/ref=sr_1_1?ie=UTF8&s=books&qid=1306624705&sr=1-1   This book tackles some deeper Wed, 25 May 2011 20:20:08 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/05/25/netezza-transformation-on-amazoncom 2011-05-25T20:20:08Z 8 months, 2 weeks ago 0 http://www.enzeecommunity.com/blogs/grill/comment/netezza-transformation-on-amazoncom http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1214 http://www.enzeecommunity.com/groups/enzee-universe/blog/2011/05/25/kill-command-causes-nps-bounce-in-mustang Earlier I noticed (in mustang)  that an attempt to kill a netezza database process using 'Kill' command results in NPs bounce.   But few days back, an attempt to kill a nzbackup process was successful with 'kill' command (as we could not abort Wed, 25 May 2011 13:39:54 GMT communityadmin@netezza.com http://www.enzeecommunity.com/groups/enzee-universe/blog/2011/05/25/kill-command-causes-nps-bounce-in-mustang 2011-05-25T13:39:54Z 8 months, 2 weeks ago 0 http://www.enzeecommunity.com/groups/enzee-universe/blog/comment/kill-command-causes-nps-bounce-in-mustang http://www.enzeecommunity.com/groups/enzee-universe/blog/feeds/comments?blogPost=1213 http://www.enzeecommunity.com/blogs/grill/2011/05/19/enzee-universe-is-on Okay folks, the Enzee Universe is upon us and the Best Practice sessios is fired up, the power is vibrating the tracks and the train is about to leave the station. It's a good ride - so get on it.   We have a lot of stuff planned for the Best netezza conference enzee universe enzee_universe best practice twinfin newbie Thu, 19 May 2011 21:35:25 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/05/19/enzee-universe-is-on 2011-05-19T21:35:25Z 8 months, 2 weeks ago 0 http://www.enzeecommunity.com/blogs/grill/comment/enzee-universe-is-on http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1212 http://www.enzeecommunity.com/blogs/grill/2011/05/02/managing-least-to-greatest A question I receive often can be characterized as "do I really need to do this for smaller tables? Isn't this only necessary for larger tables?"   And the question could run the gamut from things like when-to-use-bigint to performance enzee practice twinfin broadcast distribution bigint Mon, 02 May 2011 17:55:15 GMT communityadmin@netezza.com http://www.enzeecommunity.com/blogs/grill/2011/05/02/managing-least-to-greatest 2011-05-02T17:55:15Z 9 months, 1 week ago 0 http://www.enzeecommunity.com/blogs/grill/comment/managing-least-to-greatest http://www.enzeecommunity.com/blogs/grill/feeds/comments?blogPost=1211