|
|
In this Issue |
|
|
From the Editor: |
|
by Tim DiChiara, Senior Site Editor
I'm happy to announce three new additions to our popular Ask
the Experts panel:
- Greg Robidoux and Jeremy
Kadlec - Greg Robidoux is the founder of
Edgewood Solutions, a SQL Server consultancy, and he is currently
the Vice Chair of the PASS DBA SIG. Jeremy Kadlec serves as the
Principal Database Engineer at Edgewood Solutions. He has been
building technical solutions for the last five years, primarily
focused on SQL Server 6.5, 7.0 and 2000. Ask them your tough SQL
Server technical questions or view several that they've already
answered
here.
- Mich
Talebzadeh - Mich is Principal Consultant for
Peridale Ltd, a London-based provider of database solutions to
the financial sector. He knows Sybase backwards and forwards and
is ready to tackle your difficult questions!
I'd like to welcome Greg, Jeremy and Mich to our elite panel
of data management gurus. They promise to make our huge
collection of answered questions (over 2,000!) even more
complete. Take advantage of their expertise and their willingness
to help you in the data management community by submitting a
question today.
Until next time, Tim
|
|
Featured Topic: |
|
Normalization
by Tim DiChiara, Senior 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 below will
help you master this important skill.
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!
Read Rudy's answers to previous questions
|
This Week: In the forums
|
>> |
What is meant by the term "relation"
Member "Allan" is asking what is meant by the term
"relation" in the context of a relational database. Go to our
"DBA Water Cooler" to read how the epxerts responded or offer
your thoughts. |
>> |
IDMS to DB2 migration
Member "Ranji" is looking for the pros and cons of
migrating from IDMS to DB2. Offer your thoughts in our "DB2
Server Tech Forum".
|
Tip of the Week: |
Learning Guide: Solving common DB2 errors
When you get an error code in DB2, it's easy enough
to look it up in the Messages and Codes manual. But knowing what
is wrong doesn't always help you to solve the problem. Here, DB2
guru Craig Mullins helps SearchDatabase.com members solve some
common SQL errors.. |
>> |
Read complete tip |
|
Site Highlights |
|
|
Learning Guide: SQL Server Basics
Looking to brush up on your SQL Server skills? This SearchDatabase.com Learning Guide highlights information critical for any DBA looking to brush up on SQL Server information.
Browse the SQL Server Learning Guide
Sign up for the SearchDatabase.com Daily News
Log in to SearchDatabase.com, edit your member profile and sign up for the Daily News. You'll receive the latest database industry and product announcements, as well as technology analysis and reviews.
Sign up now
|
|
|
|
Featured webcast, "Oracle Clusters: What You Need to Know"
Tune in to this webcast now
Tune in to this webcast and learn how to achieve highly available Oracle9i & scalable Oracle9i RAC. You'll also hear how inexpensive servers, fibre channel SANs and flexible database cluster technology are transforming the data center, how to build manageable clusters and more.
Sponsored By: PolyServe, Inc.
|
|
|
|
|
Targeted database resources
|
|
Select newsletters you would like to receive from the list below. |
|
|
DB2 Tips |
|
Daily News |
|
Database Administrator Tips |
|
|
E-mail
|
|
Not a member? We'll activate your membership with your subscription. |
|
|
|
Oracle newsletters |
Sign up for SearchOracle.com newsletters and receive accurate information, industry insights and advice from leading Oracle experts through targeted newsletters. |
Sign up now |
|
Sybase white papers |
Wish you knew more about Sybase? Check out the SearchDatabase.com White Paper Library and browse our collection of Sybase white papers. |
Browse now |
|
Product Guide |
Visit the SearchDatabase.com Product and Vendor Guide and access targeted product comparisons and vendor solutions across such categories as "Database Acceleration" and more. |
Browse now |
|
|
|