Special Edition Using FileMaker 9 The only FILEMAKER 9 book you need We crafted this book to grow with you, providing the reference material you need as you move toward FileMaker® 9 proficiency and the use of more advanced features. If you buy only one book on FileMaker® 9, Special Edition Using FileMaker® 9 is the only book you need. Make the most of FileMaker 9: • Integrate the Web with FileMaker using the new Web Viewer • Use the new external data sources techniques with SQL and ODBC • Discover how to add supplemental fields in FileMaker to external SQL data sources • See how the major changes in script editing and debugging can help you • Learn new layout techniques, including conditional formatting and auto-resizing layout objects • Find out how to use the new FileMaker Server Admin Console to administer databases • Publish FileMaker databases on the Web using Instant Web Publishing, and use Custom Web Publishing with PHP or XML/XSLT “The new FileMaker 9 product line is the most dramatic new offering in years with over 30 ease-of-use breakthroughs; and Special Edition Using FileMaker 9 is an excellent desk reference and companion resource for all FileMaker professionals!” –Rick Kalman, Senior Product Manager, FileMaker, Inc. Jesse Feiler is a member of the FileMaker Business Alliance. He regularly consults on FileMaker and develops FileMaker solutions for small businesses, non-profits, art, retail point-of-sale, publishing, marketing, and other markets. He has created a number of video training courses, including one on FileMaker 7 and appears regularly on WAMC Northeast Public Radio’s Roundtable and Vox Pop shows. ON THE WEB Download modified FileMaker Starter solutions with added fields, scripts, and layouts to illustrate techniques in the book, along with other materials, from www.quepublishing.com and www.northcountryconsulting.com. Category Database Covers FileMaker 9 User Level Intermediate–Advanced

Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation's flagship database product. Learn what's new in Oracle that really counts See actual examples and test run output Make sound decisions on new feature adoption Sift the gold from the silt and discover which new features of the latest release of Oracle's flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real-world to help you get the most out of Oracle Database 11 g.

In this IBM® Redbooks® publication, we introduce the concept of cross-site mirroring (XSM) as implemented in IBM OS/400® or i5/OS® at V5R3M0 and later. XSM describes the replication of data at multiple sites. It involves the use of clustering, cluster resource groups (CRGs), independent auxiliary storage pools (IASPs), and other components. In this updated version, we include the new i5/OS V5R4 functions of Administrative Domain and Source Site Tracking. We also include preview information of the Target Site Tracking function. An additional component of this highly available technology is that XSM keeps two identical copies of an independent disk pool at two sites to provide high availability and disaster recovery. These sites can be geographically close to one another or far apart, depending on the needs of the business. This book is written for IBM technical professionals, Business Partners, and customers who are considering, planning, and implementing a highly available solution on the IBM System i5™ platform.

Expert Access 2007 Programming shows experienced developers how to create professional-level Access database applications. The authors—software engineers on the Access development team at Microsoft—show how to apply software engineering methodologies to Access application development. The book is organized to cover all phases of Access development. The authors demonstrate techniques for creating Access controls, forms, and reports that help streamline development and produce more user-friendly applications. They also cover such overlooked areas as custom deployment and documentation. The book contains many useful code examples designed so they can be used with minimal modification.

