;) |
|
|
In this Issue |
|
| >> |
From the editor:
Information overload |
| >> |
Featured Topic:
Business intelligence |
| >> |
Expert Technical Advice:
New expert advice, forum posts, and tech tips |
| >> |
Site Highlights:
* Web Services: Myths and
Realities with Daniel Sholler,
META Group Analyst
* "Maintaining Application
Availability: Five Real World
Tips to Creating a Bulletproof
Disaster Recovery Plan"
with Bill
Brunt, Product Marketing
Manager, Quest Software
* "Finding Business
Intelligence in Chaos: Data
Warehouse and the
Unstructured Data Problem",
with Shaku Atre, President,
Atre Group
|
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
You many think that SearchDatabase offers quite a bit of
free stuff for its members. But do you know just how much?
Well, I checked and even I was surprised at the incredible number of free
resources we offer DBAs, developers, and managers:
378 tips and scripts - These Oracle, SQL Server, DB2, SQL, and Java tips were submitted by our members or written by top gurus in the field. As always, the best tip received each month wins a cool prize.
602 expert answers - Our panel of 14
industry leaders and super-geeks have tackled your toughest
database brain-teasers, in categories such as Oracle, DB2,
SQL Server, database design, data warehousing, and
more.
63 live webcasts - Our popular
"Live Expert Q&A" sessions have featured the world's top
gurus and authors, including Bill Inmon, Joe Celko, Tom
Kyte, Fabian Pascal, Shaku Atre and many more.
3,025 discussion forum posts - You're almost guaranteed to get a quick
response in our famous "DBA Water Cooler" and other forums.
If you've been helped there, don't forget to help others in
need!
238 white papers - This brand new feature
is a compilation of quality white papers in over a dozen
categories, including business intelligence, enterprise
Java, XML, database administration, data security, and many
more.
2,700 web links Hand-picked tips, tutorials, and articles in 100+ DBMS-specific categories. Seriously, it's the best directory of its kind out there.
2,251 news stories - This is not news
collected by a robot or spider: it's manually selected and
summarized by our crack news team, who have also written 122
original news analyses.
That's not to mention 40 Featured Topics, thousands of
books and training courses, multiple e-mail newsletters, and
a targeted search engine. Whew! Of course, all of our
content has always been free and it always will be. Thanks
for your support, and be sure to tell your colleagues about
your favorite database site.
Till next time, Tim
|
|
|
Featured Topic: |
|
Business intelligence
by Tim DiChiara, Site Editor
Analytics, OLAP, data mining, or just plain old
data analysis--whatever you call it, it's hot. With database
size growing exponentially, it's also essential. Here
is our collection of the best BI analysis, tips, & advice...
Read more about this topic
|
|
|
Expert Technical Advice: |
|
Featured Expert Brian Peasland
Database Administrator, Raytheon,
Inc.
Category:Brian has been in the IT field for 14 years
working as a Computer Operator, Operations Analyst, Systems
Administrator, Application Developer, and finally, a
Database Administrator. He holds a B.S. in Computer Science
and a M.S. in Computer Science specializing in Database
Systems. Additionally, Brian holds OCP DBA credentials for
Oracle 7.3, 8, and 8i. Ask him your tough Oracle questions!
View all Brian's answers
|
|
This Week: In the forums
|
| >> |
SAP/DB2 and buffer pools
Member "NewDB2" is wondering if he can create
multiple buffer pools for tablespaces, or assign tables to a
buffer pool and indexes to a seperate buffer pool, or have
each tablespace have its own buffer pool. Go to our "DBA
Water Cooler" forum if you can lend NewDB2 a hand. |
| >> |
Cognos and Sybase problem
Member "perfspec" is using Cognos Impromptu to
connect to a Sybase DB and build 3D data cubes. The problem
that he's having is that when he runs the SQL from Impromptu
to build the cube, it doesn't use an index. Why? Go to our
"Data warehousing" forum if you can lend perfspec a hand. |
| Tip of the Week: |
| Many client-server applications do not close
their database connections when terminated abnormally or
should a user power off their client. This can result in
un-committted database updates blocking other database
connection updates. This stored procedure will kill the
blockers that have not issued a database command in the
specified number of seconds. |
| >> |
Kill blocking connections in SQL Server |
|
|
Site Highlights |
|
|
|
| Training Special |
| During the month of April, you can order the training CDROM "SQL Queries" at 25% off the regular price. Check it out! |
|
All Things SQL
|
|
| Live Expert Q&A |
| Shaku Atre will discuss "Finding Business Intelligence in Chaos: Data Warehouse and The Unstructured Data Problem" live on Tuesday. |
|
Pre-Register!
|
|
| Do you do Windows? |
| Beyond administration, the newsletter "Windows in the Enterprise" tackles the big-picture issues for those in Windows environments. Update your subscriptions today. |
|
Update Today!
|
|
|
|
