"I can pretty much guarantee that anyone who uses SQL Server on a regular basis (even those located in Redmond working on SQL Server) can learn something new from reading this book." --David Campbell, Product Unit Manager, Relational Server Team, Microsoft Corporation The latest book from the highly regarded and best-selling author Ken Henderson, is the consummate reference to Microsoft SQL Server. Picking up where documentation and white papers leave off, this book takes an all-inclusive approach to provide the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning. The Guru's Guide to SQL Server Architecture and Internals Blending in-depth discussion with practical application, the guide begins with several chapters on the fundamental Windows technologies behind SQL Server, including processes and threads, memory management, Windows I/O, and networking. The focus then moves on to the architectural details of SQL Server and how to practically apply them. The entire SQL Server product is covered--not just the functionality that resides within the core executable or product features that have been in place for years. SQL Server has matured and broadened substantially with each release, and the author explores the "fringe" technologies that have yet to be covered elsewhere, including Notification Services, Full Text Search, SQLXML, replication, DTS, and a host of others. Throughout the book, the author uses WinDbg, Microsoft's free downloadable symbolic debugger, to look under the hood of SQL Server. Armed with new debugging and coding skills, readers will be ready to master SQL Server on their own. The accompanying CD-ROM is packed with additional material, including full source code for the book's 900+ examples, as well as three invaluable tools: DTSDIAG, the VBODSOLE Library, and DTS Package Guru. DTSDIAG allows developers and administrators to simultaneously collect Profiler traces, perform logs, blocking script output, system event logs, and SQLDIAG reports from a specified SQL Server. The VBODSOLE Library features more than twenty new COM-based functions for Transact-SQL, including T-SQL enhancements such as array-manipulation routines, financial functions, string-manipulation functions, and system functions. DTS Package Guru is a .NET-based package editor for SQL Server's Data Transformation Services that allows editing of any modifiable package and supports the automation of mass package changes. is the essential guide for database developers and admin- istrators alike, regardless of skill level. The Guru's Guide to SQL Server Architecture and Internals 0201700476B10012003

Enterprise Integration Patterns provides an invaluable catalog of sixty-five patterns, with real-world solutions that demonstrate the formidable of messaging and help you to design effective messaging solutions for your enterprise. The authors also include examples covering a variety of different integration technologies, such as JMS, MSMQ, TIBCO ActiveEnterprise, Microsoft BizTalk, SOAP, and XSL. A case study describing a bond trading system illustrates the patterns in practice, and the book offers a look at emerging standards, as well as insights into what the future of enterprise integration might hold. This book provides a consistent vocabulary and visual notation framework to describe large-scale integration solutions across many technologies. It also explores in detail the advantages and limitations of asynchronous messaging architectures. The authors present practical advice on designing code that connects an application to a messaging system, and provide extensive information to help you determine when to send a message, how to route it to the proper destination, and how to monitor the health of a messaging system. If you want to know how to manage, monitor, and maintain a messaging system once it is in use, get this book.

