SEARCHDATABASE.COM: This Week February 10, 2003 ___________________________________ IN THIS ISSUE __________________________________
>From the editor: Pointing fingers for Slammer Featured Topic: Normalization Expert Technical Advice: New expert advice, forum posts, and tips Site Highlights: * Webcast: Unraveling the complexities of DB2 stored procedures * Data Center Futures | June 4-6 |Chicago * Webcast: Impossible data warehouse situations >From the Editor: __________________________________ by Tim DiChiara, Site Editor Last week, we posed the question: Who's to blame for the SQL Slammer worm? Over 500 of you responded, but this passion didn't translate into a clear "winner." Here are the results: Both - 34% Microsoft - 30% SQL Server administrators - 20% Neither - 17% It seems you were quite fair in assigning blame: the results demonstrate that everybody had a role in the outbreak. At least that's what you database geeks believe. Our sister site SearchSecurity.com, which has fewer DBAs in its audience, ran the same poll and received 600 votes. The results were similar, with one glaring exception: significantly more people blamed SQL Server admins. It seems that the blame is distributed according to who is doing the blaming! Sound familiar? A Chinese proverb comes to mind: "If one's face is ugly, one cannot blame the mirror." After you've taken the responsibility for your role in security, check out SearchDatabase.com's plethora of resources to help you secure your SQL Server, Oracle, and DB2 databases: * Webcast: SQL Server security best practices http://searchdatabase.techtarget.com/newsItem/0,289139,sid13_gci863947,00.html * Ask our database gurus your security questions. http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html * Top 10 SQL Server security blunders http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci874688,00.html * All our database security tips, scripts, and advice. http://searchDatabase.com/r/0,,10101,00.htm Till next week, Tim Featured Topic: __________________________________ Normalization Optimal normalization is the key to good database design. And good design is the key to optimal database performance, efficiency, and integrity. The tips and expert advice inside will help you master this important skill. http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci879196,00.html Expert Technical Advice: __________________________________ Featured Expert Karen Morton, Owner, Morton Consulting, Inc http://searchdatabase.techtarget.com/ateExpertBio/0,289623,sid13_cid404542,00.html Category: Oracle Karen has over 15 years IT experience and 10 years Oracle experience. She has co-authored several Oracle training coursebooks and taught hundreds of individuals in skills ranging from introductory Oracle to advanced DBA topics. She holds a B.S. in Computer Science and additionally holds OCP DBA credentials for Oracle 8i. Ask her your tough Oracle questions! View all Karen's answers http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax289342,00.html This Week: In the forums Upgrade Oracle from 32- to 64-bit Member "oracleperl" is about to upgrade his Oracle 9i system to 64-bit. Has anybody done this? Any tips or caveats? Go to our "DBA Water Cooler" if you can offer any suggestions. http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html GUI administration tool for Sybase Member "Sybase Novice" is looking for a freeware or shareware GUI administration tool for Sybase v11.0.3 on Linux. Go to our "DBA Water Cooler" if you can help. http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html TIP OF THE WEEK DB2's DATE data type This article describes how IBM implements the DATE data type for DB2 and discusses what calendar is used, what the JULIAN_DAY function really does, why date arithmetic is random, how to calculate birthdays, and how to find month ends using DB2. http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci876846,00.html SITE HIGHLIGHTS __________________________________ >> Learn more about DB2 stored procedures View this webcast: "Unraveling the complexities of DB2 stored procedures" David Cohn provides an overview of DB2 stored procedures on OS/390, the mechanisms for using them and the SQL/PSM language. http://searchDatabase.com/r/0,,10091,00.htm Data Center Futures | June 4-6 |Chicago Free conference -- confirm your registration by April 15 for your free attendance Attend this independent conference that will help you set your strategy today for the most scalable, reliable data center. http://datacenterfutures.com Webcast: Impossible data warehouse situations Attend this webcast with experts Chuck Kelley and Sid Adelman today Get advice from experts who know how to plan and implement data warehouses. You'll hear about the solutions to common crises that companies face when building complex data warehouses. Listen as these experts discuss their personal experiences about the reality of data warehousing not covered in basic texts. http://searchDatabase.com/r/0,,10092,00.htm ---------------------- FREE EMAIL SERVICES! ---------------------- Please sign up for Oracle Tips, its a great e-mail. http://searchDatabase.techtarget.com/tieredRegPage?val=0&newsletters=796390&email= Tangible tips __________________________________ Sign-up for the SearchSystemsManagement.com Top Expert Advisor newsletter and receive valuable expert advice on performance mgmt., network mgmt., desktop mgmt. and much more. http://searchSystemsManagement.com/r/0,,10040,00.html Featured Topics __________________________________ Don't overlook one of the best resources -- featured topics provide you with anything from news, links, advice and books. Check them out now and spend less time doing research. http://searchDatabase.com/r/0,,10090,00.htm ***************** ABOUT THIS NEWSLETTER ******************* Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. Unsubscribe from 'Updates on new site content' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://searchDatabase.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."