;) |
| In this Issue | |
| From the Editor: | |
by Tim DiChiara, Site Editor
As I'm sure all you faithful searchDatabase members know, we hold a Tip Exchange Contest each month. Congratulations to Rohit Sinha, winner of January's tip prize, a Philips MP3-CD player! Rohit will be inducted into our Hall of Fame for his Oracle tip, Total record count per schema. Congrats also to our runner-up Craig Roberts for his tip Change the SQL prompt. If you haven't participated in our Tip Exchange, give it a try. You don't need to be a Ph.D. or a super-guru to submit a tip. The majority of our most highly rated tips are simple shortcuts that help get the job done faster and better. You've all learned little workarounds that help you; the Tip Exchange is where Oracle, SQL Server, and DB2 pros come together to share these hints. Sure, we receive submissions from database gods like Joe Celko, whose latest tip Converting an adjacency list model to a nested set model is "SQL for Smarties" indeed. Mere mortals can just think of something that helps you work more effectively and that could help others, too. You just might win our new February prize, a very cool Compaq Disk-on-Key. Submit your tips today! Till next time, Tim DiChiara, Editor |
| Featured Topic: | |
Spotlight on SQL
by Tim DiChiara , Site Editor
The structured query language is the lingua franca of all the major database management systems. Here is a collection of SQL tips, tutorials, and expert advice. Newbie and guru alike will find something here!
Read more about this topic
|
| Expert Technical Advice: | |
Featured Expert: Ian Abramson, CTO, Ian Abramson Systems Inc.
Category: Data warehousing: ETL
Ian has over 14 years experience with data warehouse and Oracle systems and has written six books on the topic. Ask Ian your toughest data warehousing questions!
View all of Ian Abramson's answers |
| This Week: In the forums |
| >> |
SQL Server to Oracle replication
Member "Anu" needs to do a reverse replication from SQL Server to Oracle 8i. Is this possible? Go to our "DBA Water Cooler" forum if you can lend Anu a hand. |
| >> |
DB2 performance degrading
Manju has a general question about improving performance on DB2. He's on Win2000, running 2 instances and 6 databases. Any help out there? If so, go to our "DBA Water Cooler." |
| Tip of the Week: |
| This is an extensive C program that extracts lines from the Oracle alert log for a specified date (or date range). The lines extracted depend on the entries in a 'pattern' file. Included is the syntax and an example of a pattern file and a sample command. |
| >> |
Oracle alert log miner |
| Site Highlights | |
|
|
| Attend IOUG Live! |
| IOUG Live! 2002, April 14 - 18 in San Diego is THE Education Conference for Oracle Users by Oracle Users. Visit the IOUG web site to review session abstracts and register. |
| Register Today |
|
| Business Continuity |
| This workbook provides a guide to a topic more relevant now than ever. Click for details and ordering information. |
| Click Here |
|
| Free ITSM Whitepaper |
| Login to searchSystemsManagement to download a free copy of "A Practical Approach to IT Services Management Assessment" today! |
| Subscribe Today |
|
|
|
