Today's Oracle professionals are challenged to protect their mission-critical data from many types of threats. Electronic data is being stolen is record amounts, and criminals are constantly devising sophisticated tools to breech your Oracle firewall. With advanced Oracle Forensics we can now proactively ensure the safety and security of our Oracle data, and all Oracle Forensics techniques are part of the due diligence that is required for all production databases. A failure to apply Forensics techniques to identify unseen threats can lead to a disaster, and this book is required reading for every Oracle DBA. This indispensable book is authored by Paul Wright, the world's top Oracle forensics expert, and the father of the field of Oracle Forensics. Packed with insights and expert tips, this is the definitive reference for all Oracle professional who are charged with protecting their valuable corporate information.

The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. To the SQL Server programmer, this means T-SQL code that behaves consistently and predictably in cases of unexpected usage, doesn't break under concurrent loads, and survives predictable changes to database schemas and settings. Inside this book, you will find dozens of practical, defensive programming techniques that will improve the quality of your T-SQL code and increase its resilience and robustness.

Improving database performance requires an equal mix of understanding theoretical concepts and working through hands-on examples. You'll find both here. Many of the examples given will be immediately useful for monitoring and improving your PostgreSQL deployments, providing insight into hard-to-obtain information about your database. This book is aimed at intermediate to advanced database administrators using or planning to use PostgreSQL. Portions will also interest systems administrators looking to build or monitor a PostgreSQL installation, as well as developers interested in advanced database internals that impact application design.

This is a practical, tutorial-style book that includes many examples to demonstrate the full potential of MySQL for Python. Every chapter starts with an explanation of the various areas for using MySQL for Python and ends with work on a sample application using the programming calls just learned. All complicated concepts are broken down to be very easy to understand. Everything in the book is designed to help you learn and use MySQL for Python to address your programming needs in the fastest way possible. This book is meant for intermediate users of Python who want hassle-free access to their MySQL database through Python. If you are a Python programmer who wants database-support in your Python applications, then this book is for you. This book is a must-read for every focused user of the MySQL for Python library who wants real-world applications using this powerful combination of Python and MySQL.

This is a hands-on walkthrough, from gathering information to creating a report to the presentation sections. It helps you to get accustomed to the software and gives an in-depth understanding of how to easily unleash the powerful functionality of the software. As a result you will be able to use the powerful functionalities of Oracle Hyperion Interactive Reporting 11 to drive important business decisions. The style of the book allows you to use it as a guide to walk through each chapter or as reference material while you work with the software. This book is for all Oracle Hyperion Interactive reporting users from novice to advanced. If you find yourself struggling while using this tool or you are new to the tool, this book will guide you through and make the learning process incremental.

This book is a comprehensive guide that shows developers how to design and develop business processes in BPEL efficiently. Throughout the book, the authors discuss important concepts and show real-world examples covering Oracle SOA Suite 11g and related products. This book is aimed at SOA architects and developers involved in the design, implementation, and integration of composite applications and end-to-end business processes. The book provides comprehensive coverage of WS-BPEL 2.0 for implementing business processes and developing SCA composite application, dealing with the issues of composition, orchestration, transactions, coordination, and security. This book uses Oracle SOA Suite 11g and related Oracle products. To follow this book you need to have basic knowledge of XML, web services, and Java EE.

This is a developer's guide and is written in a style suitable to professionals. The initial chapters cover the basic theory and principles of Q replication and WebSphere MQ. As the book advances, numerous real-world scenarios and examples are covered with easy-to-understand code. The knowledge gained in these chapters culminate in the Appendix, which contains step-by-step instructions to set up various Q replication scenarios. If you are a professional who needs to set up and administer a Q replication or Event Publishing environment, then this is the book you need. The book will give you a clear idea of how to implement Q replication on z/OS whether you work on Linux, Unix, or Windows operating system.