This Wrox Blox presents WPF along with the Extensible Application Markup Language (XAML), showing developers how to customize existing user interface controls such as the Button, Progress Bar, CheckBox, Radio Button, and Label along with creating two new custom controls. The Windows Presentation Foundation (WPF) released with the .NET 3.0 SDK provides a rich foundation for developing and customizing user interfaces. Unlike existing user interface development tools like GDI and GDI+, WPF is entirely vector-based, offering the developer enhanced two-dimensional and even three-dimensional rendering in the presentation layer. The author customizes these existing controls using XAML to: Create control templates to define their appearance and behaviors. Create two new custom controls, one derived from System.Windows.UserControl and the second from System.Windows.Control. Illustrate the interoperability of WPF content in Windows Forms and Win32 applications. Create the code samples using Microsoft Visual Studio 2005 with extensions for .NET 3.0 and the .NET 3.0 SDK. These code samples contain four projects: A C# WPF control library that contains the control templates and a User Control containing the customized Windows controls and the two new custom controls; a C# WPF application to host the WPF User Control; a C# Windows Forms application to host the WPF User Control; and a C++ Win32 application to host the WPF User Control. Usage Rights for Wiley Wrox Blox Any Wrox Blox you purchase from this site will come with certain restrictions that allow Wiley to protect the copyrights of its products. After you purchase and download this title, you: Are entitled to three downloads Are entitled to make a backup copy of the file for your own use Are entitled to print the Wrox Blox for your own use Are entitled to make annotations and comments in the Wrox Blox file for your own use May not lend, sell or give the Wrox Blox to another user May not place the Wrox Blox file on a network or any file sharing service for use by anyone other than yourself or allow anyone other than yourself to access it May not copy the Wrox Blox file other than as allowed above May not copy, redistribute, or modify any portion of the Wrox Blox contents in any way without prior permission from Wiley If you have any questions about these restrictions, you may contact Customer Care at (877) 762-2974 (8 a.m. - 5 p.m. EST, Monday - Friday). If you have any issues related to Technical Support, please contact us at 800-762-2974 (United States only) or 317-572-3994 (International) 8 a.m. - 8 p.m. EST, Monday - Friday).

Oracle is an enormous system, with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. " Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in feature set for working with location-based data. Authors Ravi Kothuri and Albert Godfrind address the special nature of spatial data and its role in professional and consumer applications. They also detail issues in spatial data management, such as modeling, storing, accessing, and analyzing spatial data, as well as the Oracle Spatial solution and the integration of spatial data into enterprise databases. In addition, they cover how spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users. When you read Pro Oracle Spatial for Oracle Database 11g, you're learning from the very best. Ravi Kothuri is a key member of Oracle's Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.

Data migration has become a mandatory and regular activity for most data centers. Companies today need to migrate data not only when a technology replacement is due, but also for other purposes such as consolidation, load balancing, and disaster recovery.

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, and chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. This book offers practical answers to some of the hardest questions faced by PL/SQL developers, including: What is the best way to write the SQL logic in my application code? How should I write my packages so they can be leveraged by my entire team of developers? How can I make sure that all my team's programs handle and record errors consistently? Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications. "This book presents ideas that make the difference between a successful project and one that never gets off the ground. It goes beyond just listing a set of rules, and provides realistic scenarios that help the reader understand where the rules come from. This book should be required reading for any team of Oracle database professionals." --Dwayne King, President, KRIDAN Consulting

The Berkeley DB Book is a practical guide to the intricacies of the Berkeley DB. This book covers in-depth the complex design issues that are mostly only touched on in terse footnotes within the dense Berkeley DB reference manual. It explains the technology at a higher level and also covers the internals, providing generous code and design examples. In this book, you will get to see a developer's perspective on intriguing design issues in Berkeley DB-based applications, and you will be able to choose design options for specific conditions. Also included is a special look at fault tolerance and high-availability frameworks. Berkeley DB is becoming the database of choice for large-scale applications like search engines and high-traffic web sites.

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more. Understand how to… Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services Harden a SQL Server implementation Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication Monitor a SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure the SQL Server Management Pack and install Operations Manager 2007 Automate SQL Server routine maintenance Encrypt SQL Server data and communications, including setting up a Certificate Authority Performance tune and troubleshoot a SQL Server environment Create Integration Services packages and transfer data On the Web: Download bonus chapters from www.informit.com/title/9780672329562 Introduction 1 Part I Administering SQL Server Components 1 Administering SQL Server 2005 Database Engine 11 2 Administering SQL Server 2005 Analysis Services 67 3 Administering SQL Server 2005 Reporting Services 99 4 Administering SQL Server 2005 Notification Services 149 5 Administering SQL Server 2005 Integration Services 183 6 Administering SQL Server Replication 209 Part II Managing SQL Server 2005 7 Conducting a SQL Server 2005 Health Check 261 8 SQL Server 2005 Maintenance Practices 289 9 Managing and Optimizing SQL Server 2005 Indexes 317 10 Managing Full-Text Catalogs 353 11 Creating Packages and Transferring Data 387 Part III Securing the SQL Server Implementation 12 Hardening a SQL Server 2005 Environment 435 13 Administering SQL Server Security 469 14 Encrypting SQL Server Data and Communications 509 The following chapters are located online: Part IV SQL Server 2005 Overview (located online) 15 SQL Server 2005 Technology Primer 537 16 Tools of the Trade 571 Part V Disaster Recovery and High Availability (located online) 17 Backing Up and Restoring the SQL Server 2005 Environment 597 18 Administering and Managing Failover Clustering 647 19 Administering and Managing Database Mirroring 691 20 Administering and Managing Log Shipping 721 Part VI Monitoring and Troubleshooting SQL Server (located online) 21 Monitoring SQL Server 2005 753 22 Performance Tuning and Troubleshooting SQL Server 2005 787 Appendix SQL Server 2005 Management and Administration 821