Praise for Effective XML “This is an excellent collection of XML best practices: essential reading for any developer using XML. This book will help you avoid common pitfalls and ensure your XML applications remain practical and interoperable for as long as possible.” — Edd Dumbill, Managing Editor, XML.com and Program Chair, XML Europe “A collection of useful advice about XML and related technologies. Well worth reading both before, during, and after XML application development.” — Sean McGrath, CTO, Propylon “A book on many best practices for XML that we have been eagerly waiting for.” — Akmal B. Chaudhri, Editor, IBM developerWorks “The fifty easy-to-read items cover many aspects of XML, ranging from how to use markup effectively to what schema language is best for what task. Sometimes controversial, but always relevant, Elliotte Rusty Harold’s book provides best practices for working with XML that every user and implementer of XML should be aware of.” — Michael Rys, Ph.D., Program Manager, SQL Server XML Technologies, Microsoft Corporation “ Effective XML is an excellent book with perfect timing. Finally, an XML book everyone needs to read! Effective XML is a fount of XML best practices and solid advice. Whether you read Effective XML cover to cover or randomly one section at a time, its clear writing and insightful recommendations enlighten, entertain, educate, and ultimately improve the effectiveness of even the most expert XML developer. I’ll tell you what I tell all my coworkers and customers: You need this book.” — Michael Brundage, Technical Lead, XML Query Processing, Microsoft WebData XML Team “This book provides great insight for all developers who write XML software, regardless of whether the software is a trivial application-specific XML processor or a fullblown W3C XML Schema Language validator. Mr. Harold covers everything from a very important high-level terminology discussion to details about parsed XML nodes. The well-researched comparisons of currently available XML-related software products, as well as the key criteria for selecting between XML technologies, exemplify the thoroughness of this book.” — Cliff Binstock, Author, The XML Schema Complete Reference If you want to become a more effective XML developer, you need this book. You will learn which tools to use when in order to write legible, extensible, maintainable and robust XML code. Page 36: How do you write DTDs that are independent of namespace prefixes? Page 82: What do parsers reliably report and what don't they? Page 130: Which schema language is the right one for your job? Page 178: Which API should you choose for maximum speed and minimum size? Page 257: What can you do to ensure fast, reliable access to DTDs and schemas without making your document less portable? Page 283: Is XML too verbose for your application? Elliotte Rusty Harold provides you with 50 practical rules of thumb based on real-world examples and best practices. His engaging writing style is easy to understand and illustrates how you can save development time while improving your XML code. Learn to write XML that is easy to edit, simple to process, and is fully interoperable with other applications and code. Understand how to design and document XML vocabularies so they are both descriptive and extensible. After reading this book, you'll be ready to choose the best tools and APIs for both large-scale and small-scale processing jobs. Elliotte provides you with essential information on building services such as verification, compression, authentication, caching, and content management. If you want to design, deploy, or build better systems that utilize XML—then buy this book and get going!

IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible. Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux®, UNIX®, or Windows®. The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team. They offer detailed, never-before-published technical guidance for the key challenges you'll face in delivering high-performance DB2 databases, e-business infrastructure, and enterprise integration solutions. Coverage includes: Simplifying management with the Configuration Advisor, HealthCenter(, and Memory Visualizer Integrating the enterprise via Federated Web Services and the DB2 enhanced XML productivity tools Maximizing database scalability, availability, and robustness Using multidimensional data clustering and other integrated business intelligence tools Integrating with IBM WebSphere and Microsoft software development tools Leveraging key improvements in DB2 SQL functionality The accompanying CD-ROM contains a complete trial version of IBM® DB2® Universal Database Personal Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus the DB2 demonstration program for trying out the various SQL commands on your own machine. If you're an experienced DB2 professional who's ready to take DB2 Version 8 to the max, DB2 Version 8: The Official Guide is the book you've been searching for.

Easy Microsoft Office Access 2003 takes the work out of learning this powerful database by using short, easy-to-follow lessons that show you how to accomplish basic tasks quickly and efficiently! It is the perfect book for beginners who want to learn Microsoft's database application through a visual, full-color approach. More than 100 hands-on lessons are designed to teach the easiest, fastest, or most direct way to accomplish common Access tasks. The book is suited for new Access users, as well as those upgrading from an earlier version.

Microsoft Access 11 is a powerful, relational database software package that makes it easier for you to create and manage complex databases. With Access, you can create a database quickly from scratch or by using and Access database Wizard. Once you¿ve created your database, Access provides all the tools you need to enter and manipulate data. Using Access, you can do the following: Quickly start a new database by using the Database Wizard. Create tables from scratch or by using a Wizard. Add and edit database information by using both tables and forms. Manipulate data in a number of tables by using queries and reports.

