All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005 Manage database design Use Transact-SQL and XML Work with functions, triggers, and CLR integration Optimize, monitor, and secure databases Create stored procedures Handle disaster recovery Work with Service Broker, Web Services, and MARS Use SQL Server Reporting Services and Notification Services Manage locks, deadlocks, and cursors Transfer data using Replication and SQL Server Integration Services The CD-ROM features: Six full practice exams-two for each exam: 70-431, 70-441, & 70-442 Scripts from the step-by-step exercises in the book Video training clips from the author Complete electronic book

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Have a Google Maps mashup that you'd like to expose to millions of users on maps.google.com? New to the mapping craze, but have an idea for a killer map–based application? Want to learn how to create GeoRSS and KML feeds with your geotagged content, exposing your customer to new ways of exploring and navigating your content? Google Maps Mashups with Google Mapplets Is the first book to cover Google's Mapplet technology Shows you how to create Google Maps–based applications and publish to maps.google.com Provides a single–source resource and practical guide to Mapplets and mashups Teaches you how to mash up Mapplets using location–specific data Includes examples of real–world applications

Refocused and completely rewritten with the needs of business users and FileMaker Pro developers in mind, FileMaker Pro 9 Bible shows you how to design an industrial-strength database, make it intuitive, and automate it with scripts and programming. From the fundamentals to data modeling to writing no-fail code, you'll find the clear, step-by-step procedures, solid techniques, and detailed explanations you need to master this powerful software and build the right solutions for your needs.

With the introduction of Ferret, Ruby users now have one of the fastest and most flexible search libraries available. And it's surprisingly easy to use. This book will show you how to quickly get up and running with Ferret. You'll learn how to index different document types such as PDF, Microsoft Word, and HTML, as well as how to deal with foreign languages and different character encodings. Ferret describes the Ferret Query Language in detail along with the object-oriented approach to building queries. You will also be introduced to sorting, filtering, and highlighting your search results, with an explanation of exactly how you need to set up your index to perform these tasks. You will also learn how to optimize a Ferret index for lightning fast indexing and split-second query results.

This up-to-date “quick reference guide” is an easy, fast, and convenient way of learning SAP FI CO (including SAP R/3 4.70 Enterprise and SAP ERP(ECC)6.0); it also covers ABAP and Basis on the technical side, and MM, SD, and PP on the functional side to provide a thorough understanding of the SAP system. Separate sections on SAP Tables and SAP Transaction Codes guide you through the intricacies of the SAP modules and the 100-page section of SAP Terminology provides an excellent reference for mastering acronyms, codes, and definitions of the multiple components of this popular software.

This IBM® Redbook captures some of the best practices based on field experience and details the performance gains that can be achieved by implementing the IBM System Storage™ SAN Volume Controller. This book is intended for very experienced storage, SAN, and SVC administrators and technicians. Readers are expected to have an advanced knowledge of the SVC and SAN environment, and we recommend these books as background reading: IBM System Storage SAN Volume Controller, SG24-6423 Introduction to Storage Area Networks, SG24-5470 Using the SVC for Business Continuity, SG24-7371

This Wrox Blox explores Service Orientated Architecture and the Enterprise Service Bus, focusing on how it can be implemented using Microsoft BizTalk Server. It explains the need for SOA Architecture in an enterprise business and looks at the key Business and IT Drivers in business, how they can interact, and where there are conflicts that SOA can help resolve. Specifically, the author discusses Microsoft ESB Guidance and how, by using BizTalk 2006, ESB implementation can provide a solid platform for SOA development; management across the IT and Business Space with the Governance and tools provided in the ESB Toolkit; pointers to online resources, including guides on installing and deploying ESB; and how to avoid common SOA pitfalls. The target audience for this Wrox Blox is IT Managers, Business Managers, Architects, Developers, and Business Analysts who want to find architectural guidance information on Service Oriented Architecture, BizTalk, and Enterprise Service Bus.

Pro BizTalk 2006 is a high-end resource that is based on real feedback from BizTalk developers. Authors George Dunphy and Ahmed Metwally are well known within the BizTalk community, and here they cover topics not discussed in other books, like performance tuning, scalability, and administration. This book also features examples of specific, real-world implementations.

The purpose of this book is to remove the veil of secrecy surrounding SAP upgrade techniques and concepts, and to provide the user with a detailed description of the steps needed for a successful implementation. Today more than 12 million people in 120 countries who are working for 36,200 companies are using SAP on a regular basis. This popular, but very complex software system must be constantly reconfigured and upgraded to accommodate its latest releases. Upgrading SAP provides a complete overview of the process to upgrade from one SAP release to the next one and explains with detailed descriptions, the use of all relevant SAP upgrade tools. Along with a technical description of the SAP NetWeaver Application Server (AS), it also discusses personnel issues and the economic ramifications of such an upgrade project. Examples in this book are based on various different SAP products and releases, such as SAP NetWeaver 2004, 2004S (also known as NetWeaver 7.0 and 7.1), and SAP Business Suite 2005 with SAP ERP 6.0, BI, CRM, SCM, and SRM. Conceived as both a teaching book and as a reference manual, it covers all the techniques, background information, notes, tips, and tricks needed for any SAP upgrade project. A CD-ROM accompanies the book with templates and outlines for the upgrading process, as well as third-party SAP-related material.

