![]() |
|
|
In this Issue |
![]() |
![]()
![]()
|
|
From the Editor: |
![]() |
![]()
![]()
by Tim DiChiara, Site Editor
![]()
With databases growing exponentially, it's no wonder that storage management has become a major hot button issue in IT. Did you know that TechTarget launched a new magazine a few months ago specifically for storage professionals? It's called, prosaically enough, Storage. It's a very high quality publication; yet, like everything we do, it's free to those who qualify.
This month's cover story is partcularly appropriate for you DBAs out there: Get top performance from database storage. From the article: "As databases grew, administrators found that the only way to efficiently manage and expand database storage is to tap into the flexibility of SANs. However, with the expanded use of databases on storage networks, storage administrators now must deal with new performance, backup, restore and management issues-not to mention how to get along with the database administrators (DBAs). Here's what storage administrators should know about marrying a database to a SAN."
Other recent stories include:
- How to make your budget case
- What's the best network storage for databases?
- Prepare for petabytes now
I encourage you to check it out at storagemagazine.techtarget.com and let me know what you think.
Thanks, and have a great week, Tim
|
![]()
|
|
Featured Topic: |
![]() |
![]()
Stored procedure development
by Tim DiChiara, Site Editor
![]() Stored procedures increase the performance, flexibility, and
security of your DBMS. Here is a selection of our best tips and
expert advice about coding effective Oracle, SQL Server, and DB2
stored procedures and triggers.
![]()
Read more about this topic
|
![]()
|
|
Expert Technical Advice: |
![]() |
![]()
![]()
Featured Expert Mike Lampa,
CEO, BAG, Inc.
Category: Data warehousing
Mike is co-founder and CEO of BAG, a 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.
![]()
View all Mike's answers
|
![]()
|
This Week: In the forums
|
| >> |
Disk partition
Member "ynoel" is trying to partition his disk for
both Windows/DOS and Solaris but is running into errors. Can
anybody help? Go to our "DBA Water Cooer" forum if you can offer any advice. |
| >> |
INSERT statement troubles
Member "Ana" is trying to remember a SQL INSERT
statement that enables you can transfer data from one table to
another table from another database. Do you know? Go to our "DBA
Water Cooler" forum if you have an idea for "Ana." |
![]()
| Tip of the Week: |
| Indexes are created to enhance performance, but
often they are created with the same attributes, resulting in
redundant indexes. Over a period of time the number of such
indexes can grow, increasing the size of the DB2 catalog. This
extensive script for DB2 for OS/390 v7 can help you to indentify
all such indexes. |
| >> |
Identify redundant indexes in DB2 |
![]()
|
|
Site Highlights |
![]() |
![]()
![]()
|
![]() |
![]()
| Your opinion counts |
| Complete our member survey about your 2003 goals. Response is limited -- your input will play a key role in influencing what we cover in the coming months. |
![]()
Tell us more
|
|
![]()
![]()
| Data Center Futures |
| Get the newsletter that helps IT Managers see the future of the enterprise data center. Subscribe by December 6, 2002 for a chance to win a BlackBerry handheld! |
![]()
More info
|
|
![]()
| White paper library |
| Browse through the SearchDatabase.com White Paper Library today and do your research on topics including business intelligence, data warehousing, SQL Server and XML. |
![]()
Stay informed
|
|
![]()
|
![]() |