In just 24 sessions of one hour or less, the reader picks up all the skills needed to increase the effectiveness and reliability of Access applications. Using a straightforward, step-by-step approach, each lesson builds upon the previous one, allowing the reader to quickly learn the essentials of Access programming from the ground up. The book helps the reader to understand the fundamentals of the Access architecture, gain fast knowledge of the new features that Access offers, learn how to effectively use the latest tools and features of Access by following practical, real-world examples, and get expert tips from the best-selling author, Alison Balter. This book is designed for the way readers learn. They can go through each step-by-step chapter or just choose the lessons that interest them the most.

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003¿s new XML export/import features. The book¿s organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

This IBM Redbooks publication describes how to create and implement a federated data management environment. That environment can enable access to, and use of, multiple heterogeneous data sources as if they were all resident in the same data management system. We use Informix Dynamic Server (IDS) and DB2 as the primary data sources, along with Informix Extended Parallel Server (XPS), Red Brick Warehouse, Oracle9i, and Microsoft Excel as data sources. We also use data management tools, such as IBM DB2 Information Integrator and Informix Enterprise Gateway Manager, to provide the data federation. For data access tools, we use DB2 Command Center, Server Studio JE for Informix, and Brio Explorer to show data federation in action. With the combined functionality of the Informix and DB2 database management systems and the DB2 Information Integrator, you can implement a very powerful federated data management environment. Informix customers will be well positioned to take advantage of the expanded capabilities for integration through data federation, as well as future enhancements.

Teach yourself how to use the data management power of the latest version of Microsoft Access—one step at a time! Learn exactly the skills you need for Access 2003 through self-paced, easy-to-follow lessons and hands-on practice files.

"The book that Microsoft should have written, but didn't." —Jeremy Allison, Samba Team "Your detailed explanations are clear and backed-up with source code—and the numerous bits of humor make a dry subject very enjoyable to read." —J.D. Lindemann, network engineer, Adaptec, Inc. The first developer's guide to Microsoft®'s Internet/Intranet file sharing standard For years, developers and administrators have struggled to understand CIFS, Microsoft's poorly documented standard for Internet file sharing. Finally, there is an authoritative, cross-platform guide to CIFS capabilities and behavior. Implementing CIFS not only delivers the priceless knowledge of a Samba Team member dedicated to investigating the inner workings of CIFS, it also identifies and describes crucial specifications and supporting documents. Provides essential information for designing and debugging large Windows® and/or Samba networks Offers clear, in-depth introductions to Server Message Block (SMB), NetBIOS over TCP/IP (NBT), browser services, and authentication Drills down into the internals of CIFS, exposing its behavior on the wire and at the desktop—and its strange quirks Presents illustrative code examples throughout Reflects years of work reviewing obscure documentation, packet traces, and sourcecode Includes the SNIA CIFS Technical Reference Implementing CIFS will be indispensable to every developer who wants to provide CIFS compatibility—and every administrator or security specialist who needs an in-depth understanding of how it really works.

Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with this in-depth guide, straight from the source.

Rich Text Format, or RTF, is the internal markup language used by Microsoft Word and understood by dozens of other word processors. RTF is a universal file format that pervades practically every desktop. Because RTF is text, it's much easier to generate and process than binary .doc files. Any programmer working with word processing documents needs to learn enough RTF to get around, whether it's to format text for Word (or almost any other word processor), to make global changes to an existing document, or to convert Word files to (or from) another format.RTF Pocket Guide is a concise and easy-to-use tutorial and quick-reference for anyone who occasionally ends up mired in RTF files. As the first published book to cover the RTF format in any detail, this small pocket guide explains the syntax of RTF with examples throughout, including special sections on Unicode RTF and MSHelp RTF, and several full programs that demonstrate how to work in RTF effectively.Most word processors produce RTF documents consisting of arcane and redundant markup. This book is the first step to finding order in the disorder of RTF.