In order to comply with government and industry regulations, such as Sarbanes-Oxley, Gramm-Leach-Bliley, and COBIT, enterprises have to constantly detect, validate, and report unauthorized change and out-of-compliance actions on their IT infrastructure. The Tivoli Compliance Insight Manager solution allows organizations to improve the security of their information systems by capturing comprehensive log data, correlating this data through sophisticated log interpretation and normalization, and communicating results through a dashboard and a full set of audit and compliance reporting. We discuss the business context of security audit and compliance software for organizations, and we show a typical deployment within a business scenario. This IBM Redbooks publication is a valuable resource for security officers, administrators, and architects who wish to understand and deploy a centralized security audit and compliance solution.

This book is part of the Deployment Guide series. It provides a step-by-step guide for deploying Tivoli Usage and Accounting Manager V7.1. It is intended to help an IBM or business partner service person to plan and perform the deployment of the product. Please note that the additional material referenced in the text is not available from IBM.

This IBM® Redbooks® publication follows The IBM System Storage Tape Libraries Guide for Open Systems, SG24-5946, and can help you plan, install, and configure IBM Ultrium LTO tape drives, as well as the TS1120 Tape Drive and libraries in i5/OS® environments. The book focuses on the setup and customization of these drives and libraries. The first part of the book gives an overview of the System i™ family of servers and describes how to attach and configure the drives and libraries. It also covers basic installation and administration. We describe the sharing and partitioning of libraries and explain the concept and usage of the Advanced Library Management System (ALMS). In the second part of the book, we document how to use these products with Backup Recovery and Media Services (BRMS), how to implement Tape Encryption, and how to use the IBM TS7520 Virtualization Engine™ with i5/OS. This book can help IBM personnel, Business Partners, and customers to better understand and implement the IBM Ultrium LTO product line, and also the TS1120 Tape Drive attached to System i servers. We assume that the reader is familiar with tape drives and libraries and has a basic understanding of System i servers and i5/OS.

Your Hands-On Guide to SAP Business Information Warehouse Give your company the competitive edge by delivering up-to-date, pertinent business reports to users inside and outside your enterprise. SAP Business Information Warehouse Reporting shows you how to construct Enterprise Data Warehouses, create workbooks and queries, analyze and format results, and supply meaningful reports. Learn how to use the BEx and Web Analyzers, Web Application Designer, Visual Composer, and Information Broadcaster. You will also find out how to forecast future business trends, build enterprise portals and websites, and tune performance. Group data into InfoCubes and DataStore Objects and generate reports using queries and workbooks Work with the BEx Analyzer, Web Analyzer, and Query Designer Build queries and reports using the Business Administration Workbench Add attachments and drill-through using Document Integration and RRI Format and distribute results using Report Designer and Information Broadcaster Extend functionality with Enterprise Portal, Data Modeling, and Visual Composer Deploy charts, maps, diagrams, and unit of measure conversions Predict trends and possible outcomes using SBC and Integrated Planning Generate HTML pages using Enterprise Reporting and Web Application Designer Create BI-based corporate Web and intranet sites using SAP Enterprise Portal

IBM Tivoli Monitoring Version 6.2 is a powerful monitoring product from IBM, that is easily customizable and provides real-time and historical data that enables you to quickly diagnose and solve issues through the IBM Tivoli Enterprise Portal component. This common, flexible, and easy-to-use browser interface helps users to quickly isolate and resolve potential performance problems. This IBM Redbooks publication presents a deployment guide for IBM Tivoli Monitoring V6.2. We cover planning, installing, and configuration of IBM Tivoli Monitoring V6.2 for small, medium, and large environments. In addition, we provide some case studies, such as IBM Tivoli Monitoring V5.x migration, event management integration, and Agent Builder. Agent Builder is a very powerful tool that you can use to develop your own monitoring agents. In order to show you how this tool can be used in a real life scenario, we have created a 30 minute video that you can launch from the ITSO Web site. We have also added an appendix that discusses IBM Tivoli Monitoring sales engagement planning for Business Partners and Solution Developers. The target audience for this documentation is IT Specialists and Business Partners who will be working on IBM Tivoli Monitoring V6.2 implementations and proof of concepts. Please note that the additional material referenced in the text is not available from IBM.

In this IBM® Redbooks® publication, we describe the capabilities and ways to use the IBM Tivoli® Application Dependency Discovery Manager (TADDM). It is becoming critical for enterprises to track the IT resources in their environment and, more importantly, the dependencies of their business applications on various components. TADDM provides rich capabilities that discover the components of a complex infrastructure and their interdependencies. In this book, we provide insight into the TADDM capabilities and architecture. We include recommended procedures for installing and configuring TADDM, tips and techniques for populating the TADDM database and customizing its use, performance considerations, and information about how TADDM integrates with operational management programs.

