THIs WEEK: Normalization

[SearchDatabase.com]

Title: TechTarget

February 10, 2003 >> Receive this email as text  >> About this email   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 Ask our database gurus your security questions. Top 10 SQL Server security blunders All our database security tips, scripts, and advice. Till next week, Tim  Featured Topic: Normalization by Tim DiChiara, Site Editor 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. Read more about this topic  Expert Technical Advice: Featured Expert Karen Morton, Owner, Morton Consulting, Inc 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 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. >> 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. Tip of the Week: 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. >> DB2's DATE data type  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. 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. 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. FREE EMAIL SERVICES! Select newsletters you would like to receive from the list below. Oracle Tips DB2 Tips Ask the Database Experts Email:     Not a member? We'll activate your membership with your subscription. 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. Subscribe now 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. Just click here A B O U T   T H I S   N E W S L E T T E R Created by TechTarget TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. To 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".