This book provides a practical, hands-on experience. Chapter by chapter, a Siebel CRM self-study environment is created which can be used to follow the examples described in the book to explore the Siebel functionality. The book ensures that you understand what you are doing and why you are doing it. It contains clear step-by-step instructions, explanatory tables, screenshots, and precise diagrams. This book is for administrators who want to develop and strengthen their Siebel CRM skills in the areas of installation and system management. Whether you are a novice or a more experienced user, this book will teach you something new in many ways and by the end of the book, you will be ready to install and manage Siebel CRM in a real-world environment.

This book is a comprehensive guide, split into three sections. The initial section of the book provides an introduction to the Oracle SOA Suite and its various components, and will give you an in-depth fast-paced hands-on introduction to each of the key components. The next section provides an in-depth best-practice guide to applying the various components of the SOA Suite to implement a real-world SOA-based solution; it illustrates this through the development of an auction site (oBay). The final section covers other considerations such as the packaging, deployment, testing, security, and administration of SOA applications. If you are a developer or a technical architect who works in the SOA domain, this book is for you. The primary purpose of the book is to provide you with a hands-on practical guide to using and applying the Oracle SOA Suite in the delivery of real-world composite applications. You need basic understanding of the concepts of SOA, as well as some of the key standards in this field, including web services (SOAP, WSDL), XML Schemas, and XSLT (and XPath).

In his new book, Brad's Sure Guide to SQL Server Maintenance Plans, Brad McGehee takes you on a comprehensive tour of two SQL Server tools designed to help DBAs ensure that a "required minimum" level of maintenance takes place on their SQL Server instances: the Maintenance Plan Wizard and the Maintenance Plan Designer. Table of Contents * Chapter 01: Why is Database Maintenance Important? Chapter 02: Before you Create any Maintenance Plans Chapter 03: Getting Started with the Maintenance Plan Wizard Chapter 04: Task Scheduling Chapter 05: Check database Integrity Task Chapter 06: Shrink Database Task Chapter 07: Rebuild Index Task Chapter 08: Reorganize Index Task Chapter 09: Update Statistics Task Chapter 10: Execute SQL Server Agent Job Task Chapter 11: History Cleanup Task Chapter 12: Define Back Up Database (Full) Task Chapter 13: Define Back Up Database (Differential) Task Chapter 14: Back Up Database (Transaction Log) Task Chapter 15: Maintenance Cleanup Task Chapter 16: Using the Maintenance Plan Designer Why read this book? Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly. The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering: * The intent of each task and why it's important * How to configure each task and what all the options mean * Scheduling considerations: when and how often should you run the task? * Customizing and extended your Maintenance Plans using the Designer Used carefully, these Maintenance Plan tools represent powerful time-saving devices for any DBA. At each stage of the book, Brad explains clearly the correct and incorrect uses for the tool, and indicates where more advanced solutions, using T-SQL or PowerShell scripting, would be more appropriate.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. The only book to cover and compare Oracle's online analytic processing products With the acquisition of Hyperion Systems in 2007, Oracle finds itself owning the two most capable OLAP products on the market--Essbase and the OLAP Option to the Oracle Database. Written by the most knowledgeable experts on both Essbase and Oracle OLAP, this Oracle Press guide explains how these products are similar and how they differ. Oracle Essbase & Oracle OLAP will help you architect the Oracle OLAP product that is most appropriate for your application, and build, tune, and maintain OLAP solutions.

This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Enterprise Manager 10g Grid ControlCentralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, implement top-down performance monitoring, and maximize system availability. Plan and carry out an Oracle Enterprise Manager 10g Grid Control rollout Set up customized metrics, alerts, thresholds, targets, and agents Manage IT resources from a centralized control console or the command line Manage your infrastructure using secure protocols Automate administrative tasks with Oracle's management agent Distribute business intelligence using the reporting and dashboard features Work with Oracle Enterprise Manager Database Control and Oracle Real Application Clusters Build physical and logical standby databases using Oracle Data Guard

This book uses the approach of a cookbook. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. It is designed to present what often appear as extremely complicated techniques as a series of simple-to-follow recipes, allowing readers to achieve high uptimes on their MySQL servers. This book is targeted at system administrators or database administrators who have basic familiarity with Linux, the shell, and MySQL. The typical user will be able to get MySQL installed and working, but needs practical guidance to make it highly available.