The IBM Tivoli Monitoring solution is the next generation of the IBM Tivoli family of products that help monitor and manage critical hardware and software in distributed environments. This IBM Redbooks publication provides a practical guide to implementing, using and optimizing IBM Tivoli Monitoring, including best practices for performance tuning, sizing, high availability, scalability, reporting, IBM Change and Configuration Management Database integration and firewall considerations.

In order to improve the performance and operational efficiency of businesses worldwide, a customer using SAP® wanted to establish a global business program to define and implement a standardized, group-wide business process architecture and associated master data for the parameterization of the group of software tools. The expected growth of the number of users and the size of the database would be at a level never reached by other customers, however, so IBM® was asked to undertake the following tasks: * Test the application to be sure that it can sustain such growth. This project illustrates the new near real time business intelligence (BI) context approached by customers who want the ability to rapidly analyze their business data to gain market shares. Data today comes from many diverse global sources and needs to be merged into an intelligent data warehouse. This IBM Redbooks® publication describes the testing that was done in terms of performance and manageability in an SAP NetWeaver® BI and DB2® environment on IBM System p™ when scaling a client's solution to a data warehouse of 60 terabytes (TB). This book resulted from a joint cooperative effort that included the PSSC, the IBM/SAP International Competency Center, the DB2-SAP Center of Excellence, SAP AG, and a customer. The customer involved in this project is a worldwide company employing more than 250,000 employees with factories and logistics operations in almost every country in the world. This project involved multiple technical skills and multiple products, as described here: * Chapter 1, "Project overview: business objectives, architecture, infrastructure, and results" on page 1, summarizes the entire project, starting from the business needs through the description of the environment and options used, to the results achieved. This chapter can be viewed as an executive summary from an IT specialist perspective. * Chapter 2, "The SAP NetWeaver BI perspective" on page 47; Chapter 3, "The DB2 perspective" on page 127; and Chapter 4, "The IBM System p perspective" on page 287, provide detailed views of the project from the perspectives of SAP specialists, DB2 specialists, and System p and AIX® specialists, respectively. * Chapter 5, "The system storage perspective" on page 319, and Chapter 6, "The Tivoli Storage Manager perspective" on page 349, describe the storage environment and the manageability issues in such a large environment. * Finally Appendix A, "The scripts used" on page 395, provides the scripts that we needed to develop for this project.

If you want to build dynamic Web sites that encourage users to interact with them, PHP and MySQL are among the best tools you’ll find. PHP is a scripting language designed specifically for use on the Web, while MySQL is a database management system that works with it perfectly. Best of all, they’re free. It’s hard to beat that combination! PHP & MySQL Web Development All-in-One Desk Reference For Dummies is kind of one-stop shopping for the information you need to get up and running with these tools and put them to good use. It’s divided into six handy minibooks that cover setting up your environment, PHP programming, using MySQL, security, PHP extensions, and PHP Web applications. They make it easy to create a Web site where visitors can sign on, use shopping carts, complete forms, and do business with your business. It’s easy to find what you need in this handy guide. You’ll discover how to: Find and acquire all the tools you need and set up your development environment Build PHP scripts to make your Web site work Create a MySQL database that visitors can access Summarize and sort data results Design and implement user access control Build a shopping cart application Create extensions that make your site more useful With PHP & MySQL Web Development All-in-One Desk Reference For Dummies by your side, you’ll be a Web site guru before you know it!

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you'll then learn how to identify and remove the problems that are causing poor performance. You'll discover preventive measures you can take to try to avoid a performance problem entirely and you'll learn how to achieve better performance.

This IBM® Redbooks® publication describes the IBM Tivoli® Composite Application Manager (ITCAM) family of products. The Composite Application Manager family currently consists of: - IBM Tivoli Composite Application Manager for WebSphere® The aim of IBM Tivoli Composite Application Manager is to simplify and enhance distributed application management. Application components can reside on multiple servers, across different platforms and J2EE environments, even through mainframes. The complexity of understanding and solving application-related problems, typically around performance issues, requires a cohesive set of tools to provide an end-to-end view of the application. The discussion that we provide in this book mainly consists of the basic installation and configuration of the products. The discussion is aimed at augmenting the information provided in the product manuals. Consult the appropriate product manual before starting to implement these products. We provide usage scenarios in this book as a demonstration of using these products in our sample environment. We use a single application environment that can be managed by all of the products.

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity.This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you’ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you’ll be coding more quickly, writing more efficient code, and applying the full power of SQL Filled with the insights of one of the world’s leading SQL authorities - noted for his knowledge and his ability to teach what he knows Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance) Presents clear guidance for selecting and correctly applying the right table technique

This book is written as part of the deployment guide series. It provides a step-by-step guide for deploying IBM® Tivoli® Composite Application Manager (ITCAM) for Web Resources V6.2. This deployment guide will help an IBM Business Partner or service person plan and perform the deployment of the product. The discussion on ITCAM for Web Resources describes product architecture and components, planning and sizing considerations, and guidelines on setting up service engagements. Although the information is highly relevant for larger deployment engagements, it is also suitable for a small deployment system. The extensive deployment and usage scenarios can also help you demonstrate the product.

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11 g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more