This week: Ask the SQL expert

[SearchDatabase.com]

Title: SearchDatabase.com

Published by SearchDatabase.com  June 21, 2004 >> Receive this e-mail as text  >> About this e-mail   In this Issue >> From the editor: New forums redux >> Featured Topic: Ask the SQL expert >> Expert Technical Advice: Featured expert advice >> Site Highlights: * Check out our exclusive SQL Server Security Learning Guide * Data security white papers at your fingertips * Chapter excerpt: "Database Management with SQL Server 2000"  From the Editor: by Tim DiChiara, Editor We've finally resolved some technical difficulties with our new discussion forums -- they're back online now. Thanks for your patience! In case you missed it, here was the original announcement... By popular demand, I'm happy to announce several new additions to SearchDatabase.com: two new discussion forums for our members using Sybase and MySQL systems. Several years ago, Oracle's Larry Ellison declared Sybase "dead. May they rest in peace." Apparently, the thousands of Sybase users -- especially in the financial services industry -- never heard that news flash. Sybase is hanging tough and a very vocal segment of our membership has campaigned for more Sybase content. Done. We aim to please! MySQL recently released a significant new version boasting many enterprise-level features, as well as partnering with heavyweights such as SAP. In the past, we've resisted covering MySQL because we considered it more of a "hobby-grade" DBMS, not worthy of supporting mission-critical demands. Times have changed and the use of MySQL is growing rapidly in large firms. Let's hear your thoughts about MySQL and Sybase in the new forums, as well as your technical administration and development questions! Of course, our famous Ask the Expert section also contains some quality Sybase and MySQL advice and tips... not to mention thousands of answers to your SQL, DB2, and SQL Server questions as well. If you want a certified expert perspective, or if you're not in a hurry to get an answer, submit your question there. Enjoy, and thanks for your continued support! Cheers, Tim  Featured Topic: Ask the SQL expert by Tim DiChiara, Senior Site Editor Our expert Rudy Limeback has been in the database field for 25 years and he knows his SQL. Browse his hundreds of answers to your tough SQL questions inside... Read more about this topic  Expert Technical Advice: Featured Expert Mike Hillyer, Founder, VBMySQL.com Category: MySQL Mike Hillyer is the founder of VBMySQL.com, a popular site for Windows users of MySQL. He holds the MySQL Professional Certification and is the top ranked MySQL expert at Experts-Exchange.com. Mike has written several articles that have been featured in the MySQL newsletter and was a speaker at both the 2003 and 2004 MySQL User Conferences. Mike currently works on the MySQL AB documentation team. Ask Mike a question Featured expert advice >> Ask the Expert: Rebuilt statistics with rebuilt indexes? Our SQL Server experts Greg Robidoux and Jeremy Kadlec answer the question: "When I rebuild my indexes with DBCC DBREINDEX, does SQL Server also rebuild my statistics?" Tip of the Week: DB2: Remote administration with DAS The DB2 Administration Server (DAS) assists with tasks on DB2 servers. Learn how to enable remote administration of DB2 servers with DAS in this tip. >> Read complete tip  Site Highlights Check out our exclusive SQL Server Security Learning Guide Download SearchDatabase.com's newest learning guide and get SQL Server security best practices, how-tos, information on updates and patches, lessons from hackers and more. Access learning guide now Data security white papers at your fingertips Looking for tips on how to best secure your database? Check out SearchDatabase.com's data security white papers and access such titles as "DB2 security and instances" and more. Download data security white papers now Chapter excerpt: "Database Management with SQL Server 2000" Sign up now and download Chapter 14 Activate your membership to SearchSmallBizIT.com and for a limited time, download Chapter 14, "Database Management with SQL Server 2000" from Harry Brelsford's book "Windows Business Server 2003 Best Practices." Resources for database pros Select newsletters you would like to receive from the list below. E-Business Suite Update Today's News Small Business IT Tech Tip E-mail    Not a member? We'll activate your membership with your subscription. Daily News Zero in on what's going on in the database industry - activate your subscription to SearchDatabase.com's "Today's News" and get each day's headlines delivered right to you. Sign up now Webcast Library Weren't able to attend SearchDatabase.com's last live webcast? Check out our Webcast Library and view our collection of database webcasts, viewable at any time that is convenient for you. View webcasts Database terms Beef up your database vocabulary -- check out SearchDatabase.com's Glossary and view definitions to such terms as "CDI" and more. Browse terms   A B O U T   T H I S   N E W S L E T T E R Contact us: SearchDatabase MemberServices 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=485363 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.