![]() |
|
|
In this Issue |
![]() |
![]()
![]()
|
|
From the Editor: |
![]() |
![]()
![]()
by Tim DiChiara, Senior Site Editor
![]()
SearchDatabase.com's 170,000 members use the site for multiple reasons: to keep up with the latest industry news, to find answers to specific technical problems, and to educate themselves about the plethora of data management technologies.
I'd like to announce a new series that I hope will serve your general educational needs: Learning Guides. Here is a sampling of what we've prepared so far:
- The database - What is a database, the relational model, Codd's rules, database types, good database design, and normalization? Take the quiz at the end to see how much you learned.
- SQL Server basics - This learning guide highlights basic SQL Server information that can help Oracle and DB2 pros get up to speed on the increasingly popular system.
- DB2 basics - DB2 took top honors in some DBMS market share reports this year, which means many companies may have already, or will soon be, switching over to IBM's brand of data management. With that in mind, we created this learning guide, highlighting basic DB2 information that can help Oracle and SQL Server pros get up to speed.
- 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...
- Becoming an Oracle Certified Proessional - Whether you're an Oracle newbie or a self-proclaimed guru, getting an Oracle Certified Professional seal of approval may still be your key to staying afloat in a tough economy. This learning guide is designed to give you expert technical advice on where to begin your certification studies, passing the final exam and putting your certification into effect in the workplace.
More to come, so stay tuned....
Until next time, Tim
|
![]()
|
|
Featured Topic: |
![]() |
![]()
T-SQL tips and scripts
by Tim DiChiara, Senior Site Editor
![]()
Transact-SQL is a set of programming extensions to the Structured Query Language developed by Sybase and Microsoft. The free tips, scripts, and expert advice inside will help DBAs and developers master T-SQL scripting.
![]()
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
|
| >> |
Connection pooling advantages
Member "Daisy" is wondering if there are any other advantages to using a database connection pool besides saving the cost of opening and closing new physical connections? Go to our "DBA Water Cooler" to offer your thoughts.
|
| >> |
Updating 70,000 records
Member "Ranga" is having a problem doing an update on a particular two-column table. Check out Ranga's SQL and give him your advice in our "SQL Server Tech Forum".
|
![]()
| Tip of the Week: |
Find the space occupied by all tables and indexes
Here's a quick undocumented method to find the space occupied by all
tables and indexes in a SQL Server 2000 database. |
| >> |
Read complete tip |
![]()
|
|
Site Highlights |
![]() |
![]()
![]() |
Sign up for SearchDatabase.com's DB2 Tips newsletter
Don't miss out! Sign up for the DB2 Tips newsletter and receive expert advice on IBM DB2 development, management, performance, migration, integration and more.
Sign up now
![]()
Registration now open for the SearchSAP.com Conference Europe
Don't miss out! Join us in London, March 10-12, 2004 for the SearchSAP.com Conference Europe and attend such sessions as "SAP Alternatives: Fact or Fiction?", "The SAP Road Map: How to Maximize your SAP ROI" and more.
Register now to secure your spot
|
![]() |
![]() |
![]() |
Featured webcast: "Seven steps to an integrated enterprise"
Tune in now
Looking to learn more about Enterprise Integration? Tune in to SearchDatabase.com's featured webcast and learn a reliable process for delivering integrated systems across any enterprise.
Sponsored By: Smart CRM Conference
|
![]() |
![]()
|
![]() |
![]()
![]() |
|
Newsletters for database pros
|
![]() |
| Select newsletters you would like to receive from the list below. |
![]() |
|
Database Administrator Tips |
|
Ask the Database Experts |
|
Oracle E-Business Suite Update |
|
![]() |
E-mail
|
|
|
| Not a member? We'll activate your membership with your subscription. |
![]() |
|
|
![]()
| Salary Survey |
| How does your paycheck measure up? Visit SearchDatabase.com's new Career Center and take our comprehensive salary survey. View results by title, industry, company size and more. |
![]() Take the survey |
|
![]()
![]()
| Oracle newsletters |
| Sign up for SearchOracle.com newsletters and receive accurate information, industry insights, tips and advice targeted at Oracle pros. |
![]() Sign up now |
|
![]()
| Product Guide |
| Visit the SearchDatabase.com Product and Vendor Guide and access targeted product comparisons and vendor solutions across such categories as "Data Scrubbing" and more. |
![]() Browse now |
|
![]()
|
![]() |
