___________________________ Sponsors ________________________________
IBM
ISPCON Fall 2007
_____________________________________________________________________
*********************************************************************
Database Journal Newsletter - Monday, September 17, 2007
The Knowledge Center for Database Professionals
http://www.databasejournal.com/
All newsletters are sent from the domain "internet.com." Please use this
domain name (not the entire "from" address, which varies) when configuring
e-mail or spam filter rules, if you use them.
*********************************************************************
/-------------------------------------------------------------------
You could save 30% on your database spending!
Don't be coerced into expensive support renewal contracts
or face penalties for unbundling components from the
contracts. This webcast explains how you could reduce your
database and storage costs. Featuring customer examples,
this webcast discusses license and support discounts that
can save you money immediately.
http://ad.doubleclick.net/clk;136406381;20325229;w?http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,cmv7,kx80,7s9g,a3ap
--------------------------------------------------------------adv.-/
*********************************************************************
FEATURES
*********************************************************************
1. Report Execution Caching I: SQL Server Management Studio Perspective
September 17, 2007
BI Architect Bill Pearson continues a three-part sub-series on
Caching Options within Reporting Services 2005. In this article, we
focus upon Report Execution Caching, and its configuration from SQL
Server Management Studio.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,hm5h,f08s,7s9g,a3ap
------------------------------------------------------------
2. SQL Server 2005 Express Edition - Part 6 - Post Installation
Configuration Tasks (Encryption)
September 14, 2007
Part 6 of this series continues the discussion of network-based
configuration tasks, describing other activities that alter default
connectivity settings applied during standard installation, focusing
in particular on encryption.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,efpb,cw0h,7s9g,a3ap
------------------------------------------------------------
3. Oracle's Transportable Automatic Workload Repository
September 13, 2007
Oracles Automatic Workload Repository provides a whole new way of
gathering, comparing and storing statistics. Read on to learn how AWR
differs from the old statspack reports.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,iuht,382t,7s9g,a3ap
------------------------------------------------------------
4. Making Database Administration Easier with Freeware
September 12, 2007
Cygwin, an OpenSSH application, helps relieve the stress of more
commonly seen administration problems, including not being able to
get a GUI tool (e.g., Oracle Universal Installer) to display and not
being able to have it display at the correct location.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,6p2m,9hbe,7s9g,a3ap
------------------------------------------------------------
5. Handling ASP.NET Errors at the Page and Application Level
While Try...Catch...Finally and ASP.NET custom error pages are both
error handling godsends, they're not the only error handling methods
available. This article will examine the Page_Error method and the
Application_Error event handler in order to help you round out your
ASP.NET error handling arsenal.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,4lf8,fd8p,7s9g,a3ap
------------------------------------------------------------
6. Examining ASP.NET 2.0's Membership, Roles, and Profile - Part 9
When working with Membership, you have the option of using .NET's
APIs or working directly with the specified provider. This article
examines the pros and cons of both approaches and examines the
SqlMembershipProvider in more detail.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,at84,i0b5,7s9g,a3ap
------------------------------------------------------------
7. Split Up Long Tables when Buffering
One of our readers wrote in and wanted to share a comment about how
browsers render long tables and the effect it has when you use buffering.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,h408,73i0,7s9g,a3ap
------------------------------------------------------------
*********************************************************************
/-------------------------------------------------------------------
ISPCON Fall 2007 - October 16-18, 2007, San Jose, CA -
ISPCON is where the service provider industry goes to GET REAL
about the future of their businesses. Isn't it time you increase ARPU?
Pump up profits? Optimize your operations? Find out what's next?
Whatever your plans, ISPCON will help you GET REAL about them.
This is the industry's only forum where peers learn from peers in real
one-on-one discussion about what works, what doesn't and what's
next. GET REAL! Get to ISPCON!
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,mfve,hfpd,7s9g,a3ap
--------------------------------------------------------------adv.-/
*********************************************************************
NEWS
*********************************************************************
1. From DBA to DWA
September 17, 2007
Everyone wants to know what a DBA does and it is becoming a hard
question to answer as the responsibilities and capabilities of
database platforms increase. Longtime author Vincent Rainardi brings
us the proposition of a new type fo DBA, one that focuses more on
data warehousing.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,3u34,3r1m,7s9g,a3ap
------------------------------------------------------------
2. MySQL Hosts Three Customer Conferences in London, Munich & Paris
September 14, 2007
MySQL AB will host three European Customer Conferences next month
with the theme, "Scaling the Modern Enterprise" -- in London on
October 16, in Munich on October 18, and in Paris on October 23.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,k1nr,4xki,7s9g,a3ap
------------------------------------------------------------
3. Ubuntu comes knocking on Oracle's door
September 14, 2007
Canonical has stated that its Ubuntu Server needs increased support
from independent software vendors and system builders.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,7gdx,fkdn,7s9g,a3ap
------------------------------------------------------------
4. Restore your SQL Server database using transaction logs
September 13, 2007
Most DBAs dread hearing that they need to restore a database to a
point in time, especially if the database is a production database.
However, knowing how to do this is of the utmost importance for a
DBA's skill set.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,2944,9nu7,7s9g,a3ap
------------------------------------------------------------
5. AquaFold's Aqua Data Studio free for Open Source Software Developers
September 13, 2007
AquaFold is announcing a new licensing policy which provides no-cost
Aqua Data Studio licenses to developers of Open Source Software.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,1tgy,39ot,7s9g,a3ap
------------------------------------------------------------
6. Embarcadero Releases ER/Studio 7.5 Data Modeling Tool with
Enhanced XML Support
September 13, 2007
Latest version supports XML schema generation and offers enhanced
logical/physical translation capabilities.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,18hd,7tp4,7s9g,a3ap
------------------------------------------------------------
7. Brand New SQL Management Studio for Oracle release
September 12, 2007
EMS Database Management Solutions are pleased to announce the release
of a new product - SQL Management Studio for Oracle - a complete
solution that unites all EMS database management tools for Oracle.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,ib3r,i234,7s9g,a3ap
------------------------------------------------------------
8. MySQL AB Previews New Open Source Database Products
September 12, 2007
MySQL AB today announced that it plans to release alpha and beta
versions of several new Free and Open Source Software (FOSS) products
this month, including a 'release candidate' of MySQL 5.1.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,9ev8,cypx,7s9g,a3ap
------------------------------------------------------------
9. Practice using Oracle's Remote Diagnostic Agent before you need it
September 11, 2007
Although the DBA can resolve most problems that arise with Oracle
databases, there are times when you need to file a Service Request
(SR) with Oracle Support. The Remote Diagnostic Agent (RDA) shortens
the time it takes for the Oracle engineer to become familiar with your system.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,b0vy,2wk3,7s9g,a3ap
------------------------------------------------------------
10. MySQL 5.1 Article Recap
September 11, 2007
Links and summaries for all the Dev Zone articles that discuss MySQL
5.1 features as well as links to many community member's blog
articles and tutorials.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,j4mv,est,7s9g,a3ap
------------------------------------------------------------
11. Mentat Technologies launch a subscription program
September 10, 2007
Mentat Technologies is now offering the option of subscription
licensing for their popular database tools for MySQL, Oracle and PostgreSQL.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,1q9r,1okv,7s9g,a3ap
------------------------------------------------------------
*********************************************************************
SQL SCRIPTS
*********************************************************************
1. Script to Display Current SQL Activity
September 17, 2007
A simple stored procedure for SQL Server 2000 (should work on SQL 7
as well) that lists users (like sp_who), locks (like sp_lock), and
the input buffers of blocked and blocking users.
http://nl.internet.com/ct.html?rtr=on&s=1,3gqo,1,lr3m,85ht,7s9g,a3ap
------------------------------------------------------------
*********************************************************************
You are subscribed to the Database Journal newsletter as peopleblog1.666news@blogger.com. To unsubscribe from Database Journal please go to:
http://member.internet.com/unsubscribe.php?type=NL&uid=58ad472f31&rid=1755
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Newsletter Subscription Dept.
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This email is powered by EmailLabs (http://www.emaillabs.com)
Contact us for a FREE demo
No comments:
Post a Comment