;) |
| �In this Issue | |
| �From the Editor | |
by Tim DiChiara, Site Editor
Last week, we ran a feature on searchDatabase.com about the top five terms entered in our search engine. That got me wondering: What are the top five issues in your own "search engine" -- that is, your brain? What are the most important concerns that you face every day in your job (besides staying employed)? For DBA's, these might be maximizing query performance, normalization, backup & recovery, and storage management, while developers might be mostly concerned with database design, writing stored procedures, or database-web connectivity. Or do you really spend most of your time putting out fires? Your input is important, so please email me your thoughts. Next week, I'll let you know how your peers voted and I'll tailor future content on the site to your needs. I look forward to hearing from you!
Cheers, Tim |
| �Featured Topic | |
SQL Tuning
by Tim DiChiara, Site Editor
A slow database is not only annoying to users, it can also affect your company's bottom line. The collection of SQL tuning tips, tutorials and expert advice in this week's Featured Topic will help you achieve maximal speed and reliability for your DBMS.
Read more about this topic
|
| �Expert Technical Advice | |
Featured Expert: Pat Phelan, Data Modeler
Category: Database Design
Have a question about designing a database for maximal performance, scalability, flexibility and reliability? This is the category for you! Our expert Pat Phelan will answer your toughest design questions here.
View all of Pat's answers |
| This Week in the Forums |
| >> |
Oracle and Windows NT logins
Forum poster "Laura" is still waiting for an answer! She was wondering how you can log in to NT with an external userid in order to submit a job to Oracle. Can you help? If so, go to our DBA Water Cooler Forum. |
| >> |
Connecting FileMaker with ASP
Forum poster "Mark" is having trouble connecting to a Filemaker database for an Intranet application via an Active Server Page using VBScript. Go to our Database-Web Connectivity Forum if you can help. |
| Tip of the Week: |
| There is a simple way in SQL to calculate the number of working days in a given month and year. This code can also pick up the holidays using a pre-defined HOLIDAY table and then substract them to give the actual number of working days in a particular month and year. |
| >> |
Calculating the number of working days in a month with SQL |
| �Site Highlights | |
|
|
| New: Faster Learning |
| Technology-based training (TBT) increases retention rates 30%-40%, saves 50% in training costs and is available on most IT subjects. Get a Free CD with 12 complete IT courses (regularly $360 + S&H). |
| Try TBT now! |
|
| HP and Compaq |
| How is this deal affecting the IT industry? What will it mean for you? Register to receive SearchHP News via email. It's FREE! |
| Stay informed |
|
| Oracle Tips Service |
| This week, we are sending our first Oracle-specific DBA Tip. Check off "Oracle Tips" in the "Tips and Columns" section today so you don't miss an issue. |
| Sign up today! |
|
|
|
