"This is a book that deserves a prominent place by anyone who aspires to be a real professional developer of SQL Server applications." --from the Foreword by Ron Soukup The message of this book is that building stored procedures in Transact-SQL is very much like building programs in any other language. It requires the same type of skill, planning, attention to detail, and overall grasp of technology that successful development in other languages requires. To master Transact-SQL, one must first master the fundamental concepts of software development, then build on this foundation by embracing and studying Transact-SQL as a programming language in its own right. This book teaches you how to do that and more. More than just a catalog of coding tricks and syntax subtleties, explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML The Guru's Guide to Transact-SQL, this book teaches that stored procedure development does not occur in a vacuum--it involves a wide variety of skills, subjects, and technologies--and helps the reader become a better software engineer, not just a stored procedure expert. Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing to advanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source. Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming. The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code. Theoretically sound, yet immensely practical, provides developers with the tools they need to become expert stored procedure programmers and better software engineers. The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML 0201700468B11262001

PostgreSQL is an object-relational database server that is widely considered to be the world¿s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP. PostgreSQL Developer¿s Handbook provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/pgSQL, and the most important programming interfaces. The book introduces the reader to the language and syntax of PostgreSQL and then moves quickly into advanced programming topics.

This book is a hands-on tutorial for Access users who want to learn Access by working through solid examples. It will show the reader how to use Access and how to develop solid databases from start to finish. The focus of the book will be Access databases on the desktop but will have two chapters on implementing Access in a networked or client/server environment. Key topics include understanding relational databases and the Access 2002 architecture; designing, building, and maintaining full-feature, robust database applications; implementing Data Access Pages; working with Visual Basic for Applications and the Visual Basic Editor; and publishing Access content to the WWW or a company's intranet.

Dive into the details of DB2 Universal Database for iSeries advanced functions and database administration. This IBM Redbooks publication aims to equip programmers, analysts, and database administrators with all the skills and tools necessary to take advantage of the powerful features of the DB2 Universal Database for iSeries relational database system. It provides suggestions, guidelines, and practical examples about when and how to effectively use DB2 Universal Database for iSeries. This book contains information that you may not find anywhere else, including programming techniques for the following functions: - Referential integrity and check constraints - DRDA over SNA, DRDA over TCP/IP, and two-phase commit - DB2 Connect - Import and Export utilities This book also offers a detailed explanation of the new database administration features that are available with Operations Navigator in V5R1. Among the tools, you will find: - Database Navigator - Reverse engineering and Generate SQL - Visual Explain - Database administration using Operations Navigator With the focus on advanced functions and administration in this fourth edition of the book, we moved the information about stored procedures and triggers into a new book -- "Stored Procedures and Triggers on DB2 Universal Database for iSeries", SG24-6503.

This redbook is designed as a study guide for professionals wishing to prepare for the certification exam to achieve: IBM eServer Certified Specialist - pSeries AIX System Administration. The system administration certification validates a broad scope of AIX administration skills and the ability to perform general AIX software system maintenance. This redbook helps AIX administrators seeking a comprehensive and task-oriented guide for developing the knowledge and skills required for the certification. It is designed to provide a combination of theory and practical experience needed for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This redbook does not replace practical experience you should have, but is an effective tool that, when combined with education activities and experience, should prove to be a very useful preparation guide for the exam. Due to the practical nature of the certification content, this publication can also be used as a desk-side reference. So, whether you are planning to take the pSeries AIX System Administration certification exam, or if you just want to validate your AIX system administration skills, this redbook is for you.

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.

Building on the success of the first and second editions of The XML Companion, Neil Bradley has up-dated this accessible, in-depth reference to cover many of the new supporting standards that have emerged since XML was released in 1998. Apart from the core chapters on the XML standard itself, this book concentrates on related standards developed by the W3C and on the two most popular applications of this technology: document publishing and data exchange. The XML Companion Provides accessible, comprehensive description of each XML feature Does not assume experience of HTML or SGML Detailed study of the standard is supported by the inclusion of cross-referenced ‘roadmaps’ of the building blocks that comprise the standard. Includes an extensive glossary Related standards for cataloguing, processing, linking and styling XML are covered in detail.