Everything a company needs to know to plan, organize, and perform an SAP implementation in one book! This is the only book available that shows the reader how to actually plan an SAP Data Center, install mySAP components, and set up the tools and processes necessary to monitor and manage a productive SAP system. It covers how to perform a Total Cost of Ownership analysis to help refine your SAP Solution Vision, and then how to leverage SAP¿s technology partners to work through the SAP system landscape sizing process. Staffing the project, from the SAP Steering Committee all the way down to the primary SAP basis and computer operations teams, is covered as well. It also covers building high availability and disaster recoverability into your solutions, addressing critical training required by the SAP support team as well as end users, and how to use SAP-provided and a host of other 3rd party tools to manage your mySAP landscape. Finally, this is the only book that covers in detail how to address both functional and stress testing of your solution prior to going live. Throughout the book, knowledge and processes are provided that will help you hit the ground running and help you save money. The book is written by an SAP Technical Certified Consultant with seven years of experience in SAP design and implementation who offers tried and proven approaches, scripts, and tools similar to those used by new and existing SAP customer sites. The accompanying CD of documents, presentations, scripts, checklists, and various tools valued at $50,000 saves time and makes the reader productive fast. Coverage includes notated screen shots of real productive systems; custom checklists, how-to procedures, organization charts that can be leveraged immediately for staffing teams; PowerPoint presentations that can be used by management to sell, present, and provide status updates on their mySAP projects internally; tools, utilities, and XLS spreadsheets used to design, size, and understand SAP system architectures; actual Microsoft Project plans and implementation schedules to get the customer and 3rd party Project Manager's started quickly; and documentation templates and approaches that may be used at once.

"This is an excellent book that combines a practical and analytical look at the subject." —Leo Korman, Principal Software Engineer, KANA Software As organizations begin to employ XML within their information-management and exchange strategies, data management issues pertaining to storage, retrieval, querying, indexing, and manipulation increasingly arise. Moreover, new information-modeling challenges also appear. —with its contributions from experts at the forefront of the XML field—addresses these key issues and challenges, offering insights into the advantages and drawbacks of various XML solutions, best practices for modeling information with XML, and developing custom, in-house solutions. XML Data Management In this book, you will find discussions on the newest native XML databases, along with information on working with XML-enabled relational database systems. In addition, thoroughly examines benchmarks and analysis techniques for performance of XML databases. XML Data Management Topics covered include: The power of good grammar and style in modeling information to alleviate the need for redundant domain knowledge Tamino's XML storage, indexing, querying, and data access features The features and APIs of open source eXist Berkeley DB XML's ability to store XML documents natively IBM's DB2 Universal Database and its support for XML applications Xperanto's method of addressing information integration requirements Oracle's XMLType for managing document centric XML documents Microsoft SQL Server 2000's support for exporting and importing XML data A generic architecture for storing XML documents in a relational database X007, XMach-1, XMark, and other benchmarks for evaluating XML database performance Numerous case studies demonstrate real-world problems, industry-tested solutions, and creative applications of XML data management solutions. Written for both XML and relational database professionals, provides a promising new approach to data management, one that is sure to positively impact the way organizations manage and exchange information. XML Data Management 0201844524B01302003

