Databases-XdownX

Secrets of the Oracle Database
Posted: July 12th, 2009, 10:38pm CEST

Tags:    [edit]

File Name: Secrets of the Oracle Database
File Submitter: Nanflexal
File Submitted: 13 Jul 2009
File Category: Oracle


Product Description
Secrets of the Oracle Database is the definitive guide to undocumented and partially documented features of the Oracle database server. Covering useful but little–known features from Oracle9i Database through Oracle Database 11g, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well–tested, well–illustrated by clear examples, and sure to improve your ability to make an impact in your day–to–day work with Oracle.



What you’ll learn

• Take advantage of Oracle’s built–in Perl DBI distribution to write applications for monitoring, benchmarking, data extraction, and more.
• Interpret the undocumented, extended trace file format to pinpoint performance problems that TKPROF reports overlook and obscure.
• Get the most out of Statspack by using undocumented report formatting options, accessing its scarcely–documented repository, and integrating with SQL Trace.
• Take control of your instance through the ill–documented ORADEBUG command, enabling you to control processes, trace SQL statements, dump process state, monitor wait events and the call stack, and much more.
• Leverage undocumented features in Oracle’s built–in scheduler to better automate your workload.
• Take full advantage of Transparent Application Failover and Cluster Database Services in a Real Application Cluster environment.


Click here to download this file

Tags:    [edit]

File Name: Pro SQL Server 2008 Replication
File Submitter: Nanflexal
File Submitted: 13 Jul 2009
File Category: SQL Server 2008


Product Description
Pro SQL Server 2008 Replication is for MS database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication.

• Examines the detailed configuration and the internal workings of the different replication types using real–life scenarios
• Covers replication with database mirroring and troubleshooting
• Discusses replication administration using different tools

What you’ll learn

• Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using real–life scenarios.
• Gain insight into the internal workings of the different replication types.
• Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication.
• Perform administration tasks such as backup and recovery, and manage replication with other high–availability techniques like database mirroring and log shipping.
• Conduct optimization and tuning of replicated databases.
• Develop troubleshooting techniques.

Click here to download this file

Tags:    [edit]

File Name: Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards
File Submitter: Nanflexal
File Submitted: 13 Jul 2009
File Category: SQL Server 2008


Product Description
Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

The book begins by addressing the many misconceptions that surround the use of Key Performance Indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.

The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft’s BI tools, and gives detailed examples of successful dashboard implementations.



What you’ll learn

• The key functional and technical components of a successful report/dashboard implementation
• What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution
• How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way

Click here to download this file