"Dan's book provides something that the formal standards and development manuals sorely lack: a context that helps developers understand how to use XML in their own projects." --Tim Kientzle, Independent Software Consultant is a guide for Web developers and database programmers interested in building robust XML applications backed by SQL databases. It makes it easier than ever for Web developers to create and manage scalable database applications optimized for the Internet. XML and SQL: Developing Web Applications The author offers an understanding of the many advantages of both XML and SQL and provides practical information and techniques for utilizing the best of both systems. The book explores the stages of application development step by step, featuring a real-world perspective and many examples of when and how each technology is most effective. Specific topics covered include: Project definition for a data-oriented application Creating a bullet-proof data model DTDs (document type definitions) and the design of XML documents When to use XML, and what parts of your data should remain purely relational Related standards, such as XSLT and XML Schema How to use the XML support incorporated into Microsoft's SQL Server™ 2000 The XML-specific features of J2EE™ (Java™ 2 Enterprise Edition) Throughout this book, numerous concrete examples illustrate how to use each of these powerful technologies to circumvent the other's limitations. If you want to use the best part of XML and SQL to create robust, data-centric systems then there is no better resource than this book. 0201657961B10152001

Understand the theory behind system and component failures, their impact and subsequent cost to the Enterprise Learn about the leading-edge technologies used inside the Sun Cluster 3.0 software See how Sun Clusters enable Enterprises to deploy best practice cluster technology quickly and safely Designing Enterprise Solutions with Sun Cluster 3.0 is an introduction to architecting highly available systems with Sun servers, storage, and the Sun Cluster 3.0 software. Three recurring themes are used throughout the book: failures, synchronization, and arbitration. These themes occur throughout all levels of systems design. The first chapter deals with understanding these relationships and recognizing failure modes associated with synchronization and arbitration. The second and third chapters review the building blocks and describe the Sun Cluster 3.0 software environment in detail. The remaining chapters discuss management servers and provide hypothetical case studies in which enterprise solutions are designed using Sun technologies. Appendices provide a checklist for designing clustered solutions, additional information on Sun technologies used in many different types of clusters, guidelines for data center design best practices, and a brief description of some failure analysis tools used by Sun systems designers and architects.

This IBM Redbooks publication will help you to migrate the Siebel 2000 V6.2.1 database from: DB2 for NT V6 to DB2 for OS/390 V6 Oracle for NT V8.1.6 to DB2 for NT V6 Oracle for NT V8.1.6 to DB2 for OS/390 V6 The book describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the UK. It provides an overview of Siebel architecture, and introduces the migration methodology needed to move the Siebel database from a DB2/Oracle for NT platform to a DB2 for OS/390 platform. It offers a step-by-step description of the database migration process, and discusses in detail the different methods of moving data from one platform to the other. This book will be especially useful for those migrating the Siebel database for the first time.

PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include: PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java? Syntax and examples of all core language constructs Creating, using, and reusing stored procedures, functions, and packages Building web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages) Securing PL/SQL programs against attack Benefits of third-party developer tools and integrated development environments Connecting PL/SQL to email, Java, and the Internet Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. Learning Oracle PL/SQL was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention to detail has made other O'Reilly books (such as the bestselling Oracle PL/SQL Programming) very popular among Oracle developers worldwide. Learning Oracle PL/SQL is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to Oracle PL/SQL Programming, also by Pribyl and Feuerstein.

This IBM Redbooks publication shows the different techniques customers can use to clone their DB2 system. Although the scenarios in the book use an SAP workload, the DB2 cloning techniques we describe are not specific to SAP. Those techniques can apply to any DB2 system and the applications running on that DB2. The book describes hands-on details of selected DB2 database cloning scenarios, typically the most popular techniques currently used by customers, as well as the most efficient scenarios we would like to recommend to DB2 database administrators. The scenarios described in this book are based on SAP examples. Our source system resides on a DB2 data sharing group. We have one target system residing on another DB2 data sharing group and one residing on a non-data sharing DB2. All source and target systems are in the same OS/390 Sysplex environment. We discuss and show DB2 system cloning techniques using the following methods: - ESS Flashcopy - DFSMS copy and rename The book addresses an audience with in depth knowledge of DB2 for z/OS and OS/390 database administration and savy in SAP system requirements.