“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” – Sandra Barker, Lecturer, University of South Australia, Australia “Databases are a critical infrastructure technology for information systems and today’s business. Mike Hernandez has written a literate explanation of database technology–a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better.” – Michael Blaha, consultant and trainer, author of A Manager’s Guide to Database Technology “If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn’t have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!” – Matt Greer, Process Control Development, The Dow Chemical Company “Mike’s approach to database design is totally common-sense based, yet he’s adhered to all the rules of good relational database design. I use Mike’s books in my starter database-design class, and I recommend his books to anyone who’s interested in learning how to design databases or how to write SQL queries.” – Michelle Poolet, President, MVDS, Inc. “Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you’re just getting started developing with data or are a seasoned pro; whether you've read Mike’s previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself–this is the book for you. Mike’s ability to explain these concepts in a way that’s not only clear, but fun, continues to amaze me.” –From the Foreword by Ken Getz, MCW Technologies, coauthor ASP.NET Developer's JumpStart “The first edition of Mike Hernandez’s book Database Design for Mere Mortals was one of the few books that survived the cut when I moved my office to smaller quarters. The second edition expands and improves on the original in so many ways. It is not only a good, clear read, but contains a remarkable quantity of clear, concise thinking on a very complex subject. It’s a must for anyone interested in the subject of database design.” – Malcolm C. Rubel, Performance Dynamics Associates “Mike’s excellent guide to relational database design deserves a second edition. His book is an essential tool for fledgling Microsoft Access and other desktop database developers, as well as for client/server pros. I recommend it highly to all my readers.” – Roger Jennings, author of Special Edition Using Access 2002 “There are no silver bullets! Database technology has advanced dramatically, the newest crop of database servers perform operations faster than anyone could have imagined six years ago, but none of these technological advances will help fix a bad database design, or capture data that you forgot to include! Database Design for Mere Mortals™, Second Edition, helps you design your database right in the first place!” – Matt Nunn, Product Manager, SQL Server, Microsoft Corporation “When my brother started his professional career as a developer, I gave him Mike’s book to help him understand database concepts and make real-world application of database technology. When I need a refresher on the finer points of database design, this is the book I pick up. I do not think that there is a better testimony to the value of a book than that it gets used. For this reason I have wholeheartedly recommended to my peers and students that they utilize this book in their day-to-day development tasks.” – Chris Kunicki, Senior Consultant, OfficeZealot.com “Mike has always had an incredible knack for taking the most complex topics, breaking them down, and explaining them so that anyone can ‘get it.’ He has honed and polished his first very, very good edition and made it even better. If you're just starting out building database applications, this book is a must-read cover to cover. Expert designers will find Mike’s approach fresh and enlightening and a source of great material for training others.” – John Viescas, President, Viescas Consulting, Inc., author of Running Microsoft Access 2000 and coauthor of SQL Queries for Mere Mortals “Whether you need to learn about relational database design in general, design a relational database, understand relational database terminology, or learn best practices for implementing a relational database, Database Design for Mere Mortals™, Second Edition, is an indispensable book that you’ll refer to often. With his many years of real-world experience designing relational databases, Michael shows you how to analyze and improve existing databases, implement keys, define table relationships and business rules, and create data views, resulting in data integrity, uniform access to data, and reduced data-entry errors.” – Paul Cornell, Site Editor, MSDN Office Developer Center Sound database design can save hours of development time and ensure functionality and reliability. is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work. Database Design for Mere Mortals™, Second Edition, Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations. This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process. This book will give you the knowledge and tools you need to create efficient and effective relational databases.

Microsoft Access 2002 is a powerful, relational database software package that makes it easy to create and manage complex databases. With Access, users can create a database quickly from scratch or by using an Access database Wizard. Once the database is created, Access provides all the tools needed to enter and manipulate data. With the help of the Absolute Beginner's Guide, readers are able to quickly start a new database by using the Database Wizard, create tables from scratch or by using a Wizard, add and edit database information by using both tables and forms and manipulate data in a number of tables by using queries and reports. The book assumes absolutely no prior knowledge of the topic, and learning is easy because of the book's lighthearted but no-nonsense style. It serves as an excellent resource for users who are completely new to Access 2002 or who are upgrading from a previous version of the software.

XML Web services are the next logical step in the evolution of the Internet. Teach yourself how to write and deploy XML Web services for Microsoft® .NET?one step at a time—with this modular, accessible tutorial. It delivers expert, task-based instruction plus a real-world XML service example to help you apply what you already know about Microsoft Visual C#™, Microsoft Visual Basic® .NET, and object-oriented programming so that you can learn XML Web services development at your own pace.

XML is the de-facto standard for manipulating and sharing data among applications. It is supported by every major programming tool and language, including Java, Microsoft .NET, Oracle, SQL Server, etc. All professional developers and administrators - even those who don't intend to build XML applications - need a basic understanding of it just to read and maintain data they receive and process. Many of them don't have the time for a thick reference book or detailed tutorial. Sams Teach Yourself XML in 10 Minutes quickly covers the basics of XML and its family of related concepts, including basic syntax, DTDs, XML Schema, DOM, SAX, XSL, and XPath. Each topic is illustrated with an example to ensure readers' understanding.

Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.