Add seamless, interactive, user-controlled delivery to your Flash applications. This book builds upon your understanding of basic ActionScript (AS) syntax with the foundational skills that you need to use XML in Flash applications and AS2 or AS3 to migrate your existing applications. Beginning with an introduction to XML, XML parsing methods, and a short introduction to AS2 you learn how to create a universal XML load/onload Class as well as a universal XHTML parser. Then you learn how to use Components using XML as the data source, including the menu, menubar, datagrid and tree component. Finally, a tutorial project-the design and development of a Real Estate Web site that contains an XML search engine-pulls it all together with hands-on experience. All the applications use XML as the data source and are written as class files. Select parts of the Real Estate Web site are redeveloped in AS3 for purposes of illustration. The new XML class is presented and specific code examples demonstrate techniques to apply methods and use properties. Particular attention is paid to the differences between AS2 and AS3 and how to effectively transition from one AS version to the other. The downloadable resources contain code for all of the properties and methods of the AS2, AS3, and XML class examples. Components for the Real Estate Web site project are also provided.

Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. You'll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a "Mere Mortal" will indeed be empowered to perform the superhuman. Do not walk past this book! --Graham Mandeno, Database Consultant provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries SQL Queries for Mere Mortals --Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3--the International SQL Standards Committee I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the "watch out for this trap" items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database. --Kenneth D. Snell, Ph.D., Database Designer/Programmer I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd's original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy. --Arvin Meyer, MCP, MVP Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what's usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I'm sure it'll get so much use that it won't spend much time on the shelf! -- Doug Steele, Microsoft Access Developer and author Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users. SQL Queries for Mere Mortals The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

This IBM Redbooks publication will illustrate the installation procedures of InfiniBand on the IBM System p5 with Linux and AIX 5L. InfiniBand adapters, switches, and network management software will be described in this publication. The IBM HPC stack will be tested with InfiniBand (Parallel Environment, LoadLeveler, GPFS, ESSL, and Parallel ESSL). Communication protocols such as MPI and LAPI will be tested and observations will be illustrated in this book. This book is the complete guide on how to implement InfiniBand on the IBM System p5. It is targeted at all IT professionals looking to understand what is behind the InfiniBand technologies, how to deploy it, and what is the IBM solution incorporating this technology.

What is IBM Electronic Services? Why do I need it? Where do you get it? When and how do you use it? How will this help you electronic support relationship with IBM? Find the answers to these questions and more details about IBM Electronic Services in this IBM Redbooks publication. The goal of IBM Electronic Services is to simplify your support relationship to make it easier and faster to do business with IBM. Through automation and Internet access, Electronic Services integrates the IBM Support community with your company staff and your IT environment. The two major components are IBM Electronic Service Agent™ (Service Agent) and the IBM Electronic Services Web site. IBM Electronic Services reaches across all IBM systems in all countries or regions where IBM does business. Electronic Services can provide the electronic support relationship for a single machine environment or a multinational complex of many servers. This book is intended for IT management, system operators, and other people who work for and with IBM clients. Prior to reading this book, you need to have a thorough understanding of your computer system and networking environments.

A new edition of this title is available, ISBN-10: 0789738201 ISBN-13: 9780789738202 The all-encompassing book about everything Google. Not only will you learn advanced search techniques, but you also will learn how to master Google’s web and software tools. It’s all inside! Blogger-create your own personal blog Gmail-Google’s web-based email service Google Web Search-the most popular search on the Internet Google AdSense-put profit-making ads on their own website Google AdWords-buy keyword advertising on the Google site Google Product Search-find hot deals without ever leaving your office chair Google Book Search-search the full text of selected books Google Calendar-a web-based scheduling and public calendar service Google Checkout-pay for your Web goodies and collect payments from people who buy from you Google Desktop-search documents and emails on your PC’s hard drive Google Directory-the best sites on the Web, picked by Google’s editors Google Docs & Spreadsheets-create and share web-based word processing and spreadsheet documents Google Earth-a fun way to view 3D maps of any location on Earth YouTube-view and share videos over the Web Google Groups-a collection of user-created message forums Google Image Search-search the web for pictures Google Maps-maps, satellite images, and driving directions for any location GOOGLE MAY BE THE INTERNET'S MOST POPULAR SEARCH SITE, BUT IT’S ALSO MORE THAN JUST SIMPLE WEB SEARCHES. • Use Google to search for news headlines, scholarly articles, and the best prices on the Web • Read and respond to blog postings and create your own blogs with Blogger • View the latest viral videos with YouTube • Create maps and driving directions with Google Maps • Use Google’s free web-based email service Gmail • Create your own custom Google Maps mashups–and put customized Google search on your own website Michael Miller has written more than 75 nonfiction how-to books, including Que’s Absolute Beginner’s Guide to Computer Basics, Tricks of the eBay Masters, and iPodpedia: The Ultimate iPod and iTunes Resource. Category Internet Covers Google User Level Intermediate to Advanced

John Morecroft's book is an ideal text for students interested in system modelling and its application to a range of real world problems. The book covers all that is necessary to develop expertise in system dynamics modelling and through the range of applications makes a persuasive case for the power and scope of the approach. As such it will appeal to practitioners as well as students. Robert Dyson, Professor of Operational Research, Associate Dean, Warwick Business School. Much more than an introduction, John Morecroft's Strategic Modelling and Business Dynamics uses interactive "management flight simulators" to create an engaging and effective learning environment in which readers, whatever their background, can develop their intuition about complex dynamic systems. The numerous examples provide a rich test-bed for the development of systems thinking and modelling skills John Sterman, Jay W. Forrester Professor of Management, MIT Sloan School of Management This book, with its vivid examples and simulators, will help to bring modelling, system dynamics and simulation into the mainstream of management education where they now belong. John A. Quelch, Professor of Marketing, Harvard Business School, Former Dean of London Business School This text fills the gap between texts focusing on the purely descriptive systems approach and the more technical system dynamics ones. Ann van Ackere, Professor of Decision Sciences, HEC Lausanne, Universit? de Lausanne Strategic modelling based on system dynamics is a powerful tool for understanding how firms adapt to a changing environment. The author demonstrates the appeal and power of business modelling to make sense of strategic initiatives and to anticipate their impacts through simulation. The book offers various simulators that allow readers to conduct their own policy experiments. Dr. Erich Zahn, Professor of Strategic Management, Betriebswirtschaftliches Institut, University of Stuttgart A website to accompany the book can be found at www.wiley.com/college/morecroft housing supplementary material for both students and lecturers.

This IBM Redbooks publication describes and documents a number of different aspects of the Software Configuration and Library Manager (SCLM). Part 1 of the book focuses on setting up an SCLM project using commonly used languages such as COBOL and PL/I. Additionally, migration techniques are discussed for those customers considering migrating to SCLM from other vendor Software Configuration Management products. Part 2 describes basic usage of SCLM functions such as Edit, Build, and Promote. Part 3 goes a bit beyond the basics and looks at some of the newer functions that are being added to SCLM, along with writing user exits and setting up SCLM for debugging with IBM Debug Tool. Parts 4, 5, and 6 concentrate on the SCLM Advanced Edition products such as Breeze, Enhanced Access Control, SCLM Developer Toolkit, and SCLM Administrator Toolkit. These sections describe what these products are and how they can be set up and used to aid your application development. Please note that the additional material referenced in the text is not available from IBM.