Since the first edition of this classic reference was published, World Wide Web use has exploded and e-commerce has become a daily part of business and personal life. As Web use has grown, so have the threats to our security and privacy--from credit card fraud to routine invasions of privacy by marketers to web site defacements to attacks that shut down popular web sites. Web Security, Privacy & Commerce goes behind the headlines, examines the major security risks facing us today, and explains how we can minimize them. It describes risks for Windows and Unix, Microsoft Internet Explorer and Netscape Navigator, and a wide range of current programs and products. In vast detail, the book covers: Web technology--The technological underpinnings of the modern Internet and the cryptographic foundations of e-commerce are discussed, along with SSL (the Secure Sockets Layer), the significance of the PKI (Public Key Infrastructure), and digital identification, including passwords, digital signatures, and biometrics. Web privacy and security for users--Learn the real risks to user privacy, including cookies, log files, identity theft, spam, web logs, and web bugs, and the most common risk, users' own willingness to provide e-commerce sites with personal information. Hostile mobile code in plug-ins, ActiveX controls, Java applets, and JavaScript, Flash, and Shockwave programs are also covered. Web server security--Administrators and service providers discover how to secure their systems and web services. Topics include CGI, PHP, SSL certificates, law enforcement issues, and more. Web content security--Zero in on web publishing issues for content providers, including intellectual property, copyright and trademark issues, P3P and privacy policies, digital payments, client-side digital signatures, code signing, pornography filtering and PICS, and other controls on web content. Nearly double the size of the first edition, this completely updated volume is destined to be the definitive reference on Web security risks and the techniques and technologies you can use to protect your privacy, your organization, your system, and your network.

A Netfinity Enabled for S/390, generally known as a Netfinity/EFS system, is the smallest S/390 fully supportedby IBM. It is based on a PC Server, running UNIX, and the S/390 emulation product FLEX-ES. FLEX-ES is a product of Fundamental Software, Incorporated (FSI) of Fremont, California. This package (the Server, UNIX, and FLEX-ES) is intended to run all current S/390 operating systems. This IBM Redbooks publication introduces the Netfinity/EFS system, describes the setup process of the system in some detail, and then describes the installation and use of a particular z/OS package known as the z/OS AD CD-ROM system. While this document is primarily directed at members of IBM's S/390 Partners in Development program (also known as PartnerWorld), most of the content applies to any Netfinity/EFS system.

This IBM Redbooks publication gives you information to use the IBM Enterprise Storage Subsystem with IBM DB2 Universal Database. Most of the information presented here applies to UNIX and Windows environments. Our examples are only for AIX. First, we supply an overview of the products that we use in our environment and introduce the terminology. Next, we discuss the configuration options available for these products and the methodology that we recommend for sizing an Enterprise Storage Subsystem for use with the DB2 Universal Database. We also discuss the challenges of mapping the system resources to the database activity in an ESS environment, and we discuss the diagnostic tools which are available and how to use them when working with performance issues. Then we discuss backup and recovery and explain some of the new features available with DB2 UDB V7.2, which enable some of the ESS capabilities. Last, we include our test examples. This book is intended to be read by systems administrators, storage specialists, database administrators and database specialists. We assume a base knowledge of either: ESS, AIX and/or DB2 and intend that this book will help you understand your area of expertise in a wider context.

Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital. The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.

This IBM Redbooks publication is designed to assist Oracle Database administrators and system/storage administrators with Oracle backup solutions using Tivoli Storage Manager V4.1. The primary tool we used for backup and recovery is Tivoli Data Protection (TDP) for Oracle V1.1, and the book covers setup and configuration of TDP as well as day-to-day management examples. Operating environments covered by the project are AIX, Sun Solaris, and Microsoft Windows 2000. We provide an overview of relational database management systems and how to plan for protecting them. This book will help you install, tailor, and configure Tivoli Storage Manager and Tivoli Data Protection for Oracle on UNIX and Microsoft Windows 2000 platforms in order to accomplish backup and restore of Oracle8i databases. RMAN commands and setup are covered in detail, and emphasis is placed on practical recovery scenarios. Also featured are new solutions utilizing Tivoli's hardware integration features for IBM's ESS intelligent storage subsystem, as well as an update on using TDP for Oracle V2.2 new features. Note: This book replaces relevant sections of the earlier book, Using ADSM to Back Up Databases, SG24-4335-03, by updating and re-branding the content of that book.

This book takes the reader from the architecture of .NET to real-world techniques they can use in their own Internet applications. The reader is introduced to .NET and Web Services and explores (in detail) issues surrounding the fielding of successful Web Services. Practical guidelines as well as solutions are provided that the rader may use in their own projects. Some of the issues involve lack of specific guidance in the SOAP specification, while others transcend SOAP and involve issues Internet developers have grappled with since the inception of the World Wide Web. At this time, this book has no competition.

A ThinkPad Enabled for S/390, generally known as a ThinkPad/EFS system, is the smallest S/390 currently available, and is intended for development and demonstration purposes. It is based on an IBM ThinkPad running Linux, and the S/390 emulation product FLEX-ES. FLEX-ES is a product of Fundamental Software, Incorporated (FSI) of Fremont, California. This package (the ThinkPad, Linux, and FLEX-ES) can run all current S/390 operating systems. This IBM Redbooks publication introduces the ThinkPad/EFS system, describes the setup process of the system in some detail, and then describes the installation and use of an OS/390 package known as the OS/390 AD CD-ROM system. While this publication is primarily directed at members of the IBM S/390 Partners in Development program (also known as PartnerWorld), most of the content applies to any ThinkPad/EFS system.

