This week: Your BI and DW dilemmas resolved

[SearchDatabase.com]

Title: SearchDatabase.com

Published by SearchDatabase.com  October 18, 2004 >> Receive this e-mail as text  >> About this e-mail   In this Issue >> From the editor: Your BI and DW dilemmas resolved >> Featured Topic: Analytics: Tips and advice >> Technical Advice: Featured expert advice >> Site Highlights: * Webcast Archive * Best Web links * Looking for a specific data management product?  From the Editor: by Dana McCurley, ExpertAnswerCenter.com Associate Editor As editor of TechTarget's Expert Answer Center, I'd like to make you aware of the site, which spotlights a different featured expert every two weeks. Today marks the start of Ian Abramson's second and final week. You can ask him about the design construction and implementation of data warehouses and on business intelligence deployment. Ian is a guru on Oracle and Cognos, but he's going to take a crack at questions about other products, too. Here's the real beauty of the Expert Answer Center: Ask your question today, get your answer tomorrow. During the next week, Ian will answer questions every day, which means that if you ask your question today, an answer will most likely be posted tomorrow. Where else can you have that immediate resolution to your business intelligence and data warehousing questions? Of course, not all questions asked can be answered. If you want to give your query a better chance of being posted on the site, include as many details as possible. Another charm of the Expert Answer Center is our blog feature. Ian will be posting daily blog entries, to which you can reply if the mood strikes you. Take a look at our topics page for links to ask your questions on upcoming topics and for the dates our experts will be on call. If you ask your question now, you'll be among the first to receive a response when these experts step up to the plate. See you soon on the Expert Answer Center, Dana  Featured Topic: Analytics: Tips and advice by Tim DiChiara, Senior Site Editor With data growing exponentially, business intelligence technologies are essential to maximize revenue and monitor corporate performance. Our collection of BI news, tips, & expert advice is below... Read more about this topic  Expert Technical Advice: Featured Expert Rudy Limeback, Web and SQL Design Consultant, r937.com Category: SQL Rudy has worked with commercial databases since the mid-1970's, starting with IDMS, a Codasyl network system, and progressing through IBM's DB2 and Microsoft's SQL Server relational databases. He has developed data warehouses and transactional databases, always with an emphasis on making them easy to use for developers and end users alike. He specializes in writing SQL statements that are simple and easy to maintain. Rudy now operates r937.com, developing databases for use with dynamic Web sites. Ask him your tough SQL questions! Ask Rudy a question Featured expert advice >> Ask the Expert: Performance of MERGE tables Our MySQL expert Mike Hillyer answers a question about performance with a large table: is it better to keep it large or use multiple, smaller MERGE tables? Tip of the Week: SQL Server: Identifying external or internal table fragmentation This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented). >> Read the full article  Site Highlights Webcast Archive Stay on top of the latest database information. Take a look at the SearchDatabase.com webcast library archive, viewable at any time that is convenient for you. View them now Best Web links Looking to learn more about your IBM DB2 database? Don?t waste your time scouring the web for resources-visit SearchDatabase.com?s Best Web Links on DB2. Browse now Looking for a specific product? Browse our product guide now Save time by browsing SearchDatabase.com?s Product and Vendor Guide. We?ve compiled thousands of database-specific listings in one convenient location and organized each entry into sections that include data quality, EIS, and OLAP, and more. Resources for database pros Select newsletters you would like to receive from the list below. SQL Server White Paper Alerts SQL Server Webcast Alerts E-mail    Not a member? We'll activate your membership with your subscription. Win a trip to Vegas! Attend the SearchSAP.com Conference and qualify for a trip to Las Vegas. You'll also benefit from Q&A sessions with industry experts, networking opportunities and more. Register here TDWI in Orlando Attend TDWI World Conference in Orlando, Oct. 31-Nov. 5, where you will have access to full-day BI/DW training, a special BI Strategies program, our CBIP certification program and more. Register today Database @ SHARE Mark your calendar for SHARE User Events in Anaheim, taking place February 27 ? March 4, 2005 and featuring the most comprehensive user-run IT technical training and education available. Also, celebrate SHARE?s 50th Anniversary! View them now   A B O U T   T H I S   N E W S L E T T E R Contact us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494 This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Updates on new site content": Go to unsubscribe: http://searchDatabase.techtarget.com/unsubscribe?track=NL-78&ad=494782 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed.