![searchDatabase]() ![This Week]() |
![]() |
![]() |
|
|
In this Issue |
![]() |
![]()
![]()
|
|
From the Editor: |
![]() |
![]()
![]()
by Tim DiChiara, Senior Site Editor
![]()
In the latest installment of our popular "DBA Profiles" series, the president of the Professional Association of SQL Server users (PASS) reveals a secret from his past.
He used to be an Oracle DBA and even wrote a book about Oracle tools. I can hear your collective gasps from here.
Kevin Kline does not gloat, however. He sounds a conciliatory note in the ongoing database wars, saying that both Oracle and Microsoft databases have strengths in specific environments. For example, Oracle has a more robust native language for stored procedures, yet SQL Server has a much more effective set of tools. With SQL Server, it's easier and faster to get up and running, while Oracle is a
smart choice for applications that rely on stored procedures, Kline says.
"For DBAs in a heterogeneous world, it's not too difficult to get to like and know each database for its own capabilities," Kline said.
Bravo Kevin!
Read his full profile here and our collection of other DBA profiles here.
Till next week, Tim
|
![]()
|
|
Featured Topic: |
![]() |
![]()
Normalization
by Tim DiChiara, Senior Site Editor
![]()
Optimal normalization is key to good database design. And good design is key to optimal DBMS performance, efficiency, and integrity. The tips and expert advice below will help you master this important concept.
![]()
Read more about this topic
|
![]()
|
|
Expert Technical Advice: |
![]() |
![]()
![]()
Featured Expert Mike Lampa
Categories: Data warehousing and business intelligence
Mike is co-founder and CEO of BAG, a Texas-based business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients.
![]()
Read Mike's answers to previous questions
|
![]()
|
This Week: In the forums
|
| >> |
SQL Server migration help needed
Member "Annaraj" has two databases with tables that have identity primary keys generated by autonumber and these primary keys are used by the others' table as a foreign key. Now he needs to copy all data from one location to the other. How can he do this and preserve the PK? Give him your two cents in our "DBA Water Cooler."
|
| >> |
DB2 ODBC connection issues
Member "dan" is trying to set up an ODBC connection on his Win2k workstation to a DB2 database running on z/OS but is feeling like a "fish out of water." Lend him a hand in our "DB2 Tech Forum." |
![]()
| Tip of the Week: |
Former Oracle DBA falls for SQL Server
Meet Kevin Kline, a former Oracle DBA and a current SQL Server expert, and find out why Microsoft gets him all worked up. |
| >> |
Read complete tip |
![]()
|
|
Site Highlights |
![]() |
![]()
![]() |
Access DB2-specific webcasts on SearchDatabase.com
Check out SearchDatabase.com's new Webcast Library, now searchable by topic, speaker or sponsor and tune in to such webcasts as "DB2 for z/OS Security" and more.
Check out DB2 webcasts now
![]()
DB2 tips right at your fingertips
Looking for IBM DB2-specific tips? Activate your subscription to SearchDatabase.com's DB2 Tips newsletter and get expert advice on DB2 development, management, performance, migration, integration and more.
Sign up now!
|
![]() |
![]() |
![]() |
Browse SearchDatabase.com's exclusive SQL Learning Guide
Download this guide now
With eight informative chapters packed with advice from SQL experts Rudy Limeback and Joe Celko, SearchDatabase.com's SQL Learning Guide will help you learn how to get the data you need by looking at solutions to real-world problems.
|
![]() |
![]()
|
![]() |
![]()
![]() |
|
Resources for database pros
|
![]() |
| Select newsletters you would like to receive from the list below. |
![]() |
|
Database Administrator Tips |
|
Daily News |
|
Oracle E-Business Suite Update |
|
![]() |
E-mail
|
|
|
| Not a member? We'll activate your membership with your subscription. |
![]() |
|
|
![]()
| Job openings! |
| Hiring trends are picking up, so don't get left behind! Check out SearchDatabase.com's Career Center and find the resources you'll need to make that next job move. |
![]() Browse jobs |
|
![]()
![]()
| Reserve your seat |
| Attend Data Center Decisions and come away with advice that you can apply to your organization right away - visit the site today, browse the sessions and speaker bios and sign up to attend for FREE! |
![]() Register now! |
|
![]()
| Glossary |
| Stumbling over database jargon? From PL/SQL to DBMS, the SearchDatabase.com Glossary offers comprehensive definitions for hundreds of database terms. |
![]() Browse glossary |
|
![]()
|
![]() |
![]() |
|