This book is designed to cover the problems that novice DBAs particularly struggle with. This handbook covers a minimal amount of theoretical information before showing you how to overcome common problems through the use of real-life examples. It covers both Oracle 11g R1 and 11g R2 in examples, with material applicable to all versions of Oracle. This book is for you if you find yourself in charge of an Oracle database. It can be easy to feel overwhelmed. Whether you are a single employee or the DBA manager of several employees, whether you are taking over an existing position or taking up a newly created one - this book is designed to be a sanity check. If you need guidance for migrating to 11g or implementing Oracle's Maximum Availability Architecture, you will find this book very helpful.

This Book, Written For Readers Who Have Little Or No Previous Experience With Databases, SQL, Or SQL Server, Provides A Very Systematic Approach To Learning SQL Using SQL Server. Each Chapter Is Written In A Step-By-Step Manner And Has Examples That Can Be Run Using SQL Server. Using The Sample Tables And Data Provided, The Reader Of This Book Will Be Able To Do All The Examples To Experience Hands-On SQL Programming In SQL Server. The Book Also Presents A Series Of Exercises At The End Of The Chapters To Help Readers Gain Proficiency With SQL. With This Book You Will Learn Beginning SQL Commands - How To Retrieve And Manipulate Data Using The Simple SELECT Statement; How To Customize SQL Server 2008'S Settings And About SQL Server 2008'S Functions; How To Create, Alter, Populate And Delete Tables; About Joins, A Common Database Mechanism For Combining Tables; Query Development, The Use Of Views And Other Derived Structures; Simple Set Operations; About Aggregate Functions; How To Write Subqueries And Correlated Subqueries; How To Create And Use Indexes And Constraints; Transaction Processing.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Fusion MiddlewareSuccessfully design rich enterprise web applications using the detailed information in this Oracle Press volume. Oracle Fusion Developer Guide goes beyond the predominant drag-and-drop methods in Oracle JDeveloper 11g and provides a wealth of examples that address common development scenarios when using Oracle Fusion Middleware. Work with Oracle JDeveloper 11g, define navigation rules, accept and validate user input, build page layouts and skins, and incorporate drag-and-drop functionality into web applications. This authoritative resource also explains how to secure and internationalize your applications. Understand the Oracle Application Development Framework and Oracle ADF Faces Rich Client lifestyle Construct Oracle ADF data controls, task flows, and dynamic regions Graphically represent information with Oracle ADF Faces DVT components Modularize applications using Oracle ADF libraries, Oracle ADF task flows, and other reusable components Define dynamic navigation rules in Oracle Fusion Middleware web applications Leverage Web 2.0 features using Oracle ADF Faces Rich Client components Control user access with Oracle WebLogic Server and Oracle ADF security For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle WebCenter 11gTransform your organization into a personalized, user-focused workplace using the detailed information in this comprehensive Oracle Press guide. Oracle WebCenter 11g Handbook shows you how to build Enterprise 2.0 applications that facilitate collaboration and foster innovation. You'll work with task flows and content systems, employ social networking tools, develop portals and composite applications, and deploy runtime customization. Debugging, security, and application tuning are also covered in this practical resource. Develop, test, and deploy dynamic enterprise applications, portals, and portlets Design data-backed rich Internet applications using Oracle JDeveloper 11g and Oracle WebLogic Server Work with Oracle Content Server and Oracle Secure Enterprise Search Customize applications at runtime using Oracle Composer and metadata services Use the resource catalog to deliver personalized search results to end users Integrate RSS feeds, forums, wikis, and blogs with Oracle WebCenter social computing services Implement the latest Oracle Application Development Framework security tools Extend functionality using mashups, composite applications, and third-party add-ons Understand the Web 2.0 and portal technologies behind Oracle Fusion Applications For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Take your MySQL skills to the top tierMaximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook. Understand MySQL's features, technical architecture, subsystems, and commands Make database design decisions that optimizre performance, storage, and reliability Write complex queries using joins, subqueries, and views Group SQL statements into transactions and execute them atomically Build and use sophisticated stored procedures and functions Automate database operations with triggers and scheduled events Import and export data in different formats, includiong SQL, CSV, and XML Optimize server and query performance Administer a secure, high availability MySQL RDBMS Manage users and control access Perform database maintenance, replication, backup, and recovery Vikram Vaswani is the founder and CEO of Melonfire (www.melonfire.com), a consultancy firm with special expertise in open-source tools and technologies. His previous books include MySQL: The Complete Reference, PHP: A Beginner's Guide, and PHP Programming Solutions.

SQL Server Profiler is one of the most useful of SQL Server's "built-in" tools, recording data about various SQL Server events. "Mastering SQL Server Profiler" will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems. All the examples have been optimized to work with both SQL Server 2005 and 2008.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

Excel 2007 VBA Programming with XML and ASP offers a hands-on approach for those looking to extend and customize Excel functionality. From recording a simple macro and writing VBA code to working with XML documents and using ASP to access and display data, this book takes you on a programming journey that will change the way you work with Excel Learn how to: * Automate spreadsheet tasks with macros. * Write VBA code to program PivotTables, generate charts, build dialog boxes, and customize the Ribbon. * Handle errors and debug programs. * Create hyperlinks and publish HTML files. * Retrieve data from the web directly into Excel. * Develop and manipulate smart tags using XML.

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written. The first ten chapters of the book are about administering the various areas of SQL Server, including the developer and business intelligence features. Chapter 1 briefly covers the architecture of SQL Server and the changing role of the DBA. Chapters 2 and 3 dive into best practices on installing and upgrading to SQL Server 2008. Managing your SQL Server database instance is talked about in Chapter 4. This chapter also describes some of the hidden tools you may not even know you have. Once you know how to manage your SQL Server, you can learn in Chapter 5 how to automate many of the redundant monitoring and maintenance tasks. This chapter also discusses best practices on configuring SQL Server Agent. Chapters 6 and 7 cover how to properly administer and automate many tasks inside of the Microsoft business intelligence products, such as Integration Services and Analysis Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the development features, such as SQL CLR. Chapter 9 explains how to secure your SQL Server from many common threats and how to create logins and users. Chapter 10 covers how to create a SQL Server project and do proper change management in promoting your scripts through the various environments. It also covers the Policy-Based Management framework in SQL Server. Chapters 11 through 15 make up the performance tuning part of the book. Chapter 11 discusses how to choose the right hardware configuration for your SQL Server in order to achieve optimal performance. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance for the best performance. Chapter 13 describes how to monitor your SQL Server instance for problematic issues such as blocking and locking. Chapters 14 and 15 discuss how to optimize the T-SQL that accesses your tables and then how to index your tables appropriately. Chapters 16 through 20 consist of the high-availability chapters of the book. Chapter 16 covers how to use the various forms of replication, while database mirroring is covered in Chapter 17. Classic issues and best practices with backing up and recovering your database are discussed in Chapter 18. Chapter 19 dives deeply into the role of log shipping in your high-availability strategy, and Chapter 20 presents a step-by-step guide to clustering your SQL Server and Windows 2008 server. This edition of the book covers all the same great information we covered in the last book, and we've added loads of new content for SQL Server 2008, which adds numerous new features to improve the DBA's life. In short, the new version of SQL Server focuses on improving your efficiency, the scale of your server, and the performance of your environment, so you can do more in much less time, and with fewer resources and people. This means you can manage many servers at one time using Policy-Based Management, scale your I/O load using compression, and collect valuable information about your environment using data collectors, to name just a few key new features. To follow the examples in this book, you will need to have SQL Server 2008 installed. If you wish to learn how to administer the business intelligence features, you need to have Analysis Services and the Integration Services components installed. You need a machine that can support the minimum hardware requirements to run SQL Server 2008; and you also need the AdventureWorks2008 and AdventureWorksDW2008 databases installed. Instructions for accessing these databases can be found in the ReadMe file on this book's Web site. Some features in this book (especially in the high-availability part) require the Enterprise or Developer Edition of SQL Server. If you do not have this edition, you will still be able to follow through some of the examples in the chapter with Standard Edition.