Reference Data for Engineers is the most respected, reliable, and indispensable reference tool for technical professionals around the globe. Written by professionals for professionals, this book is a complete reference for engineers, covering a broad range of topics. It is the combined effort of 96 engineers, scientists, educators, and other recognized specialists in the fields of electronics, radio, computer, and communications technology. By providing an abundance of information on essential, need-to-know topics without heavy emphasis on complicated mathematics, Reference Data for Engineers is an absolute "must-have" for every engineer who requires comprehensive electrical, electronics, and communications data at his or her fingertips. Featured in the Ninth Edition is updated coverage on intellectual property and patents, probability and design, antennas, power electronics, rectifiers, power supplies, and properties of materials. Useful information on units, constants and conversion factors, active filter design, antennas, integrated circuits, surface acoustic wave design, and digital signal processing is also included. The Ninth Edition also offers new knowledge in the fields of satellite technology, space communication, microwave science, telecommunication, global positioning systems, frequency data, and radar. * Widely acclaimed as the most practical reference ever published for a wide range of electronics and computer professionals, from technicians through post-graduate engineers. * Provides a great way to learn or review the basics of various technologies, with a minimum of tables, equations, and other heavy math.

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL. The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product. An added advantage to this book is that provides all reference material in two ways; alphabetically and by task. This is important because readers of the book will be looking for this information by both methods.

Publish and Subscribe is an effective way of disseminating information to multiple users. Publish/Subscribe applications can help to enormously simplify the task of getting business messages and transactions to a wide, dynamic and potentially large audience in a timely manner. This IBM Redbooks publication positions the MQSeries Publish/Subscribe to MQSeries Integrator Publish/ Subscribe. It will help you create, tailor and configure an application from publishing data through to subscribing via web pages. The books provides a broad understanding of a building and running an entire publish/subscribe solution. It will help give you a quick start to design and create a solution and then migrate it from MQSeries Publish/Subscribe to MQSeries Integrator Publish/Subscribe.

Strategic XML analyses the IT systems of a typical large corporation and gives specific, fully-functional examples that show how XML can solve problems today while positoning your company for the demands of tomorrow. Strategic XML addresses: XML Web content publishing, a simple workflow system, an offline order processing system, SOAP client and server examples, legacy system integration (using COBOL), and a unified Web and print documentation system based on XML and XSL.

A rigorous and practical framework for modeling business systems Pares object modeling down to its core concepts, making it easier than ever. Twelve object collaboration patterns that address virtually any business scenario Powerful techniques–not fancy notation! Streamlined Object Modeling presents the first rigorous, practical framework for object modeling complex business domains, rules, and systems. Three world-renowned leaders in object development have pared object modeling down to the core concepts for all business domains, business rules, and business services. Starting from the first principles of "object think," the authors offer a fully integrated approach to building, validating, and critiquing object models. Coverage includes: Proven principles and techniques for successfully modeling the structure and operations of any business domain. Guidelines for finding and associating objects, assembling object models, and distributing system behavior among objects. Rigorous methods for discovering, organizing, and implementing business rules around objects. Twelve all-encompassing "collaboration patterns"–what they represent, how they relate, and how to apply them. Five kinds of business rules, three types of services, and six categories of properties completely specify object-oriented business requirements From start to finish, the book makes extensive use of examples drawn from real commercial applications. To illustrate how streamlined object modeling flows from analysis to code, it also presents a complete case study derived from a real-world application, and implemented in two leading object-oriented languages-Java, and the Squeak implementation of Smalltalk.

Fast Connect for AIX, announced with AIX 4.3.2, was IBM's first step to let PCs take advantage of the performance, scalability, and reliability of AIX. The new version 3.1 adds powerful new features, such as user name mapping and remote password change. This IBM Redbooks publication walks you through the installation and the setup of Fast Connect on your server. It shows how to customize this product by declaring file shares, and print shares. Because security and ease of administration of the password databases on the network are two important tasks for the system administrator, this book describes which security models are available and how to set up your PC clients to communicate with the Fast Connect for AIX server. For its in depth coverage of the Fast Connect for AIX product, this book is a must-read for I/T specialists who have to recommend a solution for AIX and PC interoperability, as well as system administrators who have to implement such a solution.